private static void SetSaveParameter(SqlCommand comm, QuterModuleSetModel model)
        {
            //设置参数

            comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //公司代码
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptID", model.DeptID));       //类型名称
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@QuarterNo", model.QuarterNo)); //创建人
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModuleID", model.ModuleID));   //启用状态
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@TypeID", model.TypeID));       //更新用户ID
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@Sign", model.Sign));           //更新用户ID
        }
Beispiel #2
0
    protected void imbSave_Click(object sender, ImageClickEventArgs e)
    {
        if (!string.IsNullOrEmpty(txtName.Text.Trim()))
        {
            int id;
            int sd = -1;
            if (this.QuterModelSelect.SelectedValue != "")
            {
                sd = Convert.ToInt32(this.QuterModelSelect.SelectedValue);
            }

            if (SaveQuarterSet(txtName.Text.Trim(), FCKeditor1.Value, sd, out id))
            {
                UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
                //设置公司代码

                IList <QuterModuleSetModel> QuterModuleSetList = new List <QuterModuleSetModel>();

                if (chMMubiao.Checked)
                {
                    if (chMRi.Checked)
                    {
                        QuterModuleSetModel dchMRi = new QuterModuleSetModel();

                        dchMRi.Sign           = "1";
                        dchMRi.ModuleID       = "1001";
                        dchMRi.QuterDescribID = id.ToString();
                        dchMRi.TypeID         = "1";

                        QuterModuleSetList.Add(dchMRi);
                    }
                    if (this.chMZhou.Checked)
                    {
                        QuterModuleSetModel dMZhou = new QuterModuleSetModel();

                        dMZhou.Sign           = "1";
                        dMZhou.ModuleID       = "1001";
                        dMZhou.QuterDescribID = id.ToString();
                        dMZhou.TypeID         = "2";

                        QuterModuleSetList.Add(dMZhou);
                    }
                    if (this.chMYue.Checked)
                    {
                        QuterModuleSetModel dMYue = new QuterModuleSetModel();

                        dMYue.Sign           = "1";
                        dMYue.ModuleID       = "1001";
                        dMYue.QuterDescribID = id.ToString();

                        dMYue.TypeID = "3";

                        QuterModuleSetList.Add(dMYue);
                    }
                    if (this.chMJi.Checked)
                    {
                        QuterModuleSetModel dMJi = new QuterModuleSetModel();

                        dMJi.Sign           = "1";
                        dMJi.ModuleID       = "1001";
                        dMJi.QuterDescribID = id.ToString();
                        dMJi.TypeID         = "4";

                        QuterModuleSetList.Add(dMJi);
                    }
                    if (this.chMNian.Checked)
                    {
                        QuterModuleSetModel dMNian = new QuterModuleSetModel();

                        dMNian.Sign           = "1";
                        dMNian.ModuleID       = "1001";
                        dMNian.QuterDescribID = id.ToString();
                        dMNian.TypeID         = "5";

                        QuterModuleSetList.Add(dMNian);
                    }
                }



                if (chRRenWu.Checked)
                {
                    if (chRGEren.Checked)
                    {
                        QuterModuleSetModel dchGEren = new QuterModuleSetModel();

                        dchGEren.Sign           = "1";
                        dchGEren.ModuleID       = "1011";
                        dchGEren.QuterDescribID = id.ToString();
                        dchGEren.TypeID         = "1";

                        QuterModuleSetList.Add(dchGEren);
                    }
                    if (this.chRZhipai.Checked)
                    {
                        QuterModuleSetModel dMZhipai = new QuterModuleSetModel();

                        dMZhipai.Sign           = "1";
                        dMZhipai.ModuleID       = "1011";
                        dMZhipai.QuterDescribID = id.ToString();
                        dMZhipai.TypeID         = "2";

                        QuterModuleSetList.Add(dMZhipai);
                    }
                }



                QuterModuleSetModel ModelchGgongzuo = new QuterModuleSetModel();

                ModelchGgongzuo.Sign = "1";
                if (chGgongzuo.Checked)
                {
                    ModelchGgongzuo.ModuleID       = "1021";
                    ModelchGgongzuo.QuterDescribID = id.ToString();
                }
                QuterModuleSetList.Add(ModelchGgongzuo);



                QuterModuleSetModel ModelchCricheng = new QuterModuleSetModel();

                ModelchCricheng.Sign = "1";
                if (chCricheng.Checked)
                {
                    ModelchCricheng.ModuleID       = "10411";
                    ModelchCricheng.QuterDescribID = id.ToString();
                }
                QuterModuleSetList.Add(ModelchCricheng);



                if (SaveQuarterSet(QuterModuleSetList))
                {
                    lblErrorMes.Visible = true;
                    lblErrorMes.Text    = "保存成功!";
                    ClearInput();
                }
                else
                {
                    lblErrorMes.Visible = true;
                    lblErrorMes.Text    = "保存失败!";
                }



                lblErrorMes.Text = "保存成功";
            }
            else
            {
                lblErrorMes.Text = "保存失败";
            }
        }
        else
        {
            lblErrorMes.Text = "请输入岗位名称";
        }
    }
    protected void imbSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
    {
        string EditFlag = hidEditFlag.Value.Trim();


        //定义Model变量
        DeptQuarterModel model = new DeptQuarterModel();

        //编辑标识
        model.EditFlag = EditFlag;
        string codeRules = string.Empty;
        //获取编号
        string quarterNo = string.Empty;

        if (!EditFlag.Equals("INSERT"))
        {
            //quarterNo = txtDisplayCode.Value.Trim();
            quarterNo = hfdNo.Value;
        }
        else
        {
            //获取编码规则ID
            codeRules = codeRule.GetCodeRuleID();
            //手工输入的时候
            if (codeRules == string.Empty)
            {
                quarterNo = codeRule.GetDisplaycode();
            }
        }

        //新建时
        if (ConstUtil.EDIT_FLAG_INSERT.Equals(model.EditFlag))
        {
            //编号为空时,通过编码规则编号获取编号
            if (string.IsNullOrEmpty(quarterNo))
            {
                //获取编码规则编号
                string codeRuleID = codeRule.GetCodeRuleID();
                //通过编码规则代码获取编号
                quarterNo = ItemCodingRuleBus.GetCodeValue(codeRuleID, ConstUtil.CODING_RULE_TABLE_DEPTQUARTER
                                                           , ConstUtil.CODING_RULE_COLUMN_DEPTQUARTER_NO);
            }
            //判断是否存在
            bool isAlready = PrimekeyVerifyBus.CheckCodeUniq(ConstUtil.CODING_RULE_TABLE_DEPTQUARTER
                                                             , ConstUtil.CODING_RULE_COLUMN_DEPTQUARTER_NO, quarterNo);
            //存在的场合
            if (!isAlready)
            {
                lblErrorMes.Visible = true;
                lblErrorMes.Text    = "该编号已被使用,请输入未使用的编号!";

                return;
            }
            else
            {
                lblErrorMes.Visible = false;
                lblErrorMes.Text    = " ";
            }
        }
        //设置岗位编号
        model.QuarterNo = quarterNo;


        //所属机构
        model.DeptID = txtDeptID.Value.Trim();
        //上级岗位
        model.SuperQuarterID = hidSuperQuarter.Value.Trim();
        //岗位名称
        model.QuarterName = txtQuarterName.Text.Trim();
        //拼音代码
        model.PYShort = txtPYShort.Text.Trim();
        //是否关键岗位
        model.KeyFlag = ddlKeyFlag.SelectedValue;
        //岗位分类
        model.TypeID = ddlQuarterType.SelectedValue;
        //岗位级别
        model.LevelID = ddlQuarterLevel.SelectedValue;
        //描述信息
        model.Description = txtDescription.Text.Trim();;
        //启用状态
        model.UsedStatus = ddlUsedStatus.SelectedValue;
        //附件
        model.Attachment     = hfAttachment.Value.Trim();
        model.PageAttachment = hfPageAttachment.Value.Trim();
        //岗位职责
        model.Duty = txtDuty.Text.Trim();
        //任职资格
        model.DutyRequire = txtDutyRequire.Text.Trim();

        //
        model.QuterContent = FCKeditor1.Value;



        bool isSucce = DeptQuarterBus.SaveDeptQuarterInfo(model);

        //保存成功时
        if (isSucce)
        {
            UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
            //设置公司代码

            IList <QuterModuleSetModel> QuterModuleSetList = new List <QuterModuleSetModel>();

            if (chMMubiao.Checked)
            {
                if (chMRi.Checked)
                {
                    QuterModuleSetModel dchMRi = new QuterModuleSetModel();
                    dchMRi.CompanyCD = userInfo.CompanyCD;
                    dchMRi.Sign      = "2";
                    dchMRi.ModuleID  = "1001";
                    dchMRi.QuarterNo = model.QuarterNo;
                    dchMRi.DeptID    = model.DeptID;
                    dchMRi.TypeID    = "1";

                    QuterModuleSetList.Add(dchMRi);
                }
                if (this.chMZhou.Checked)
                {
                    QuterModuleSetModel dMZhou = new QuterModuleSetModel();
                    dMZhou.CompanyCD = userInfo.CompanyCD;
                    dMZhou.Sign      = "2";
                    dMZhou.ModuleID  = "1001";
                    dMZhou.QuarterNo = model.QuarterNo;
                    dMZhou.DeptID    = model.DeptID;
                    dMZhou.TypeID    = "2";

                    QuterModuleSetList.Add(dMZhou);
                }
                if (this.chMYue.Checked)
                {
                    QuterModuleSetModel dMYue = new QuterModuleSetModel();
                    dMYue.CompanyCD = userInfo.CompanyCD;
                    dMYue.Sign      = "2";
                    dMYue.ModuleID  = "1001";
                    dMYue.QuarterNo = model.QuarterNo;
                    dMYue.DeptID    = model.DeptID;
                    dMYue.TypeID    = "3";

                    QuterModuleSetList.Add(dMYue);
                }
                if (this.chMJi.Checked)
                {
                    QuterModuleSetModel dMJi = new QuterModuleSetModel();
                    dMJi.CompanyCD = userInfo.CompanyCD;
                    dMJi.Sign      = "2";
                    dMJi.ModuleID  = "1001";
                    dMJi.QuarterNo = model.QuarterNo;
                    dMJi.DeptID    = model.DeptID;
                    dMJi.TypeID    = "4";

                    QuterModuleSetList.Add(dMJi);
                }
                if (this.chMNian.Checked)
                {
                    QuterModuleSetModel dMNian = new QuterModuleSetModel();
                    dMNian.CompanyCD = userInfo.CompanyCD;
                    dMNian.Sign      = "2";
                    dMNian.ModuleID  = "1001";
                    dMNian.QuarterNo = model.QuarterNo;
                    dMNian.DeptID    = model.DeptID;
                    dMNian.TypeID    = "5";

                    QuterModuleSetList.Add(dMNian);
                }
            }



            if (chRRenWu.Checked)
            {
                if (chRGEren.Checked)
                {
                    QuterModuleSetModel dchGEren = new QuterModuleSetModel();
                    dchGEren.CompanyCD = userInfo.CompanyCD;
                    dchGEren.Sign      = "2";
                    dchGEren.ModuleID  = "1011";
                    dchGEren.QuarterNo = model.QuarterNo;
                    dchGEren.DeptID    = model.DeptID;
                    dchGEren.TypeID    = "1";

                    QuterModuleSetList.Add(dchGEren);
                }
                if (this.chRZhipai.Checked)
                {
                    QuterModuleSetModel dMZhipai = new QuterModuleSetModel();
                    dMZhipai.CompanyCD = userInfo.CompanyCD;
                    dMZhipai.Sign      = "2";
                    dMZhipai.ModuleID  = "1011";
                    dMZhipai.QuarterNo = model.QuarterNo;
                    dMZhipai.DeptID    = model.DeptID;
                    dMZhipai.TypeID    = "2";

                    QuterModuleSetList.Add(dMZhipai);
                }
            }



            QuterModuleSetModel ModelchGgongzuo = new QuterModuleSetModel();
            ModelchGgongzuo.CompanyCD = userInfo.CompanyCD;
            ModelchGgongzuo.Sign      = "2";
            if (chGgongzuo.Checked)
            {
                ModelchGgongzuo.ModuleID  = "1021";
                ModelchGgongzuo.QuarterNo = model.QuarterNo;
                ModelchGgongzuo.DeptID    = model.DeptID;
            }
            QuterModuleSetList.Add(ModelchGgongzuo);



            QuterModuleSetModel ModelchCricheng = new QuterModuleSetModel();
            ModelchCricheng.CompanyCD = userInfo.CompanyCD;
            ModelchCricheng.Sign      = "2";
            if (chCricheng.Checked)
            {
                ModelchCricheng.ModuleID  = "10411";
                ModelchCricheng.QuarterNo = model.QuarterNo;
                ModelchCricheng.DeptID    = model.DeptID;
            }
            QuterModuleSetList.Add(ModelchCricheng);



            if (DeptQuarterBus.SaveQuarterSet(QuterModuleSetList))
            {
                lblErrorMes.Visible     = true;
                lblErrorMes.Text        = "保存成功!";
                hidEditFlag.Value       = ConstUtil.EDIT_FLAG_UPDATE;
                txtDisplayCode.Value    = model.QuarterNo;
                txtDisplayCode.Disabled = true;
                hidDeptInfo.Value       = model.DeptID;
                this.Page.ClientScript.RegisterStartupScript(this.GetType(), " ", " <script> SaveAfter(); </script> ");
            }
            else
            {
                lblErrorMes.Visible = true;
                lblErrorMes.Text    = "保存失败!";
            }
        }
        //保存未成功时
        else
        {
            lblErrorMes.Visible = true;
            lblErrorMes.Text    = "保存失败!";
        }
    }