/// <summary> /// 获取基础表信息 /// </summary> /// <param name="type">类型</param> /// <param name="code">code值</param> /// <returns>基础表信息</returns> public List <CodeDicItem> CodeDicItemList(string type, string code) { if (!string.IsNullOrEmpty(type)) { CodeDicItemListSql += "and type = '" + type + "' "; } if (!string.IsNullOrEmpty(code)) { CodeDicItemListSql += "and code = '" + code + "' "; } DataSet ds = DbHelperACE.Query(CodeDicItemListSql); List <CodeDicItem> list = new List <CodeDicItem>(); DataRowCollection drs = ds.Tables[0].Rows; for (int i = 0; i < drs.Count; i++) { CodeDicItem item = new CodeDicItem(); item.CODE = drs[i]["CODE"].ToString().Trim(); item.NAME = drs[i]["NAME"].ToString().Trim(); item.TYPE = drs[i]["TYPE"].ToString().Trim(); item.DSC = drs[i]["DSC"].ToString().Trim(); item.A1 = drs[i]["A1"].ToString().Trim(); item.A2 = drs[i]["A2"].ToString().Trim(); item.A3 = drs[i]["A3"].ToString().Trim(); list.Add(item); } return(list); }
private void btnSave_Click(object sender, RoutedEventArgs e) { PersonBasicInfo bi = this.cb_PersonList.SelectedItem as PersonBasicInfo; info.NAMEID = bi.NAMEID; info.NAME = bi.NAME; CodeDicItem cdI = this.cb_type.SelectedItem as CodeDicItem; info.INCIDENT = cdI.CODE; PersonRewardPunishInfoModel model = new PersonRewardPunishInfoModel(); bool isresult = false; if (IsModify == false) { isresult = model.InsertPersonRewardPunishInfo(info); } else { isresult = model.ModifyPersonRewardPunishInfo(info); } if (isresult) { MessageBox.Show("保存人员量化考核信息成功!"); this.Close(); } else { MessageBox.Show("保存人员量化考核信息失败 请确认后再进行保存!"); } }