/// <summary>
        /// 更新工资录入申请信息
        /// </summary>
        /// <param name="model">工资录入申请信息</param>
        /// <returns></returns>
        private static SqlCommand UpdateSalaryEmployeeInfo(SalaryEmployeeModel model)
        {

            #region SQL文拼写
            StringBuilder updateSql = new StringBuilder();
            updateSql.AppendLine(" UPDATE officedba.SalaryEmployee    ");
            updateSql.AppendLine(" SET                                ");
            updateSql.AppendLine(" 	 Flag = @Flag                     ");
            updateSql.AppendLine(" 	,SalaryMoney = @SalaryMoney       ");
            updateSql.AppendLine(" 	,ModifiedDate = getdate()         ");
            updateSql.AppendLine(" 	,ModifiedUserID = @ModifiedUserID ");
            updateSql.AppendLine(" WHERE                              ");
            updateSql.AppendLine(" 	CompanyCD = @CompanyCD            ");   
            updateSql.AppendLine(" 	AND ItemNo = @ItemNo              ");
            updateSql.AppendLine(" 	AND EmployeeID = @EmployeeID      ");
       
            #endregion

            //定义更新基本信息的命令  
            SqlCommand comm = new SqlCommand();
            comm.CommandText = updateSql.ToString();
            //其他参数
            SetSaveParameter(comm, model);
            //执行更新
            return comm;
        }
 /// <summary>
 /// 保存时参数设置
 /// </summary>
 /// <param name="comm">命令</param>
 /// <param name="model">员工工资信息</param>
 private static void SetSaveParameter(SqlCommand comm, SalaryEmployeeModel model)
 {
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EmployeeID));//员工ID
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Flag", model.Flag));//区分
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemNo", model.ItemNo));//工资项编号
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@SalaryMoney", model.SalaryMoney));//金额
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));//更新用户ID
 }
        /// <summary>
        /// 新建工资录入申请信息 
        /// </summary>
        /// <param name="model">工资录入申请信息</param>
        /// <returns></returns>
        private static SqlCommand InsertSalaryEmployeeInfo(SalaryEmployeeModel model)
        {
            #region 登陆SQL文
            StringBuilder insertSql = new StringBuilder();
            insertSql.AppendLine(" INSERT INTO               ");
            insertSql.AppendLine(" 	officedba.SalaryEmployee ");
            insertSql.AppendLine(" 	(CompanyCD               ");
            insertSql.AppendLine(" 	,EmployeeID              ");
            insertSql.AppendLine(" 	,Flag                    ");
            insertSql.AppendLine(" 	,ItemNo                  ");
            insertSql.AppendLine(" 	,SalaryMoney             ");
            insertSql.AppendLine(" 	,ModifiedDate            ");
            insertSql.AppendLine(" 	,ModifiedUserID)         ");
            insertSql.AppendLine(" VALUES                    ");
            insertSql.AppendLine(" 	(@CompanyCD              ");
            insertSql.AppendLine(" 	,@EmployeeID             ");
            insertSql.AppendLine(" 	,@Flag                   ");
            insertSql.AppendLine(" 	,@ItemNo                 ");
            insertSql.AppendLine(" 	,@SalaryMoney            ");
            insertSql.AppendLine(" 	,getdate()               ");
            insertSql.AppendLine(" 	,@ModifiedUserID)        ");
            insertSql.AppendLine("   SET @SalaryEmployeeID = @@IDENTITY  ");
            #endregion

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

            //添加返回参数
            comm.Parameters.Add(SqlHelper.GetOutputParameter("@SalaryEmployeeID", SqlDbType.Int));

            //执行插入并返回插入结果
            return comm;
        }