Пример #1
0
        /// <summary>
        /// 编辑目标信息
        /// </summary>
        /// <param name="model">目标信息</param>
        /// <returns></returns>
        public static int SaveAimInfo(AimInfoModel model)
        {
            //获取登陆用户信息
            UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
            //设置公司代码
            model.CompanyCD = userInfo.CompanyCD;
            //定义返回变量
            int isSucc = -1;

            //ID存在时,更新
            if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag))
            {
                try
                {
                    //执行更新操作
                    isSucc = AimInfoDBHelper.UpdateAimInfo(model);
                }
                catch 
                {
                    //输出日志

                }
            }
            //插入
            else
            {
                try
                {
                    //执行插入操作
                    isSucc = AimInfoDBHelper.InsertAimInfo(model);
                }
                catch 
                {
                    //输出日志

                }
            }
            return isSucc;
        }
Пример #2
0
        public static void SetAimInfoParm(SqlCommand comm, AimInfoModel model)
        {

            UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@AimNo", model.AimNO));//
            comm.Parameters.AddWithValue("@AimTypeID", SqlDbType.Int);
            comm.Parameters["@AimTypeID"].Value = model.AimTypeID;
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@AimTitle", model.AimTitle));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@AimContent", model.AimContent));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@AimStep", model.AimStep));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@Resources", model.Resources));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@Method", model.Method));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@Qustion", model.Qustion));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@AimStandard", model.AimStandard));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@AimFlag", model.AimFlag));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@JoinUserIDList", model.JoinUserIDList));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@JoinUserNameList", model.JoinUserNameList));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@CanViewUser", model.CanViewUser  ));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@CanViewUserName", model.CanViewUserName));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@IsMobileNotice", model.IsMobileNotice));//
            comm.Parameters.AddWithValue("@PrincipalID", SqlDbType.Int);
            comm.Parameters["@PrincipalID"].Value = model.PrincipalID;
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@Attachment", model.Attachment));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@Critical", model.Critical));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@Important", model.Important));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@Priority", model.Priority));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@AttentionName", model.AttentionName));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@Status", model.Status));//
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark));//

            comm.Parameters.AddWithValue("@Creator", SqlDbType.Int);
            comm.Parameters["@Creator"].Value = model.Creator;

            comm.Parameters.AddWithValue("@Checkor", SqlDbType.Int);
            comm.Parameters["@Checkor"].Value = model.Checkor;

            comm.Parameters.AddWithValue("@CreateDate", SqlDbType.DateTime);
            comm.Parameters["@CreateDate"].Value = model.CreateDate;

            comm.Parameters.AddWithValue("@Coordinator", SqlDbType.Int);
            comm.Parameters["@Coordinator"].Value = model.Coordinator;

            comm.Parameters.AddWithValue("@StartDate", SqlDbType.DateTime);
            comm.Parameters["@StartDate"].Value = model.StartDate;

            comm.Parameters.AddWithValue("@ModifiedDate", SqlDbType.DateTime);
            comm.Parameters["@ModifiedDate"].Value = model.ModifiedDate;

            comm.Parameters.AddWithValue("@EndDate", SqlDbType.DateTime);
            comm.Parameters["@EndDate"].Value = model.EndDate;

            comm.Parameters.AddWithValue("@IsDirection",SqlDbType.VarChar );
            comm.Parameters["@IsDirection"].Value = model.IsDirection;

            if (model.IsMobileNotice == "1")
            {
                comm.Parameters.AddWithValue("@RemindTime", SqlDbType.DateTime);
                comm.Parameters["@RemindTime"].Value = model.RemindTime;
            }
            comm.Parameters.AddWithValue("@AimDate", SqlDbType.VarChar);
            comm.Parameters["@AimDate"].Value = model.AimDate;

            comm.Parameters.AddWithValue("@AimNum", SqlDbType.Int);
            comm.Parameters["@AimNum"].Value = model.AimNum;

            comm.Parameters.AddWithValue("@ID", SqlDbType.Int);
            comm.Parameters["@ID"].Value = model.ID;

            comm.Parameters.AddWithValue("@DeptID", SqlDbType.Int);
            comm.Parameters["@DeptID"].Value = model.DeptID;

            comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", userInfo.UserID));//
        }
Пример #3
0
        public static int InsertAimInfo(AimInfoModel model)
        {
            #region  SQL语句拼写
            StringBuilder InsertAimSqlString = new StringBuilder();
            InsertAimSqlString.Append("INSERT INTO  officedba.PlanAim");
            InsertAimSqlString.Append("  (      CompanyCD,");
            InsertAimSqlString.Append("     AimNo ,");
            InsertAimSqlString.Append("      AimTypeID ,");
            InsertAimSqlString.Append("      AimTitle ,");
            InsertAimSqlString.Append("      AimContent,");
            InsertAimSqlString.Append("      AimStandard ,");
            InsertAimSqlString.Append("      AimFlag ,");
            InsertAimSqlString.Append("      JoinUserIDList ,");
            InsertAimSqlString.Append("      JoinUserNameList,");
            InsertAimSqlString.Append("      CanViewUser ,");
            InsertAimSqlString.Append("      CanViewUserName ,");
            InsertAimSqlString.Append("      IsMobileNotice ,");
            if (model.IsMobileNotice =="1" )
            InsertAimSqlString.Append("      RemindTime,");
            InsertAimSqlString.Append("      PrincipalID ,");
            InsertAimSqlString.Append("       Attachment,");
            InsertAimSqlString.Append("       Critical,");
            InsertAimSqlString.Append("      Important ,");
            InsertAimSqlString.Append("       Priority,");
            InsertAimSqlString.Append("      AttentionName ,");
            InsertAimSqlString.Append("      Status ,");
            InsertAimSqlString.Append("      Remark ,");
            InsertAimSqlString.Append("      AimStep ,");
            InsertAimSqlString.Append("      Resources ,");
            InsertAimSqlString.Append("      Qustion ,");
            InsertAimSqlString.Append("      Method ,");
            InsertAimSqlString.Append("      Creator ,");
            InsertAimSqlString.Append("      Checkor ,");
            InsertAimSqlString.Append("       CreateDate,");
            InsertAimSqlString.Append("       Coordinator,");
            InsertAimSqlString.Append("       StartDate,");
            InsertAimSqlString.Append("       EndDate,");
            InsertAimSqlString.Append("       ModifiedUserID,");
            InsertAimSqlString.Append("       AimDate,");
            InsertAimSqlString.Append("       AimNum,");
            InsertAimSqlString.Append("       IsDirection,");
            InsertAimSqlString.Append("       DeptID)");
            InsertAimSqlString.Append("   VALUES   ");
            InsertAimSqlString.Append(" (  @CompanyCD,           ");
            InsertAimSqlString.Append("    @AimNo                    ,          ");
            InsertAimSqlString.Append("    @AimTypeID                         ,");
            InsertAimSqlString.Append("    @AimTitle                   ,");
            InsertAimSqlString.Append("    @AimContent               ,");
            InsertAimSqlString.Append("    @AimStandard                  ,");
            InsertAimSqlString.Append("    @AimFlag                             ,");
            InsertAimSqlString.Append("    @JoinUserIDList                 ,");
            InsertAimSqlString.Append("    @JoinUserNameList          ,");
            InsertAimSqlString.Append("    @CanViewUser       ,");
            InsertAimSqlString.Append("    @CanViewUserName       ,");
            InsertAimSqlString.Append("    @IsMobileNotice        ,");
            if (model.IsMobileNotice == "1")
            InsertAimSqlString.Append("    @RemindTime     ,           ");
            InsertAimSqlString.Append("    @PrincipalID                       ,");
            InsertAimSqlString.Append("    @Attachment                              ,");
            InsertAimSqlString.Append("    @Critical                           ,");
            InsertAimSqlString.Append("    @Important                         ,");
            InsertAimSqlString.Append("    @Priority                        ,");
            InsertAimSqlString.Append("    @AttentionName                     ,");
            InsertAimSqlString.Append("    @Status                        ,");
            InsertAimSqlString.Append("    @Remark                                   ,");
            InsertAimSqlString.Append("    @AimStep                                   ,");
            InsertAimSqlString.Append("    @Resources                                   ,");
            InsertAimSqlString.Append("    @Qustion                                   ,");
            InsertAimSqlString.Append("    @Method                                   ,");
            InsertAimSqlString.Append("    @Creator                               ,");
            InsertAimSqlString.Append("    @Checkor                               ,");
            InsertAimSqlString.Append("    @CreateDate                             ,");
            InsertAimSqlString.Append("    @Coordinator                                ,");
            InsertAimSqlString.Append("    @StartDate                          ,");
            InsertAimSqlString.Append("    @EndDate                            ,");
            InsertAimSqlString.Append("    @ModifiedUserID                  ,");
            InsertAimSqlString.Append("    @AimDate,");
            InsertAimSqlString.Append("    @AimNum, ");
            InsertAimSqlString.Append("    @IsDirection, ");
            InsertAimSqlString.Append("    @DeptID  )");
            InsertAimSqlString.Append(";select @RID =@@IDENTITY  ");
            #endregion
            //定义更新基本信息的命令
            SqlCommand comm = new SqlCommand();
            comm.CommandText = InsertAimSqlString.ToString();
            //设置保存的参数
            SetAimInfoParm(comm, model);
            SqlParameter sqlp = new SqlParameter("@RID",SqlDbType.Int,4)  ;
            sqlp.Direction = ParameterDirection.Output;
            comm.Parameters.Add(sqlp);
             
            //返回操作结果  
            SqlHelper.ExecuteTransWithCommand(comm);

            if (model.IsMobileNotice == "1")
            {
              
                StringBuilder strSql = new StringBuilder(); 
                strSql.Append("insert into officedba.NoticeHistory(");
                strSql.Append("   CompanyCD,SourceFlag,SourceID,PlanNoticeDate  )  ");
                strSql.Append("      values(@CompanyCD, @SourceFlag,@SourceID,@PlanNoticeDate  ) ");
                SqlCommand commN = new SqlCommand();
                commN.Parameters.AddWithValue("@CompanyCD", SqlDbType.VarChar);
                commN.Parameters["@CompanyCD"].Value = model.CompanyCD;
                commN.Parameters.AddWithValue("@SourceFlag", SqlDbType.VarChar);
                commN.Parameters["@SourceFlag"].Value = "2";
                commN.Parameters.AddWithValue("@SourceID", SqlDbType.Int);
                commN.Parameters["@SourceID"].Value = sqlp.Value;
                commN.Parameters.AddWithValue("@PlanNoticeDate", SqlDbType.DateTime);
                commN.Parameters["@PlanNoticeDate"].Value = model.RemindTime;
                commN.CommandText = strSql.ToString();
                SqlHelper.ExecuteTransWithCommand(commN);
            }

            return (int)sqlp.Value;         
        }
Пример #4
0
        public static bool AddAimCheck(AimInfoModel model)
        {
            string sqlStr = "UPDATE   officedba.PlanAim SET   CheckNote = @CheckNote,  Status='5', " +
                                   "   CheckUserID=@CheckUserID,  " +
                                   "    CheckScore=@CheckScore,  " +
                                   "  ScoreNote =@ScoreNote ," +
                                   "   CheckDate = @CheckDate    " +
                                   " WHERE  ID = @ID ";
            //定义更新基本信息的命令
            SqlCommand comm = new SqlCommand();
            //设置两个参数
            comm.CommandText = sqlStr;

            comm.Parameters.AddWithValue("@CheckUserID", SqlDbType.Int);
            comm.Parameters["@CheckUserID"].Value = model.CheckUserID;

            comm.Parameters.AddWithValue("@CheckNote", SqlDbType.VarChar);
            comm.Parameters["@CheckNote"].Value = model.CheckNote;

            comm.Parameters.AddWithValue("@ScoreNote", SqlDbType.VarChar);
            comm.Parameters["@ScoreNote"].Value = model.ScoreNote;

            comm.Parameters.AddWithValue("@CheckScore", SqlDbType.Int);
            comm.Parameters["@CheckScore"].Value = model.CheckScore;

            comm.Parameters.AddWithValue("@CheckDate", SqlDbType.VarChar);
            comm.Parameters["@CheckDate"].Value = DateTime.Now;

            comm.Parameters.AddWithValue("@ID", SqlDbType.Int);
            comm.Parameters["@ID"].Value = model.ID;

            //返回操作结果  
            return SqlHelper.ExecuteTransWithCommand(comm);
        }
Пример #5
0
        public static bool AddSummarizeNote(AimInfoModel model)
        {
            string sqlStr = "UPDATE   officedba.PlanAim SET   SummarizeNote = @SummarizeNote,  Status='4' ,AimRealResult=@AimRealResult, " +
                                    "   Summarizer=@Summarizer,  " +
                                    "      AddOrCut = @AddOrCut ,     " +
                                    "    Difference=@Difference,   " +
                                    "  CompletePercent =@CompletePercent ," +
                                    "   SummarizeDate = @SummarizeDate    " +
                                    " WHERE  ID = @ID ";
            //定义更新基本信息的命令
            SqlCommand comm = new SqlCommand();
            //设置两个参数
            comm.CommandText = sqlStr;

            comm.Parameters.AddWithValue("@Summarizer", SqlDbType.Int);
            comm.Parameters["@Summarizer"].Value = model.Summarizer;

            comm.Parameters.AddWithValue("@SummarizeNote", SqlDbType.VarChar);
            comm.Parameters["@SummarizeNote"].Value = model.SummarizeNote;

            comm.Parameters.AddWithValue("@CompletePercent", SqlDbType.Decimal);
            comm.Parameters["@CompletePercent"].Value = model.CompletePercent;

            comm.Parameters.AddWithValue("@AimRealResult", SqlDbType.VarChar);
            comm.Parameters["@AimRealResult"].Value = model.AimRealResult;

            comm.Parameters.AddWithValue("@AddOrCut", SqlDbType.VarChar);
            comm.Parameters["@AddOrCut"].Value = model.AddOrCut;

            comm.Parameters.AddWithValue("@Difference", SqlDbType.VarChar);
            comm.Parameters["@Difference"].Value = model.Difference;

            comm.Parameters.AddWithValue("@SummarizeDate", SqlDbType.VarChar);
            comm.Parameters["@SummarizeDate"].Value = DateTime.Now;

            comm.Parameters.AddWithValue("@ID", SqlDbType.Int);
            comm.Parameters["@ID"].Value = model.ID;

            //返回操作结果  
            return SqlHelper.ExecuteTransWithCommand(comm);

        }
Пример #6
0
        public static int UpdateAimInfo(AimInfoModel model)
        {

            #region  SQL语句拼写
            StringBuilder UpdateAimSqlString = new StringBuilder();
            UpdateAimSqlString.Append("UPDATE  officedba.PlanAim");
            UpdateAimSqlString.Append("   SET   ");
            UpdateAimSqlString.Append("      AimTitle=@AimTitle ,");
            UpdateAimSqlString.Append("      AimContent=@AimContent,");
            UpdateAimSqlString.Append("      AimStandard=@AimStandard ,");
            UpdateAimSqlString.Append("      PrincipalID=@PrincipalID ,");
            UpdateAimSqlString.Append("      Checkor=@Checkor ,");
            UpdateAimSqlString.Append("       Attachment=@Attachment,");
            UpdateAimSqlString.Append("      Status=@Status ,");
            UpdateAimSqlString.Append("      AimStep=@AimStep ,");
            UpdateAimSqlString.Append("      Resources=@Resources ,");
            UpdateAimSqlString.Append("      Qustion=@Qustion ,");
            UpdateAimSqlString.Append("      Method=@Method ,");
            UpdateAimSqlString.Append("      Remark=@Remark ,");
            UpdateAimSqlString.Append("       StartDate=@StartDate,");
            UpdateAimSqlString.Append("       EndDate=@EndDate,");
            UpdateAimSqlString.Append("       ModifiedUserID=@ModifiedUserID,");
            UpdateAimSqlString.Append("       DeptID=@DeptID,");
            UpdateAimSqlString.Append("       Coordinator=@Coordinator,");
            UpdateAimSqlString.Append("       JoinUserNameList=@JoinUserNameList,");
            UpdateAimSqlString.Append("       JoinUserIDList=@JoinUserIDList,");
            UpdateAimSqlString.Append("      CanViewUser=@CanViewUser ,");
            UpdateAimSqlString.Append("      CanViewUserName =@CanViewUserName ,");
            UpdateAimSqlString.Append("      AttentionName =@AttentionName ,");
            UpdateAimSqlString.Append("      IsMobileNotice=@IsMobileNotice ,");
            if (model.IsMobileNotice == "1")
                UpdateAimSqlString.Append("      RemindTime =@RemindTime,");
            UpdateAimSqlString.Append("       ModifiedDate=@ModifiedDate,  ");
            UpdateAimSqlString.Append("       IsDirection=@IsDirection  ");
            UpdateAimSqlString.Append("   WHERE   ID =@ID  ");

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

            //返回操作结果  
            if (SqlHelper.ExecuteTransWithCommand(comm))
            {
                if (model.IsMobileNotice == "1")
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("delete  from  officedba.NoticeHistory  where  SourceID=@ID and  SourceFlag ='2'  ");
                strSql.Append("insert into officedba.NoticeHistory(");
                strSql.Append("   CompanyCD,SourceFlag,SourceID,PlanNoticeDate  )  ");
                strSql.Append("      values(@CompanyCD, @SourceFlag,@SourceID,@PlanNoticeDate  ) ");
                SqlCommand commN = new SqlCommand();
                commN.Parameters.AddWithValue("@CompanyCD", SqlDbType.VarChar);
                commN.Parameters["@CompanyCD"].Value = model.CompanyCD;
                commN.Parameters.AddWithValue("@SourceFlag", SqlDbType.VarChar);
                commN.Parameters["@SourceFlag"].Value ="2" ;
                commN.Parameters.AddWithValue("@SourceID", SqlDbType.Int);
                commN.Parameters["@SourceID"].Value = model.ID;
                commN.Parameters.AddWithValue("@PlanNoticeDate", SqlDbType.DateTime);
                commN.Parameters["@PlanNoticeDate"].Value = model.RemindTime;
                commN.Parameters.AddWithValue("@ID", SqlDbType.Int);
                commN.Parameters["@ID"].Value = model.ID;
                commN.CommandText = strSql.ToString();
                SqlHelper.ExecuteTransWithCommand(commN);
            } else
                {
                    StringBuilder strSql = new StringBuilder();
                    SqlCommand commN = new SqlCommand();
                    strSql.Append("delete  from  officedba.NoticeHistory  where  SourceID=@ID and  SourceFlag ='2'  ");
                    commN.Parameters.AddWithValue("@ID", SqlDbType.Int);
                    commN.Parameters["@ID"].Value = model.ID;
                    commN.CommandText = strSql.ToString();
                    SqlHelper.ExecuteTransWithCommand(commN);
                }
                return 1;
            }
            else {
                return 0;
            }

        }