public List<DataContract.ClinicInCharge.Records_Moneys> Load(int deptid,string listname)
{
string sql, err;
sql = string.Format(@"select deptid,dept_code + dept_name as listname
from {0} where isuse=1 and duty=1 ", Tables.tbDeptList);
sql += " order by dept_code";
DataTable dt = SqlHelper.QueryFromDatabase(ThisConn.sCono, sql, out err);
SqlHelper.ExecuteSQL(ThisConn.sCono, sql, out err);
if (err.Length > 0)
{
throw new Exception(err);
}
return DataConverter.DataTableToIList<DataContract.ClinicInCharge.Records_Moneys>(dt).ToList();
}
private void FrmRecords_Money_Load(object sender, EventArgs e)
{
try
{
string listname = DataConverter.EyeNull(cbodept.SelectedValue);
entity . deptid = DataConverter.ToInt(cbodept.SelectedValue);
dal.Load(entity.deptid, listname);
if (listname !="")
{
if (inputdeptid > 0)//判断是否为财务科?
{
btnImport.Show();
btnsetuser2.Show();
btnsetuser.Show();
btndelete.Show();
btnsave.Show();
tabControl1.TabPages.Remove(tabPage3);//使tabControl1不显示
tabControl1.TabPages.Remove(tabPage5);
}
else
{
btnImport.Hide();
btnsetuser2.Hide();
btnsetuser.Hide();
btndelete.Hide();
btnsave.Hide();
DataRow r;
r = dt.NewRow();
r["deptid"] = 0;
r["listname"] = "所有";
dt.Rows.InsertAt(r, 0);
}
entity.RecordUser = Share1.user_code + Share1.user_name;
DataTable dttime = DataConverter.GetMonthsList(DataConverter.ToDateTime("2018-01-01"), DateTime.Now.Date);
cbotime.DataSource = dttime;
cbotime.DisplayMember = dttime.Columns["monthsname"].ToString();
cbotime.ValueMember = dttime.Columns["months"].ToString();
cbotime.SelectedValue = DateTime.Now.AddMonths(-2).ToString("yyyy-MM-01");//两个月之内的记录
cbodept.DataSource = dt;
cbodept.DisplayMember = dt.Columns["listname"].ToString();//未将对象引用到实例
cbodept.ValueMember = dt.Columns["deptid"].ToString();
cbodept.SelectedValue = inputdeptid;
bselect = true;
btnQuery_Click(sender, e);
}
}
catch (Exception ex)
{
ThisHQ.Base.Base.SuMsg(ex.Message);
}
}
listname为空要怎么解决?
怎么让cbodept控件上面有值?我觉得就是这个的问题