protected void btnDelete_Command(object sender, CommandEventArgs e) { string Id = e.CommandArgument.ToString(); WX.PRO.Project.MODEL model = WX.PRO.Project.GetModel("select * from PRO_Projects where ID=" + Id); if (e.CommandName == "del") { int row = ULCode.QDA.XSql.Execute("DELETE FROM PRO_Projects WHERE ID=" + Id); ULCode.QDA.XSql.Execute("DELETE FROM PRO_Process WHERE ProjID=" + Id); if (row > 0) { WX.PRO.Log.AddLog(3, Convert.ToInt32(Id), model.ProjectName.ToString() + "-删除项目。", Request.UserHostAddress); } } else if (e.CommandName == "qidong") { model.State.value = 4; model.Update(); WX.PRO.State.MODEL statemodel = WX.PRO.State.GetModel("select * from PRO_State where ProjID=" + model.ID.ToString()); statemodel.State.value = 1; statemodel.ProcID.value = 1; statemodel.Starttime.value = DateTime.Now; statemodel.Update(); WX.PRO.Process.SetTime(Convert.ToDateTime(statemodel.Starttime.value), Convert.ToInt32(statemodel.ProjID.value), 1); WX.PRO.Log.AddLog(2, Convert.ToInt32(Id), model.ProjectName.ToString() + "-启动。", Request.UserHostAddress); WX.PRO.Log.AddLog(5, Convert.ToInt32(Id), model.ProjectName.ToString() + "-第1步开始。", Request.UserHostAddress); } InitComponent(false); }
protected void Button1_Click(object sender, EventArgs e) { WX.PRO.Project.MODEL model = WX.PRO.Project.GetModel("select * from PRO_Projects where ID=" + WX.Request.rProjectId); model.Manage.value = WX.Main.CurUser.UserID; model.Opinion.value = ui_Opinion.Text.Trim(); model.Stime.value = DateTime.Now; if (((Button)sender).ID == "Button1") { model.ProjectName.value = ui_Name.Text.Trim(); model.Days.value = ui_days.Text.Trim(); //model.Fee.value = ui_fee.Text.Trim(); string[] userarry = ui_Persons.Value.Trim().Split(','); model.Persons.value = ui_Persons.Value != null ? userarry.Length : 0; model.State.value = 2; //4.业务处理过程 model.Update(); if (ui_Persons.Value != null) { ULCode.QDA.XSql.Execute("delete from PRO_User where type=1 and pid=" + model.ID.ToString()); for (int i = 0; i < userarry.Length; i++) { WX.PRO.User.MODEL usermodel = WX.PRO.User.NewDataModel(); usermodel.PID.value = model.ID.ToString(); usermodel.type.value = 1; usermodel.UserID.value = userarry[i]; usermodel.Insert(); } } ULCode.QDA.XSql.Execute("delete from PRO_State where ProjID=" + model.ID.ToString()); WX.PRO.State.MODEL statemodel = WX.PRO.State.NewDataModel(); statemodel.ProjID.value = model.ID.value; if (ui_manage.Value != "") { statemodel.Manage.value = ui_manage.Value; } statemodel.Fee.value = ui_fee.Text.Trim(); statemodel.Percnt.value = 0; statemodel.Percnttime.value = 0; statemodel.State.value = 0; statemodel.YJStarttime.value = ui_yjstarttime.Text; statemodel.Insert(); WX.PRO.Process.SetTime(Convert.ToDateTime(statemodel.YJStarttime.ToString()), Convert.ToInt32(statemodel.ProjID.value), 1); //5.登记日志 WX.PRO.Log.AddLog(1, Convert.ToInt32(model.ID.value), "审核通过。审批意见:" + model.Opinion.ToString(), Request.UserHostAddress); } else { model.State.value = 3; model.Update(); WX.PRO.Log.AddLog(1, Convert.ToInt32(model.ID.ToString()), model.ProjectName.ToString() + "的申请被退回。原因:" + model.Opinion.ToString(), Request.UserHostAddress); } //6.返回处理结果或返回其它页面。 Response.Redirect("Proj_ProjectManage.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { WX.PRO.Project.MODEL model = WX.PRO.Project.GetModel("select * from PRO_Projects where ID=" + WX.Request.rProjectId); if (model != null) { li_name.Text = model.ProjectName.ToString(); ui_Name.Text = model.ProjectName.ToString(); li_days.Text = model.Days.ToString(); ui_days.Text = model.Days.ToString(); if (Convert.ToInt32(model.Persons.ToString()) > 0) { ULCode.QDA.XDataTable xdt = ULCode.QDA.XSql.GetXDataTable("select pu.UserID,te.RealName from PRO_User pu left join TU_Users te on pu.UserID=te.UserID where pu.type=1 and pid=" + model.ID.ToString()); li_persons.Text = xdt.ToColValueList(",", 1); ui_Persons.Value = xdt.ToColValueList(",", 0); liu_Persons.Text = xdt.ToColValueList(",", 1); } li_fee.Text = model.Fee.ToString(); ui_fee.Text = model.Fee.ToString(); li_content.Text = model.Content.ToString(); li_Imagine.Text = model.Imagine.ToString(); li_state.Text = WX.PRO.Project.statearray[Convert.ToInt32(model.State.ToString())]; if (model.Annex.ToString() != "") { li_annex.Text = "<a href='" + model.Annex.ToString() + "'>" + model.Annex.ToString() + "</a>"; } if (model.State.ToString() == "1" || model.State.ToString() == "0") { tr1.Visible = false; tr2.Visible = false; checkdata.Visible = model.State.ToString() != "0"; } else { WX.PRO.State.MODEL statemodel = WX.PRO.State.GetModel("select * from PRO_State where ProjID=" + model.ID.ToString()); if (statemodel.ProcID.ToString() != "" && statemodel.ProcID.ToString() != "0") { //WX.PRO.Process.MODEL procmodel = WX.PRO.Process.GetModel("select top 1 * from PRO_Process where ProjID=" + statemodel.ProjID.ToString() + " and NO="+statemodel.ProcID.ToString()); hivalue = statemodel.ProcID.ToString(); } li_projmanage.Text = WX.CommonUtils.GetRealNameListByUserIdList(statemodel.Manage.ToString()); li_checkfee.Text = statemodel.Fee.ToString(); li_checkmanage.Text = WX.CommonUtils.GetRealNameListByUserIdList(model.Manage.ToString()); li_checkopinion.Text = model.Opinion.ToString(); li_checktime.Text = Convert.ToDateTime(model.Stime.value).ToString("yyyy-MM-dd HH:mm:ss"); checkdata.Visible = false; } } ReBind(); } }
protected void btnDelete_Command(object sender, CommandEventArgs e) { string Id = e.CommandArgument.ToString(); WX.PRO.Project.MODEL model = WX.PRO.Project.GetModel("select * from PRO_Projects where ID=" + Id); int row = ULCode.QDA.XSql.Execute("DELETE FROM PRO_Projects WHERE ID=" + Id); ULCode.QDA.XSql.Execute("DELETE FROM PRO_Process WHERE ProjID=" + Id); if (row > 0) { WX.PRO.Log.AddLog(3, Convert.ToInt32(Id), model.ProjectName.ToString() + "-删除项目。", Request.UserHostAddress); InitComponent(false); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (WX.Request.rProjectId != 0) { WX.PRO.Project.MODEL model = WX.PRO.Project.GetModel("select * from PRO_Projects where ID=" + WX.Request.rProjectId); if (model != null) { Literal1.Text = model.ProjectName.ToString(); Literal2.Text = model.ProjectName.ToString(); } ReBind(); } } }
protected void Page_Load(object sender, EventArgs e) { //1.验证当前用户页面权限 if (!this.Master.A_Edit) { Response.Write("你没有权限访问此功能!"); Response.End(); return; } if (!IsPostBack) { if (Request["id"] != null) { WX.PRO.Project.MODEL model = WX.PRO.Project.GetModel("select * from PRO_Projects where ID=" + Request["id"]); if (model != null) { ui_Name.Text = model.ProjectName.ToString(); ui_days.Text = model.Days.ToString(); if (Convert.ToInt32(model.Persons.ToString()) > 0) { ULCode.QDA.XDataTable xdt = ULCode.QDA.XSql.GetXDataTable("select pu.UserID,te.RealName from PRO_User pu left join TU_Users te on pu.UserID=te.UserID where pu.type=1 and pid=" + model.ID.ToString()); ui_Persons.Value = xdt.ToColValueList(",", 0); li_Persons.Text = xdt.ToColValueList(",", 1); } //ui_Persons.Value = model.Persons.ToString(); ui_fee.Text = model.Fee.ToString(); ui_content.Value = model.Content.ToString(); ui_Imagine.Text = model.Imagine.ToString(); if (model.Annex.ToString() != "") { li_annex.Text = "<a href='" + model.Annex.ToString() + "'>" + model.Annex.ToString() + "</a> <br/>"; } if (ULCode.QDA.XSql.GetDataTable("select ID from PRO_Process where ProjID=" + model.ID.ToString()).Rows.Count > 0) { Button2.Visible = true; } } } } }
protected void Button1_Click(object sender, EventArgs e) { //1.验证当前用户页面权限 if (!this.Master.A_Edit) { Response.Write("你没有权限访问此功能!"); Response.End(); return; } //2.取得用户变量 WX.PRO.Project.MODEL model = WX.PRO.Project.NewDataModel(); if (Request["id"] != null) { model = WX.PRO.Project.GetModel("select * from PRO_Projects where ID=" + Request["id"]); } model.ProjectName.value = ui_Name.Text.Trim(); model.Days.value = ui_days.Text.Trim(); model.Fee.value = ui_fee.Text.Trim(); model.Content.value = ui_content.Value.Trim(); string[] userarry = ui_Persons.Value.Trim().Split(','); //4.业务处理过程 model.Persons.value = ui_Persons.Value != null ? userarry.Length : 0; string fileDir = ""; if (FileUpload1.HasFile) { string fileExtension = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower(); if (!".rar.zip.doc.docx.ppt".Contains(fileExtension)) { ULCode.Debug.Alert(this, "照片格式必须为.rar.zip.doc.docx.ppt!"); return; } fileDir = "/UploadFiles/Proj/" + model.ProjectName.ToString() + DateTime.Now.ToString("-yyyyMMddHHmmss") + fileExtension; try { FileUpload1.SaveAs(Server.MapPath(fileDir)); } catch { fileDir = ""; } } if (fileDir != "") { model.Annex.value = fileDir; } model.Imagine.value = ui_Imagine.Text.Trim(); model.State.value = ((Button)sender).ID == "Button1" ? 0 : 1; int pid = 0; string logstr = model.ProjectName.ToString() + "-添加"; if (Request["id"] != null) { pid = Convert.ToInt32(model.ID.value); logstr = model.ProjectName.ToString() + "-修改"; model.Update(); } else { model.UserID.value = WX.Main.CurUser.UserID; pid = model.Insert(true); } if (ui_Persons.Value != null) { ULCode.QDA.XSql.Execute("delete from PRO_User where type=1 and pid=" + pid); for (int i = 0; i < userarry.Length; i++) { WX.PRO.User.MODEL usermodel = WX.PRO.User.NewDataModel(); usermodel.PID.value = pid; usermodel.type.value = 1; usermodel.UserID.value = userarry[i]; usermodel.Insert(); } } //5.登记日志 WX.PRO.Log.AddLog(0, pid, logstr + (((Button)sender).ID == "Button1" ? "" : "并申请"), Request.UserHostAddress); //6.返回处理结果或返回其它页面。 Response.Redirect("Proj_Project.aspx"); }