コード例 #1
0
 public static int Update(ProjectConstructionDetails model)
 {
     return ProjectConstructionDBHelper.Update(model);
 }
コード例 #2
0
        public static int Add(ProjectConstructionDetails model,string projectName)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.AppendLine("INSERT INTO officedba.ProjectConstructionDetails(");
            strSql.AppendLine("SummaryName,DutyPerson,CompanyCD,projectID,ProcessScale,PersonNum,Rate,ProessID,BeginDate,EndDate,ProjectMemo)");
            strSql.AppendLine(" VALUES (");
            strSql.AppendLine("@in_SummaryName,@in_DutyPerson,@in_CompanyCD,@in_projectID,@in_ProcessScale,@in_PersonNum,@in_Rate,@in_ProessID,@in_BeginDate,@in_EndDate,@in_ProjectMemo)");
            strSql.AppendLine(";select @@IDENTITY");
            

            SqlParameter[] cmdParms = {
				new SqlParameter("@in_SummaryName",SqlDbType.VarChar,200),
				new SqlParameter("@in_DutyPerson", SqlDbType.Int,4),
				new SqlParameter("@in_CompanyCD", SqlDbType.VarChar,50),
				new SqlParameter("@in_projectID", SqlDbType.Int, 4),
				new SqlParameter("@in_ProcessScale", SqlDbType.Decimal),
				new SqlParameter("@in_PersonNum",  SqlDbType.Decimal),
				new SqlParameter("@in_Rate",  SqlDbType.Decimal),
				new SqlParameter("@in_ProessID",  SqlDbType.VarChar,50),
				new SqlParameter("@in_BeginDate", SqlDbType.DateTime),
				new SqlParameter("@in_EndDate", SqlDbType.DateTime),
				new SqlParameter("@in_ProjectMemo", SqlDbType.VarChar,50)
              //  new SqlParameter("@msgcontent",SqlDbType.VarChar,500)
                                      };
            cmdParms[0].Value = model.SummaryName;
            cmdParms[1].Value = model.DutyPerson;
            cmdParms[2].Value = model.CompanyCD;
            cmdParms[3].Value = model.projectID;
            cmdParms[4].Value = model.ProcessScale;
            cmdParms[5].Value = model.PersonNum;
            cmdParms[6].Value = model.Rate;
            cmdParms[7].Value = model.ProessID;
            cmdParms[8].Value = model.BeginDate;
            cmdParms[9].Value = model.EndDate;
            cmdParms[10].Value = model.ProjectMemo;
            int num = 0;
            try
            {
                num = int.Parse(SqlHelper.ExecuteScalar(strSql.ToString(), cmdParms).ToString());
            }
            catch {
                return num;
            }

            /*设置短信提醒*/
            //1、开工时间提醒 (提前一天提醒)
            strSql = new StringBuilder();
            strSql.AppendLine("insert into officedba.MsgSendList(CompanyCD,summaryID,msgContent,Empid) values(@CompanyCD,@summaryID,@msgcontent,@DutyPerson)");
            strSql.AppendLine(";select @@IDENTITY");
            SqlParameter[] msgParms = {
				new SqlParameter("@DutyPerson", SqlDbType.Int,4),
				new SqlParameter("@CompanyCD", SqlDbType.VarChar,50),
                new SqlParameter("@summaryID", SqlDbType.VarChar,50),
				new SqlParameter("@msgcontent",SqlDbType.VarChar,500)
                                      };

            msgParms[0].Value = model.DutyPerson;
            msgParms[1].Value = model.CompanyCD;
            msgParms[2].Value = num;
            msgParms[3].Value = "项目名称:"+projectName +"中的["+ model.SummaryName + "]开工时间为:" + model.BeginDate.ToShortDateString() + ",完工时间为:" + model.EndDate.ToShortDateString()+"请您关注!";
            try
            {
                num = int.Parse(SqlHelper.ExecuteScalar(strSql.ToString(), msgParms).ToString());
                //追加到信息发送表
                string sqlstr = "insert into officedba.NoticeHistory(CompanyCD,SourceFlag,SourceID,PlanNoticeDate) values(@compCD,5,@num,@senddate)";
                TransactionManager tran = new TransactionManager();
                tran.BeginTransaction();
                SqlParameter[] param = {
                                           new SqlParameter("@compCD",SqlDbType.VarChar,50),
                                           new SqlParameter("@num",SqlDbType.Int,4),
                                           new SqlParameter("@senddate",SqlDbType.DateTime)
                                       };
                param[0].Value = model.CompanyCD;
                param[1].Value = num;
                param[2].Value = model.BeginDate.AddDays(-1).AddHours(9);
                try
                {
                    SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sqlstr, param);
                    tran.Commit();
                }
                catch {
                    tran.Rollback();
                    return 0;
                }
            }
            catch
            {
            }
            return num;
        }
コード例 #3
0
 public static int Add(ProjectConstructionDetails model,string projectName)
 {
     return ProjectConstructionDBHelper.Add(model,projectName);
 }
コード例 #4
0
        public static int Update(ProjectConstructionDetails model)
        {
            TransactionManager trans = new TransactionManager();
            trans.BeginTransaction();
           
            StringBuilder strSql = new StringBuilder();
            strSql.Append("UPDATE officedba.ProjectConstructionDetails SET ");
            strSql.Append("SummaryName=@in_SummaryName,");
            strSql.Append("DutyPerson=@in_DutyPerson,");
            strSql.Append("CompanyCD=@in_CompanyCD,");
            strSql.Append("projectID=@in_projectID,");
            strSql.Append("ProcessScale=@in_ProcessScale,");
            strSql.Append("PersonNum=@in_PersonNum,");
            strSql.Append("Rate=@in_Rate,");
            strSql.Append("ProessID=@in_ProessID,");
            strSql.Append("BeginDate=@in_BeginDate,");
            strSql.Append("EndDate=@in_EndDate,");
            strSql.Append("ProjectMemo=@in_ProjectMemo");
            strSql.Append(" WHERE ID=@in_ID");
            SqlParameter[] Parms = {
				new SqlParameter("@in_SummaryName", SqlDbType.VarChar,200),
				new SqlParameter("@in_DutyPerson", SqlDbType.Int),
				new SqlParameter("@in_CompanyCD", SqlDbType.VarChar,50),
				new SqlParameter("@in_projectID", SqlDbType.Int),
				new SqlParameter("@in_ProcessScale", SqlDbType.Decimal),
				new SqlParameter("@in_PersonNum", SqlDbType.Decimal),
				new SqlParameter("@in_Rate", SqlDbType.Decimal),
				new SqlParameter("@in_ProessID", SqlDbType.VarChar),
				new SqlParameter("@in_BeginDate", SqlDbType.VarChar,30),
				new SqlParameter("@in_EndDate", SqlDbType.VarChar,30),
				new SqlParameter("@in_ProjectMemo", SqlDbType.VarChar,5000),
				new SqlParameter("@in_ID", SqlDbType.Int)};

            Parms[0].Value = model.SummaryName;
            Parms[1].Value = model.DutyPerson;
            Parms[2].Value = model.CompanyCD;
            Parms[3].Value = model.projectID;
            Parms[4].Value = model.ProcessScale;
            Parms[5].Value = model.PersonNum;
            Parms[6].Value = model.Rate;
            Parms[7].Value = model.ProessID;
            Parms[8].Value = model.BeginDate.ToString();
            Parms[9].Value = model.EndDate.ToString();
            Parms[10].Value = model.ProjectMemo;
            Parms[11].Value = model.ID;
            int num = 0;
            try
            {
                num = SqlHelper.ExecuteNonQuery(trans.Trans, CommandType.Text, strSql.ToString(), Parms);
                trans.Commit();
            }
            catch
            {
                trans.Rollback();
            }
            return num;
        }