public ActionResult ProjectCustom(string id = "") { if (id != "") { MProject = BProject.GetModel(int.Parse(id)); } return(View(MProject)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.Project model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Project("); strSql.Append("Code,Name,ProjectTypeID,LeaderID,PlanStartTime,PlanEndTime,RealStartTime,RealEndTime,Contents,ProjectStatusID,CheckUserID,ProjectCheckStatus,CheckNote,CreateUserID,CreateDate,EditUserID,EditDate)"); strSql.Append(" values ("); strSql.Append("@Code,@Name,@ProjectTypeID,@LeaderID,@PlanStartTime,@PlanEndTime,@RealStartTime,@RealEndTime,@Contents,@ProjectStatusID,@CheckUserID,@ProjectCheckStatus,@CheckNote,@CreateUserID,@CreateDate,@EditUserID,@EditDate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Code", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@ProjectTypeID", SqlDbType.Int, 4), new SqlParameter("@LeaderID", SqlDbType.Int, 4), new SqlParameter("@PlanStartTime", SqlDbType.DateTime), new SqlParameter("@PlanEndTime", SqlDbType.DateTime), new SqlParameter("@RealStartTime", SqlDbType.DateTime), new SqlParameter("@RealEndTime", SqlDbType.DateTime), new SqlParameter("@Contents", SqlDbType.NVarChar, 2000), new SqlParameter("@ProjectStatusID", SqlDbType.Int, 4), new SqlParameter("@CheckUserID", SqlDbType.Int, 4), new SqlParameter("@ProjectCheckStatus", SqlDbType.Int, 4), new SqlParameter("@CheckNote", SqlDbType.NVarChar, 500), new SqlParameter("@CreateUserID", SqlDbType.Int, 4), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@EditUserID", SqlDbType.Int, 4), new SqlParameter("@EditDate", SqlDbType.DateTime) }; parameters[0].Value = model.Code; parameters[1].Value = model.Name; parameters[2].Value = model.ProjectTypeID; parameters[3].Value = model.LeaderID; parameters[4].Value = model.PlanStartTime; parameters[5].Value = model.PlanEndTime; parameters[6].Value = model.RealStartTime; parameters[7].Value = model.RealEndTime; parameters[8].Value = model.Contents; parameters[9].Value = model.ProjectStatusID; parameters[10].Value = model.CheckUserID; parameters[11].Value = model.ProjectCheckStatus; parameters[12].Value = model.CheckNote; parameters[13].Value = model.CreateUserID; parameters[14].Value = model.CreateDate; parameters[15].Value = model.EditUserID; parameters[16].Value = model.EditDate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public ActionResult ProjectPlanDone(string id = "", string operate = "", string flag = "") { if (operate == null) { operate = ""; } ViewData["operate"] = operate; if (id != "") { MProject = BProject.GetModel(int.Parse(id)); } ViewData["flag"] = flag; return(View(MProject)); }
public ActionResult ProjectGantt(string id = "", string operate = "") { if (operate == null) { operate = ""; } ViewData["operate"] = operate; string operateWhere = ""; #region string LeftJson = ""; string UserJson = ""; if (id != "") { int ProjectID = int.Parse(id); MProject = BProject.GetModel(ProjectID); string strPlan = @" SELECT pt.ID AS 'data-id', pt.Contents AS Content,pt.[Target],CONVERT(VARCHAR(10),pt.PlanStartTime,120) AS 'PlanStartTime' ,CONVERT(VARCHAR(10),pt.PlanEndTime,120) AS 'PlanEndTime',CONVERT(VARCHAR(10),pt.RealStartTime,120) AS 'RealStartTime' ,CONVERT(VARCHAR(10),pt.RealEndTime,120) AS 'RealEndTime',pt.Result,pt.Note, CONVERT(VARCHAR(10),pt.PlanStartTime,120) AS 'data-StartDate' ,CONVERT(VARCHAR(10),pt.PlanEndTime,120) AS 'data-EndDate' FROM ProjectTask pt WHERE pt.ProjectID=" + ProjectID + operateWhere + " and pt.DealStatusID>1 ORDER BY pt.CreateDate asc,pt.ID asc"; DataTable dt = DBUtility.DbHelperSQL.GetDataTable(strPlan); LeftJson = CdtTojson.DataTableToJson(dt, false); if (LeftJson != "") { LeftJson = "," + LeftJson; } string strUserList = @"SELECT a.TrueName AS aName,b.TrueName AS bName,c.TrueName AS cName,d.TrueName AS dName FROM ProjectTask pt INNER JOIN Project p ON pt.ProjectID=p.ID INNER JOIN UserInfo a ON a.ID=p.LeaderID INNER JOIN UserInfo b ON b.ID=p.CheckUserID INNER JOIN UserInfo c ON c.ID=pt.CreateUserID LEFT JOIN UserInfo d ON d.ID=pt.DealUserID WHERE pt.ProjectID='" + ProjectID + "' and pt.DealStatusID>1 ORDER BY pt.CreateDate asc,pt.ID asc"; DataTable dtUserList = DBUtility.DbHelperSQL.GetDataTable(strUserList); UserJson = CdtTojson.DataTableToJson(dtUserList, false); } ViewData["LeftJson"] = LeftJson; ViewData["UserJson"] = UserJson; #endregion return(View(MProject)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Project GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,Code,Name,ProjectTypeID,LeaderID,PlanStartTime,PlanEndTime,RealStartTime,RealEndTime,Contents,ProjectStatusID,CheckUserID,ProjectCheckStatus,CheckNote,CreateUserID,CreateDate,EditUserID,EditDate from Project "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Maticsoft.Model.Project model = new Maticsoft.Model.Project(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Project DataRowToModel(DataRow row) { Maticsoft.Model.Project model = new Maticsoft.Model.Project(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["Code"] != null) { model.Code = row["Code"].ToString(); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["ProjectTypeID"] != null && row["ProjectTypeID"].ToString() != "") { model.ProjectTypeID = int.Parse(row["ProjectTypeID"].ToString()); } if (row["LeaderID"] != null && row["LeaderID"].ToString() != "") { model.LeaderID = int.Parse(row["LeaderID"].ToString()); } if (row["PlanStartTime"] != null && row["PlanStartTime"].ToString() != "") { model.PlanStartTime = DateTime.Parse(row["PlanStartTime"].ToString()); } if (row["PlanEndTime"] != null && row["PlanEndTime"].ToString() != "") { model.PlanEndTime = DateTime.Parse(row["PlanEndTime"].ToString()); } if (row["RealStartTime"] != null && row["RealStartTime"].ToString() != "") { model.RealStartTime = DateTime.Parse(row["RealStartTime"].ToString()); } if (row["RealEndTime"] != null && row["RealEndTime"].ToString() != "") { model.RealEndTime = DateTime.Parse(row["RealEndTime"].ToString()); } if (row["Contents"] != null) { model.Contents = row["Contents"].ToString(); } if (row["ProjectStatusID"] != null && row["ProjectStatusID"].ToString() != "") { model.ProjectStatusID = int.Parse(row["ProjectStatusID"].ToString()); } if (row["CheckUserID"] != null && row["CheckUserID"].ToString() != "") { model.CheckUserID = int.Parse(row["CheckUserID"].ToString()); } if (row["ProjectCheckStatus"] != null && row["ProjectCheckStatus"].ToString() != "") { model.ProjectCheckStatus = int.Parse(row["ProjectCheckStatus"].ToString()); } if (row["CheckNote"] != null) { model.CheckNote = row["CheckNote"].ToString(); } if (row["CreateUserID"] != null && row["CreateUserID"].ToString() != "") { model.CreateUserID = int.Parse(row["CreateUserID"].ToString()); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["EditUserID"] != null && row["EditUserID"].ToString() != "") { model.EditUserID = int.Parse(row["EditUserID"].ToString()); } if (row["EditDate"] != null && row["EditDate"].ToString() != "") { model.EditDate = DateTime.Parse(row["EditDate"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Project model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Project set "); strSql.Append("Code=@Code,"); strSql.Append("Name=@Name,"); strSql.Append("ProjectTypeID=@ProjectTypeID,"); strSql.Append("LeaderID=@LeaderID,"); strSql.Append("PlanStartTime=@PlanStartTime,"); strSql.Append("PlanEndTime=@PlanEndTime,"); strSql.Append("RealStartTime=@RealStartTime,"); strSql.Append("RealEndTime=@RealEndTime,"); strSql.Append("Contents=@Contents,"); strSql.Append("ProjectStatusID=@ProjectStatusID,"); strSql.Append("CheckUserID=@CheckUserID,"); strSql.Append("ProjectCheckStatus=@ProjectCheckStatus,"); strSql.Append("CheckNote=@CheckNote,"); strSql.Append("CreateUserID=@CreateUserID,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("EditUserID=@EditUserID,"); strSql.Append("EditDate=@EditDate"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@Code", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@ProjectTypeID", SqlDbType.Int, 4), new SqlParameter("@LeaderID", SqlDbType.Int, 4), new SqlParameter("@PlanStartTime", SqlDbType.DateTime), new SqlParameter("@PlanEndTime", SqlDbType.DateTime), new SqlParameter("@RealStartTime", SqlDbType.DateTime), new SqlParameter("@RealEndTime", SqlDbType.DateTime), new SqlParameter("@Contents", SqlDbType.NVarChar, 2000), new SqlParameter("@ProjectStatusID", SqlDbType.Int, 4), new SqlParameter("@CheckUserID", SqlDbType.Int, 4), new SqlParameter("@ProjectCheckStatus", SqlDbType.Int, 4), new SqlParameter("@CheckNote", SqlDbType.NVarChar, 500), new SqlParameter("@CreateUserID", SqlDbType.Int, 4), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@EditUserID", SqlDbType.Int, 4), new SqlParameter("@EditDate", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.Code; parameters[1].Value = model.Name; parameters[2].Value = model.ProjectTypeID; parameters[3].Value = model.LeaderID; parameters[4].Value = model.PlanStartTime; parameters[5].Value = model.PlanEndTime; parameters[6].Value = model.RealStartTime; parameters[7].Value = model.RealEndTime; parameters[8].Value = model.Contents; parameters[9].Value = model.ProjectStatusID; parameters[10].Value = model.CheckUserID; parameters[11].Value = model.ProjectCheckStatus; parameters[12].Value = model.CheckNote; parameters[13].Value = model.CreateUserID; parameters[14].Value = model.CreateDate; parameters[15].Value = model.EditUserID; parameters[16].Value = model.EditDate; parameters[17].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }