Example #1
0
        /// <summary>
        /// 编辑组织机构信息
        /// </summary>
        /// <param name="model">保存信息</param>
        /// <returns></returns>
        public static bool SaveDeptInfo(DeptModel model)
        {
            //获取登陆用户信息
            UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
            //设置公司代码
            model.CompanyCD = userInfo.CompanyCD;
            model.ModifiedUserID = userInfo.UserID;
            //定义返回变量
            bool isSucc = false;
            //操作日志
            LogInfoModel logModel = InitLogInfo(model.DeptNO);

            //更新
            if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag))
            {
                try
                {
                    logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
                    //执行更新操作
                    isSucc = DeptInfoDBHelper.UpdateDeptInfo(model);
                }
                catch (Exception ex)
                {
                    //输出系统日志
                    WriteSystemLog(userInfo, ex);
                }
            }
            //插入
            else
            {
                try
                {
                    logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
                    //执行插入操作
                    isSucc = DeptInfoDBHelper.InsertDeptInfo(model);
                }
                catch (Exception ex)
                {
                    //输出系统日志
                    WriteSystemLog(userInfo, ex);
                }
            }
            //更新成功时
            if (isSucc)
            {
                //设置操作成功标识
                logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
            }
            //更新不成功
            else
            {
                //设置操作成功标识 
                logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
            }

            //登陆日志
            LogDBHelper.InsertLog(logModel);

            return isSucc;
        }
        /// <summary>
        /// 添加组织机构信息
        /// </summary>
        /// <param name="model">组织机构信息</param>
        /// <returns></returns>
        public static bool InsertDeptInfo(DeptModel model)
        {

            #region 插入SQL拼写
            StringBuilder insertSql = new StringBuilder();
            insertSql.AppendLine(" INSERT INTO officedba.DeptInfo ");
            insertSql.AppendLine("            (CompanyCD          ");
            insertSql.AppendLine("            ,DeptNO             ");
            insertSql.AppendLine("            ,SuperDeptID        ");
            insertSql.AppendLine("            ,PYShort            ");
            insertSql.AppendLine("            ,DeptName           ");
            insertSql.AppendLine("            ,AccountFlag        ");
            insertSql.AppendLine("            ,SaleFlag           ");
            insertSql.AppendLine("            ,SubFlag            ");
            insertSql.AppendLine("            ,Address            ");
            insertSql.AppendLine("            ,Post               ");
            insertSql.AppendLine("            ,LinkMan            ");
            insertSql.AppendLine("            ,Tel                ");
            insertSql.AppendLine("            ,Fax                ");
            insertSql.AppendLine("            ,Email              ");
            insertSql.AppendLine("            ,Duty               ");
            insertSql.AppendLine("            ,UsedStatus         ");
            insertSql.AppendLine("            ,Description        ");
            insertSql.AppendLine("            ,ModifiedDate       ");
            insertSql.AppendLine("            ,ModifiedUserID)    ");
            insertSql.AppendLine("      VALUES                    ");
            insertSql.AppendLine("            (@CompanyCD         ");
            insertSql.AppendLine("            ,@DeptNO            ");
            insertSql.AppendLine("            ,@SuperDeptID       ");
            insertSql.AppendLine("            ,@PYShort           ");
            insertSql.AppendLine("            ,@DeptName          ");
            insertSql.AppendLine("            ,@AccountFlag       ");
            insertSql.AppendLine("            ,@SaleFlag          ");
            insertSql.AppendLine("            ,@SubFlag           ");
            insertSql.AppendLine("            ,@Address           ");
            insertSql.AppendLine("            ,@Post              ");
            insertSql.AppendLine("            ,@LinkMan           ");
            insertSql.AppendLine("            ,@Tel               ");
            insertSql.AppendLine("            ,@Fax               ");
            insertSql.AppendLine("            ,@Email             ");
            insertSql.AppendLine("            ,@Duty              ");
            insertSql.AppendLine("            ,@UsedStatus        ");
            insertSql.AppendLine("            ,@Description       ");
            insertSql.AppendLine("            ,getdate()          ");
            insertSql.AppendLine("            ,@ModifiedUserID)   ");
            #endregion

            //定义插入基本信息的命令
            SqlCommand comm = new SqlCommand();
            comm.CommandText = insertSql.ToString();
            //设置保存的参数
            SetSaveParameter(comm, model);

            //执行插入操作并返回更新结果
            return SqlHelper.ExecuteTransWithCommand(comm);

        }
    protected void BindSubStore()
    {
        XBase.Model.Office.HumanManager.DeptModel model = new XBase.Model.Office.HumanManager.DeptModel();
        model.CompanyCD = UserInfo.CompanyCD;
        DataTable dtSource = XBase.Business.Office.LogisticsDistributionManager.SubProductSendPriceBus.GetSubStore(model);
        ddlSubStore.DataSource = dtSource;
        ddlSubStore.DataTextField = "DeptName";
        ddlSubStore.DataValueField = "ID";
        ddlSubStore.DataBind();

        ddlSubStore.Items.Insert(0,new ListItem("--请选择--", "-1"));
    }
    protected void BindSubStore()
    {
        XBase.Model.Office.HumanManager.DeptModel model = new XBase.Model.Office.HumanManager.DeptModel();
        model.CompanyCD = UserInfo.CompanyCD;
        DataTable dtSource = XBase.Business.Office.LogisticsDistributionManager.SubProductSendPriceBus.GetSubStore(model);

        ddlSubStore.DataSource     = dtSource;
        ddlSubStore.DataTextField  = "DeptName";
        ddlSubStore.DataValueField = "ID";
        ddlSubStore.DataBind();

        ddlSubStore.Items.Insert(0, new ListItem("--请选择--", "-1"));
    }
 /// <summary>
 /// 保存时基本信息参数设置
 /// </summary>
 /// <param name="comm">命令</param>
 /// <param name="model">保存信息</param>
 private static void SetSaveParameter(SqlCommand comm, DeptModel model)
 {
     //设置参数
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD",model.CompanyCD));//公司代码
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptNO", model.DeptNO));//机构编号
     //插入时,设置上级机构ID
     if (ConstUtil.EDIT_FLAG_INSERT.Equals(model.EditFlag))
     {
        
     }
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@SuperDeptID", model.SuperDeptID));//上级机构ID(对应本表的ID)
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@PYShort", model.PYShort));//机构拼音代码
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptName", model.DeptName));//机构名称
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@AccountFlag", model.AccountFlag));//是否独立核算(0否,1是)
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@SaleFlag", model.SaleFlag));//是否为零售店(0否,1是)
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@SubFlag", model.SubFlag));//是否为分公司(0否,1是)
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Address", model.Address));//地址
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Post", model.Post));//邮编
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@LinkMan", model.LinkMan));//联系人
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Tel", model.Tel));//电话
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Fax", model.Fax));//传真
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Email", model.Email));//Email
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Duty", model.Duty));//职责
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus));//启用状态(0停用,1启用)
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Description", model.Description));//描述
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));//最后更新用户ID
 }
        /// <summary>
        /// 更新组织机构信息
        /// </summary>
        /// <param name="model">保存信息</param>
        /// <returns></returns>
        public static bool UpdateDeptInfo(DeptModel model)
        {

            #region 更新SQL拼写
            StringBuilder updateSql = new StringBuilder();
            updateSql.AppendLine(" UPDATE officedba.DeptInfo          ");
            updateSql.AppendLine(" SET                                ");
            updateSql.AppendLine(" 	 PYShort = @PYShort               ");
            updateSql.AppendLine(" 	,DeptName = @DeptName             ");
            updateSql.AppendLine(" 	,AccountFlag = @AccountFlag       ");
            updateSql.AppendLine(" 	,SaleFlag = @SaleFlag             ");
            updateSql.AppendLine(" 	,SubFlag = @SubFlag               ");
            updateSql.AppendLine(" 	,Address = @Address               ");
            updateSql.AppendLine(" 	,Post = @Post                     ");
            updateSql.AppendLine(" 	,LinkMan = @LinkMan               ");
            updateSql.AppendLine(" 	,Tel = @Tel                       ");
            updateSql.AppendLine(" 	,Fax = @Fax                       ");
            updateSql.AppendLine(" 	,Email = @Email                   ");
            updateSql.AppendLine(" 	,Duty = @Duty ,SuperDeptID=@SuperDeptID                    ");
            updateSql.AppendLine(" 	,UsedStatus = @UsedStatus         ");
            updateSql.AppendLine(" 	,Description = @Description       ");
            updateSql.AppendLine(" 	,ModifiedDate = getdate()         ");
            updateSql.AppendLine(" 	,ModifiedUserID = @ModifiedUserID ");
            updateSql.AppendLine(" WHERE                              ");
            updateSql.AppendLine(" 	CompanyCD = @CompanyCD            ");
            updateSql.AppendLine(" 	AND DeptNO = @DeptNO              ");
            #endregion

            //定义更新基本信息的命令
            SqlCommand comm = new SqlCommand();
            comm.CommandText = updateSql.ToString();
            //设置保存的参数
            SetSaveParameter(comm, model);

            //执行插入操作并返回更新结果
            return SqlHelper.ExecuteTransWithCommand(comm);
        }