private void btnSync_Click(object sender, EventArgs e)
{
try
{
OperDicDal.DelOperDic(DateTime.Now);
DB2help db2 = new DB2help();
var dt = db2.GetHisOperNameAll("");
foreach (DataRow dr in dt.Rows)
{
//LogHelp.WriteLog(dr["ITEMNAME"].ToString(),
// dr["ITEMID"].ToString(),
// dr["SSDJ"].ToString(),
// dr["SSQK"].ToString(),
// dr["INPUTSTR"].ToString());
//ITEMID 编码, ITEMNAME 手术名称,SSDJ 手术等级,SSQK 手术切口,INPUTSTR
var res = OperDicDal.InsertOperDic(
dr["ITEMNAME"].ToString(),
dr["ITEMID"].ToString(),
dr["SSDJ"].ToString(),
dr["SSQK"].ToString(),
dr["INPUTSTR"].ToString()
);
}
BindDatasource();
}
catch (Exception ex)
{
LogHelp.WriteLog(ex.ToString());
MessageBox.Show(ex.Message);
}
}
private void BindDatasource()
{
var res = OperDicDal.GetOperDic();
dgvOper.DataSource = res;
if (res != null)
{
tbCount.Text = res.Rows.Count.ToString();
}
else
{
tbCount.Text = "0";
}
}
