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);
}
}
