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"; } }