public int UpdateTbl_ProjectById(Tbl_Project tbl_project)
{
string sql = "update [Tbl_Project] set [ProjectNo]=@ProjectNo,[ProjectMW]=@ProjectMW,[NodeNo]=@NodeNo,[NodeUser]=@NodeUser,[Status]=@Status,[ProjectName]=@ProjectName,[ProjectCustom]=@ProjectCustom,[ProjectCustomContact]=@ProjectCustomContact,[ProjectCustomPhone]=@ProjectCustomPhone,[ProjectManager]=@ProjectManager,[ProjectMainDesigner]=@ProjectMainDesigner,[ProjectTypes]=@ProjectTypes,[ProjectCity]=@ProjectCity,[ProjectLevel]=@ProjectLevel,[ProjectInfo]=@ProjectInfo,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_project.ID),
new SqlParameter("@ProjectNo", tbl_project.ProjectNo),
new SqlParameter("@ProjectName", tbl_project.ProjectName),
new SqlParameter("@ProjectMW", tbl_project.ProjectMW),
new SqlParameter("@ProjectCustom", tbl_project.ProjectCustom),
new SqlParameter("@ProjectCustomContact", tbl_project.ProjectCustomContact),
new SqlParameter("@ProjectCustomPhone", tbl_project.ProjectCustomPhone),
new SqlParameter("@ProjectManager", tbl_project.ProjectManager),
new SqlParameter("@ProjectMainDesigner", tbl_project.ProjectMainDesigner),
new SqlParameter("@ProjectTypes", tbl_project.ProjectTypes),
new SqlParameter("@ProjectCity", tbl_project.ProjectCity),
new SqlParameter("@ProjectLevel", tbl_project.ProjectLevel),
new SqlParameter("@ProjectInfo", tbl_project.ProjectInfo),
new SqlParameter("@NodeNo", tbl_project.NodeNo),
new SqlParameter("@NodeUser", tbl_project.NodeUser),
new SqlParameter("@Status", tbl_project.Status),
new SqlParameter("@DealUser", tbl_project.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int AddTbl_Project(Tbl_Project tbl_project)
{
string sql = "insert into [Tbl_Project] ([UserName],[ProjectNo],[ProjectName],[ProjectMW],[ProjectCustom],[ProjectCustomContact],[ProjectCustomPhone],[ProjectManager],[ProjectTypes],[ProjectCity],[ProjectLevel],[ProjectInfo],[NodeNo],[NodeUser],[DealUser],[Status]) values (@UserName,@ProjectNo,@ProjectName,@ProjectMW,@ProjectCustom,@ProjectCustomContact,@ProjectCustomPhone,@ProjectManager,@ProjectTypes,@ProjectCity,@ProjectLevel,@ProjectInfo,@NodeNo,@NodeUser,@DealUser,@Status)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@UserName", tbl_project.DealUser),
new SqlParameter("@ProjectNo", tbl_project.ProjectNo),
new SqlParameter("@ProjectName", tbl_project.ProjectName),
new SqlParameter("@ProjectMW", tbl_project.ProjectMW),
new SqlParameter("@ProjectCustom", tbl_project.ProjectCustom),
new SqlParameter("@ProjectCustomContact", tbl_project.ProjectCustomContact),
new SqlParameter("@ProjectCustomPhone", tbl_project.ProjectCustomPhone),
new SqlParameter("@ProjectManager", tbl_project.ProjectManager),
new SqlParameter("@ProjectTypes", tbl_project.ProjectTypes),
new SqlParameter("@ProjectCity", tbl_project.ProjectCity),
new SqlParameter("@ProjectLevel", tbl_project.ProjectLevel),
new SqlParameter("@ProjectInfo", tbl_project.ProjectInfo),
new SqlParameter("@NodeNo", tbl_project.NodeNo),
new SqlParameter("@NodeUser", tbl_project.NodeUser),
new SqlParameter("@Status", tbl_project.Status),
new SqlParameter("@DealUser", tbl_project.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int UpdateTbl_Project(Tbl_Project tbl_project)
{
WebCommon.Public.WriteLog("修改项目：" + tbl_project.ProjectName);
tbl_project.DealUser = WebCommon.Public.GetUserName();
tbl_project.DealTime = DateTime.Now;
WebModels.Tbl_Project pro = WebBLL.Tbl_ProjectManager.GetTbl_ProjectById(tbl_project.ID); //查询旧节点信息
if (tbl_project.Status == "进行中" && tbl_project.NodeNo != pro.NodeNo)
{
//如果是流程状态修改那么发送消息给节点人员
foreach (var obj in tbl_project.NodeUser.Split(','))
{
WebCommon.Public.WriteAlert(obj, "项目流程通知", "您有一项新的项目流程待处理：" + tbl_project.ProjectName + " " + tbl_project.NodeNo, "views/alert.aspx");
}
}
int count = new Tbl_ProjectService().UpdateTbl_ProjectById(tbl_project);
return(count);
}
public ActionResult Submit(ProjectViewModels projView)
{
int stid = Convert.ToInt32(Session["id"]);
//int cid = ViewBag.CID;
//int sid = ViewBag.SID;
//int tid = ViewBag.TID;
var project = new Tbl_Project()
{
SID = stid,
TID = projView.Tid,
CID = projView.Cid,
SemesterID = projView.Sid,
Pname = projView.PName,
Pdetils = projView.PDetails,
};
db.Tbl_Project.Add(project);
db.SaveChanges();
//var fileName = Path.GetFileName(Fil1.FileName);
//var path = Path.Combine(Server.MapPath("~/UplodeFile/") + fileName);
//Fil1.SaveAs(path);
int pid = project.PID;
var file = new Tbl_File()
{
PID = pid,
Ffile1 = SaveFile1((projView.ProjectReport[0])),
Ffile2 = SaveFile1(projView.ProjectFile[0]),
Photo1 = SaveFile1(projView.ProjectScreenshot1[0]),
Photo2 = SaveFile1(projView.ProjectScreenshot2[0]),
Url = projView.Url
};
db.Tbl_File.Add(file);
db.SaveChanges();
return(RedirectToAction("Index", "Project"));
//RedirectToAction("Index");
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_Project> getTbl_ProjectsBySql(string sql)
{
IList <Tbl_Project> list = new List <Tbl_Project>();
DataSet ds = DBHelper.ExecuteDataset(this.connection, CommandType.Text, sql);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Tbl_Project tbl_project = new Tbl_Project();
tbl_project.ID = Convert.ToInt32(dr["ID"]);
tbl_project.UserName = Convert.ToString(dr["UserName"]);
tbl_project.ProjectNo = Convert.ToString(dr["ProjectNo"]);
tbl_project.ProjectName = Convert.ToString(dr["ProjectName"]);
tbl_project.ProjectMW = Convert.ToString(dr["ProjectMW"]);
tbl_project.ProjectCustom = Convert.ToString(dr["ProjectCustom"]);
tbl_project.ProjectCustomContact = Convert.ToString(dr["ProjectCustomContact"]);
tbl_project.ProjectCustomPhone = Convert.ToString(dr["ProjectCustomPhone"]);
tbl_project.ProjectManager = Convert.ToString(dr["ProjectManager"]);
tbl_project.ProjectMainDesigner = Convert.ToString(dr["ProjectMainDesigner"]);
//tbl_project.ProjectStartTime = Convert.ToDateTime(dr["ProjectStartTime"]);
//tbl_project.ProjectEndTime = Convert.ToDateTime(dr["ProjectEndTime"]);
tbl_project.ProjectTypes = Convert.ToString(dr["ProjectTypes"]);
tbl_project.ProjectCity = Convert.ToString(dr["ProjectCity"]);
tbl_project.ProjectLevel = Convert.ToString(dr["ProjectLevel"]);
tbl_project.ProjectInfo = Convert.ToString(dr["ProjectInfo"]);
tbl_project.NodeNo = Convert.ToString(dr["NodeNo"]);
tbl_project.NodeUser = Convert.ToString(dr["NodeUser"]);
tbl_project.Status = Convert.ToString(dr["Status"]);
tbl_project.AddDate = Convert.ToDateTime(dr["AddDate"]);
tbl_project.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_project.DealUser = Convert.ToString(dr["DealUser"]);
tbl_project.DealTime = Convert.ToDateTime(dr["DealTime"]);
list.Add(tbl_project);
}
}
return(list);
}
public static int AddTbl_Project(Tbl_Project tbl_project)
{
WebCommon.Public.WriteLog("添加项目：" + tbl_project.ProjectName);
return(new Tbl_ProjectService().AddTbl_Project(tbl_project));
}
