void LoadTjxm()
{
if (txtDw.Text.Trim()=="")
{
txtDw.Tag = "";
}
DataTable dt = new DataTable();
dt = tjjgBiz.GetSzTjbg(comn.DateTimeChange(dtpFrom.Value.AddDays(-1)) + " 23:59:59",
comn.DateTimeChange(dtpTo.Value) + " 23:59:59",txtDw.Tag.ToString());
if (dt.Rows.Count > 0)//已存在记录
{
dtTjhz.Rows.Clear();
// ,,,,,,,,,
cmbRylb.Text = dt.Rows[0]["rylb"].ToString().Trim();
strBgid = dt.Rows[0]["bgid"].ToString().Trim();
maxdate = Convert.ToDateTime(dt.Rows[0]["maxdate"].ToString().Trim());
mindate = Convert.ToDateTime(dt.Rows[0]["mindate"].ToString().Trim());
txtDw.Text = dt.Rows[0]["dwmc"].ToString().Trim();
txtDw.Tag = dt.Rows[0]["sjdw"].ToString().Trim();
txtTjrs.Text = dt.Rows[0]["tjrs"].ToString().Trim();
txtTjxm.Text = dt.Rows[0]["tjxm"].ToString().Trim();
//txtTjjl.Text = dt.Rows[0]["tjjl"].ToString().Trim();
richTextBox1.Text = dt.Rows[0]["tjjl"].ToString().Trim();
DataRow row;
for (int i = 0; i < dt.Rows.Count; i++)
{
row = dtTjhz.NewRow();
row["gz"] = dt.Rows[i]["gz"].ToString().Trim();
row["rs"] = dt.Rows[i]["zrs"].ToString().Trim();
row["ycrs"] = dt.Rows[i]["jkycrs"].ToString().Trim();
row["zyjkyc"] = dt.Rows[i]["zyycrs"].ToString().Trim();
row["dwmc"] = dt.Rows[i]["sjdw"].ToString().Trim();
row["whys"] = dt.Rows[i]["whys"].ToString().Trim();
dtTjhz.Rows.Add(row);
dtTjhz.AcceptChanges();
}
dgvTjhz.DataSource = dtTjhz;
}
else//不存在记录的
{
MessageBox.Show("没有该单位的数据!", "提示");
return;
}
}
