/// <summary> /// 保存事件 /// </summary> /// <auth>Yanqiao.Cai</auth> /// <date>2013-01-04</date> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { try { string errorStr = CheckItem(); if (!string.IsNullOrEmpty(errorStr)) { DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show(errorStr); return; } List <DbParameter> parameters = new List <DbParameter>(); //名称、拼音、五笔 string groupName = this.txt_groupName.Text; if (string.IsNullOrEmpty(groupName)) { DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("组合名称不能为空"); return; } GenerateShortCode shortCode = new GenerateShortCode(m_app.SqlHelper); string[] code = shortCode.GenerateStringShortCode(groupName); SqlParameter param1 = new SqlParameter("@name", SqlDbType.Char); SqlParameter param2 = new SqlParameter("@py", SqlDbType.Char); SqlParameter param3 = new SqlParameter("@wb", SqlDbType.Char); param1.Value = groupName; parameters.Add(param1); if (null != code && code.Length >= 2) { param2.Value = null == code[0] ? string.Empty : code[0].ToString(); param3.Value = null == code[1] ? string.Empty : code[1].ToString(); parameters.Add(param2); parameters.Add(param3); } //病种IDs string IDs = string.Join("$", checkedList.Select(p => p["ICD"].ToString()).ToArray()); if (string.IsNullOrEmpty(IDs)) { DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("请在列表中勾选组合病种"); return; } SqlParameter param4 = new SqlParameter("@diseaseids", SqlDbType.Char); param4.Value = IDs; parameters.Add(param4); //是否有效 SqlParameter param5 = new SqlParameter("@valid", SqlDbType.Int); param5.Value = 1; parameters.Add(param5); if (groupID == -1) {//新增 //创建人 SqlParameter param6 = new SqlParameter("@create_user", SqlDbType.Char); param6.Value = DS_Common.currentUser.Id; parameters.Add(param6); //创建时间 SqlParameter param7 = new SqlParameter("@create_time", SqlDbType.Char); param7.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); parameters.Add(param7); } else {//编辑 //更新人 SqlParameter param8 = new SqlParameter("@updateuser", SqlDbType.Char); param8.Value = DS_Common.currentUser.Id; parameters.Add(param8); //更新时间 SqlParameter param9 = new SqlParameter("@updatetime", SqlDbType.Char); param9.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); parameters.Add(param9); } //备注 if (!string.IsNullOrEmpty(this.txt_memo.Text.Trim())) { SqlParameter param10 = new SqlParameter("@memo", SqlDbType.Char); param10.Value = this.txt_memo.Text; parameters.Add(param10); } //保存(插入、更新)组合记录 if (groupID == -1) { int result = DS_SqlService.InsertDiseaseGroup(parameters); if (result == 1) { DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("新增成功"); } } else { SqlParameter param10 = new SqlParameter("@id", SqlDbType.Int); param10.Value = groupID; parameters.Add(param10); int result = DS_SqlService.UpdateDiseaseGroup(parameters); if (result == 1) { DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("编辑成功"); } } if (this.chb_continue.Checked) {//连续新增 groupID = -1; ClearPage(); } else { this.Close(); } } catch (Exception ex) { DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show(1, ex); } }