コード例 #1
0
        /// <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);
            }
        }