private void PageInit() { if (Request["OrderID"] != null && Request["OrderID"] != "") { orderids = Request["OrderID"]; WX.WorkOrder.Order.MODEL porder = WX.WorkOrder.Order.NewDataModel(Request["OrderID"]); Title_li.Text = porder.Title.ToString(); Proj_li.Text = WX.WorkOrder.Order.ProjStr[porder.Proj.ToInt32()]; Type_li.Text = WX.WorkOrder.Order.TypeStr[porder.Type.ToInt32()]; YJTime_li.Text = porder.YJTime.ToString(); StateTime_la.Text = WX.CommonUtils.GetRealNameListByUserIdList(porder.UserID.ToString()) + " " + porder.AddTime.ToString(); SubTime_li.Text = porder.SubTime.ToString(); FPTime_li.Text = porder.YSTime.ToString(); StopTime_li.Text = porder.StopTime.ToString(); State_li.Text = WX.WorkOrder.Order.StateStr[porder.State.ToInt32()]; state = porder.State.ToInt32(); Remarks_li.Text = WX.WorkOrder.Order.EnCoding(porder.Remarks.ToString()); Button2.Visible = false; if (porder.State.ToInt32() == 7) { Button2.Visible = true; } DataList3.DataSource = ULCode.QDA.XSql.GetDataTable("select dept.Name DeptName,wdept.DeptID,worder.* from WorkOrder_Dept wdept left join WorkOrder_Orders worder on wdept.WID=worder.ID left join TE_Departments dept on wdept.DeptID=dept.ID where worder.State>0 and wdept.WID=" + Request["OrderID"] + " order by AddTime desc"); DataList3.DataBind(); //if (porder.State.ToInt32() > 1) //{ MessBind(); mess.Visible = true; AppBind(); pingjiafs.Visible = true; pingjiafs.Width = "418px"; //} } }
protected void TextBox1_TextChanged(object sender, EventArgs e) { TextBox tb = (TextBox)sender; WX.WorkOrder.Order.MODEL model = WX.WorkOrder.Order.NewDataModel(tb.ToolTip); model.TopCount.value = tb.Text; model.Update(); Bindrepeater2(); }
private void PageInit() { if (Request["OrderID"] != null && Request["OrderID"] != "") { WX.WorkOrder.Order.MODEL order = WX.WorkOrder.Order.NewDataModel(Request["OrderID"]); YJTime_my.Text = order.YJTime.ToString(); FPTime_my.Text = WX.CommonUtils.GetRealNameListByUserIdList(order.AssignUserID.ToString()) + " " + order.FPTime.ToString(); AddTime_my.Text = order.AddTime.ToString(); YSTime_my.Text = order.YSTime.ToString(); StopTime_my.Text = order.StopTime.ToString(); Count_my.Text = order.Count.ToString(); State_my.Text = WX.WorkOrder.Order.StateStr[order.State.ToInt32()]; WX.WorkOrder.Order.MODEL porder = WX.WorkOrder.Order.NewDataModel(order.PID.ToString()); Title_li.Text = porder.Title.ToString() + "-" + GetMacAddress(); if (porder.UserID.ToString() == this.CurUser.UserID) { Title_li.Text = "<a style='font-weight:bold;' href='WorkOrder_Show.aspx?OrderID=" + porder.ID.ToString() + "'>>> " + Title_li.Text + "</a>"; } Proj_li.Text = WX.WorkOrder.Order.ProjStr[porder.Proj.ToInt32()]; Type_li.Text = WX.WorkOrder.Order.TypeStr[porder.Type.ToInt32()]; YJTime_li.Text = porder.YJTime.ToString(); StateTime_la.Text = WX.CommonUtils.GetRealNameListByUserIdList(porder.UserID.ToString()) + " " + porder.AddTime.ToString(); SubTime_li.Text = porder.SubTime.ToString(); FPTime_li.Text = porder.YSTime.ToString(); StopTime_li.Text = porder.StopTime.ToString(); State_li.Text = WX.WorkOrder.Order.StateStr[porder.State.ToInt32()]; FS_drop.Items.Add(new ListItem("@" + WX.CommonUtils.GetRealNameListByUserIdList(porder.UserID.ToString()), porder.UserID.ToString())); if (porder.UserID.ToString() != order.ExecUserID.ToString()) { FS_drop.Items.Add(new ListItem("@" + WX.CommonUtils.GetRealNameListByUserIdList(order.ExecUserID.ToString()), order.ExecUserID.ToString())); } state = order.State.ToInt32(); Remarks_li.Text = WX.WorkOrder.Order.EnCoding(porder.Remarks.ToString()); if (order.State.ToInt32() > 3) { MessBind(porder.ID.ToInt32()); mess.Visible = true; if (order.State.ToInt32() == 6 || order.State.ToInt32() == 8) { messfs.Visible = false; mess.Width = "418px"; } if (order.State.ToInt32() == 8) { pingjia.Visible = true; } if (order.State.ToInt32() >= 8) { AppBind(); pingjiafs.Visible = true; pingjiafs.Width = "418px"; } } } }
//上移 protected void ImageButton1_Click(object sender, EventArgs e) { ImageButton img = (ImageButton)sender; TextBox tb = (TextBox)Repeater2.Items[Convert.ToInt32(img.CommandName)].FindControl("TextBox1"); WX.WorkOrder.Order.MODEL model = WX.WorkOrder.Order.NewDataModel(img.CommandArgument); model.TopTime.value = DateTime.Now; model.TopCount.value = tb.Text; model.Update(); Bindrepeater2(); }
public string Getchilds(int Id) { string sSql = ""; string bodystr = ""; string mydept = ""; WX.WorkOrder.Order.MODEL model = WX.WorkOrder.Order.NewDataModel(Id); if (model.DeptWorkID.ToString() == "-1") { this.CurUser.LoadMyDepartment(false); sSql = "select *,(select count(*) from WorkOrder_Message where WID=WorkOrder_Orders.ID and State=0 and ToUserID='" + this.CurUser.UserID + "') mescount from WorkOrder_Orders where DeptWorkID=" + this.CurUser.UserModel.DepartmentID.ToString() + " and PID=" + Id; if (Request["State"] != null && Convert.ToInt32(Request["State"]) >= 3) { sSql += " and State=" + Request["State"]; } System.Data.DataTable dt2 = ULCode.QDA.XSql.GetDataTable(sSql); for (int j = 0; j < dt2.Rows.Count; j++) { mydept = dt2.Rows[j]["ExecUserID"].ToString() == this.CurUser.UserID ? "" : "color:#aaa;"; bodystr += "<tr style=\"display:none;\" class=\"item" + Id + "\"><td colspan='2'><div style='padding-left:100px;'>├ <a style='" + mydept + "' href=\"javascript:PopupIFrame('" + WX.Main.DealWithUrlForClient("WorkOrder_" + (dt2.Rows[j]["ExecUserID"].ToString() == this.CurUser.UserID ? "My" : "Assign") + "_Show.aspx?OrderID=" + dt2.Rows[j]["ID"]) + "','查看任务','','',850,550)\">" + WX.CommonUtils.GetRealNameListByUserIdList(dt2.Rows[j]["ExecUserID"].ToString()) + " : " + dt2.Rows[j]["Title"] + (Convert.ToInt32(dt2.Rows[j]["mescount"]) > 0 ? "<img src='/images/4.gif' alt='您有新消息'/>" : "") + "</a></div></td><td> </td><td>" + Convert.ToDateTime(dt2.Rows[j]["AddTime"]).ToString("MM-dd HH:mm") + "</td><td>" + GetTimeimg(dt2.Rows[j]["SubTime"].ToString(), dt2.Rows[j]["AddTime"].ToString(), 1, Convert.ToInt32(dt2.Rows[j]["ID"].ToString()), 3, 0) + "</td><td>" + GetTimeimg(dt2.Rows[j]["FPTime"].ToString(), dt2.Rows[j]["FPTime"].ToString(), 2, Convert.ToInt32(dt2.Rows[j]["ID"].ToString()), 3, 0) + "</td><td>" + GetTimeimg(dt2.Rows[j]["YSTime"].ToString(), dt2.Rows[j]["SubTime"].ToString(), 3, Convert.ToInt32(dt2.Rows[j]["ID"].ToString()), 3, 0) + "</td><td>" + GetTimeimg(dt2.Rows[j]["StopTime"].ToString(), dt2.Rows[j]["YSTime"].ToString(), 4, Convert.ToInt32(dt2.Rows[j]["ID"].ToString()), 3, 0) + "</td><td class=\"state" + dt2.Rows[j]["State"] + "\">" + WX.WorkOrder.Order.StateStr[Convert.ToInt32(dt2.Rows[j]["State"])] + "</td></tr>"; } } else { sSql = " select wdept.DeptID,dept.Name DeptName,wdept.*,worder.AddTime from WorkOrder_Dept wdept left join WorkOrder_Orders worder on wdept.WID=worder.ID left join TE_Departments dept on wdept.DeptID=dept.ID where WID=" + Id; if (Request["State"] != null) { this.CurUser.LoadUserModel(false); sSql += " and wdept.DeptID=" + this.CurUser.UserModel.DepartmentID.ToString(); } System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable(sSql); for (int i = 0; i < dt.Rows.Count; i++) { sSql = "select *,(select count(*) from WorkOrder_Message where WID=WorkOrder_Orders.ID and State=0 and ToUserID='" + this.CurUser.UserID + "') mescount from WorkOrder_Orders where DeptWorkID=" + dt.Rows[i]["DeptID"] + " and PID=" + dt.Rows[i]["WID"]; if (Request["State"] != null && Convert.ToInt32(Request["State"]) >= 3) { sSql += " and State=" + Request["State"]; } System.Data.DataTable dt2 = ULCode.QDA.XSql.GetDataTable(sSql); if (Request["State"] != null && dt2.Rows.Count == 0 && Convert.ToInt32(Request["State"]) >= 2) { continue; } mydept = dt.Rows[i]["DeptID"].ToString() == this.CurUser.UserModel.DepartmentID.ToString() ? "" : "color:#aaa;"; bodystr += "<tr style=\"display:none;\" class=\"item" + Id + "\"><td colspan='2'><div style='padding-left:50px;" + mydept + "'><b>└ " + dt.Rows[i]["DeptName"] + "</b></div></td><td> </td><td>" + Convert.ToDateTime(dt.Rows[i]["AddTime"]).ToString("MM-dd HH:mm") + "</td><td>" + GetTimeimg(dt.Rows[i]["SubTime"].ToString(), dt.Rows[i]["AddTime"].ToString(), 1, Id, 2, 0) + "</td><td>" + GetTimeimg(dt.Rows[i]["FPTime"].ToString(), dt.Rows[i]["SubTime"].ToString(), 2, Id, 2, Convert.ToInt32(dt.Rows[i]["DeptID"].ToString())) + "</td><td>" + GetTimeimg(dt.Rows[i]["YSTime"].ToString(), dt.Rows[i]["FPTime"].ToString(), 3, Id, 2, Convert.ToInt32(dt.Rows[i]["DeptID"].ToString())) + "</td><td>" + GetTimeimg(dt.Rows[i]["StopTime"].ToString(), dt.Rows[i]["YSTime"].ToString(), 4, Id, 2, 0) + "</td><td class=\"state" + dt.Rows[i]["State"] + "\">" + WX.WorkOrder.Order.StateStr[Convert.ToInt32(dt.Rows[i]["State"])] + "</td></tr>"; for (int j = 0; j < dt2.Rows.Count; j++) { mydept = dt2.Rows[j]["ExecUserID"].ToString() == this.CurUser.UserID ? "" : "color:#aaa;"; bodystr += "<tr style=\"display:none;\" class=\"item" + Id + "\"><td colspan='2'><div style='padding-left:100px;'>├ <a style='" + mydept + "' href=\"javascript:PopupIFrame('" + WX.Main.DealWithUrlForClient("WorkOrder_" + (dt2.Rows[j]["ExecUserID"].ToString() == this.CurUser.UserID ? "My" : "Assign") + "_Show.aspx?OrderID=" + dt2.Rows[j]["ID"]) + "','查看任务','','',850,550)\">" + WX.CommonUtils.GetRealNameListByUserIdList(dt2.Rows[j]["ExecUserID"].ToString()) + " : " + dt2.Rows[j]["Title"] + (Convert.ToInt32(dt2.Rows[j]["mescount"]) > 0 ? "<img src='/images/4.gif' alt='您有新消息'/>" : "") + "</a></div></td><td> </td><td>" + Convert.ToDateTime(dt2.Rows[j]["AddTime"]).ToString("MM-dd HH:mm") + "</td><td>" + GetTimeimg(dt2.Rows[j]["SubTime"].ToString(), dt2.Rows[j]["AddTime"].ToString(), 1, Convert.ToInt32(dt2.Rows[j]["ID"].ToString()), 3, 0) + "</td><td>" + GetTimeimg(dt2.Rows[j]["FPTime"].ToString(), dt2.Rows[j]["FPTime"].ToString(), 2, Convert.ToInt32(dt2.Rows[j]["ID"].ToString()), 3, 0) + "</td><td>" + GetTimeimg(dt2.Rows[j]["YSTime"].ToString(), dt2.Rows[j]["SubTime"].ToString(), 3, Convert.ToInt32(dt2.Rows[j]["ID"].ToString()), 3, 0) + "</td><td>" + GetTimeimg(dt2.Rows[j]["StopTime"].ToString(), dt2.Rows[j]["YSTime"].ToString(), 4, Convert.ToInt32(dt2.Rows[j]["ID"].ToString()), 3, 0) + "</td><td class=\"state" + dt2.Rows[j]["State"] + "\">" + WX.WorkOrder.Order.StateStr[Convert.ToInt32(dt2.Rows[j]["State"])] + "</td></tr>"; } } } return(bodystr); }
protected void Button1_Click(object sender, EventArgs e) { WX.WorkOrder.Message.MODEL mess = WX.WorkOrder.Message.NewDataModel(); mess.WID.value = Request["OrderID"]; mess.FromUserID.value = this.CurUser.UserID; mess.ToUserID.value = FS_drop.SelectedValue; mess.Remarks.value = MessContent_txt.Text; mess.Insert(); MessContent_txt.Text = ""; WX.WorkOrder.Order.MODEL order = WX.WorkOrder.Order.NewDataModel(Request["OrderID"]); MessBind(order.PID.ToInt32()); }
private void BindDate() { for (int i = 0; i < WX.WorkOrder.Order.TypeStr.Length; i++) { Type_drop.Items.Add(new ListItem(WX.WorkOrder.Order.TypeStr[i], i.ToString())); } for (int i = 0; i < WX.WorkOrder.Order.ProjStr.Length; i++) { Proj_drop.Items.Add(new ListItem(WX.WorkOrder.Order.ProjStr[i], i.ToString())); } if (Request["OrderID"] != null && Request["OrderID"] != "") { WX.WorkOrder.Order.MODEL order = WX.WorkOrder.Order.NewDataModel(Request["OrderID"]); Remarks_txt.Text = order.Remarks.ToString(); Title_txt.Text = order.Title.ToString(); Proj_drop.SelectedValue = order.Proj.ToString(); Type_drop.SelectedValue = order.Type.ToString(); YJTime_txt.Text = order.YJTime.ToString() != "" ? Convert.ToDateTime(order.YJTime.ToString()).ToString("yyyy-MM-dd") : ""; if (order.DeptWorkID.ToString() == "") { otherDept.SelectedValue = "1"; } DeptBind(); if (otherDept.SelectedValue == "-1") { //WX.Main.CurUser.LoadUserModel(false); //System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable("select ExecUserID from WorkOrder_Orders where PID=" + Request["OrderID"]); //for (int i = 0; i < dt.Rows.Count; i++) //{ // Dept_check.Items.FindByValue(dt.Rows[i]["ExecUserID"].ToString()).Selected = true; //} Dept_check.Visible = false; DataList2.Visible = true; UserBind(); } else { Dept_check.Visible = true; DataList2.Visible = false; string sSql = " select * from WorkOrder_Dept where WID=" + order.ID.ToString(); System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable(sSql); for (int i = 0; i < dt.Rows.Count; i++) { Dept_check.Items.FindByValue(dt.Rows[i]["DeptID"].ToString()).Selected = true; } } } else { DeptBind(); } }
private void PageInit() { if (Request["OrderID"] != null && Request["OrderID"] != "") { WX.WorkOrder.Order.MODEL porder = WX.WorkOrder.Order.NewDataModel(Request["OrderID"]); Title_li.Text = porder.Title.ToString(); Proj_li.Text = WX.WorkOrder.Order.ProjStr[porder.Proj.ToInt32()]; Type_li.Text = WX.WorkOrder.Order.TypeStr[porder.Type.ToInt32()]; YJTime_li.Text = porder.YJTime.ToString(); StateTime_li.Text = porder.StateTime.ToString(); Remarks_li.Text = porder.Remarks.ToString(); } UserBind(); }
private void Exceup(int state) { this.CurUser.LoadUserModel(false); //WX.Main.ExcuteUpdate("WorkOrder_Orders", "State=" + state + ",StateTime=getdate()", "ID=" + Request["OrderID"]); WX.WorkOrder.Order.MODEL order = WX.WorkOrder.Order.NewDataModel(Request["OrderID"]); order.State.value = state; order.StateTime.value = DateTime.Now; order.StopTime.value = DateTime.Now; order.Update(); WX.Main.ExcuteUpdate("WorkOrder_Dept", "State=" + state + ",StopTime=getdate()" + ",StateTime=getdate()", "WID=" + order.ID.ToString()); WX.Main.ExcuteUpdate("WorkOrder_Orders", "State=" + state + ",StopTime=getdate()" + ",StateTime=getdate()", "PID=" + order.ID.ToString()); WX.WorkOrder.Message.MODEL mess = WX.WorkOrder.Message.NewDataModel(); mess.WID.value = Request["OrderID"]; mess.Remarks.value = "本任务“已验收”完成。"; mess.Insert(); PageInit(); }
private void Exceup(int state, int deptstate) { this.CurUser.LoadUserModel(false); WX.WorkOrder.Order.MODEL order = WX.WorkOrder.Order.NewDataModel(Request["OrderID"]); order.State.value = state; order.StateTime.value = DateTime.Now; if (state == 7) { order.YSTime.value = DateTime.Now; } order.Update(); WX.WorkOrder.Message.MODEL mess = WX.WorkOrder.Message.NewDataModel(); mess.WID.value = Request["OrderID"]; mess.Remarks.value = WX.CommonUtils.GetRealNameListByUserIdList(order.ExecUserID.ToString()) + "的工作“" + WX.WorkOrder.Order.StateStr[order.State.ToInt32()] + "”"; mess.Insert(); System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable("select (select count(*) from WorkOrder_Orders where PID=" + order.PID.ToString() + " and DeptWorkID=" + this.CurUser.UserModel.DepartmentID.ToString() + ") ccount,(select count(*) from WorkOrder_Orders where PID=" + order.PID.ToString() + " and DeptWorkID=" + this.CurUser.UserModel.DepartmentID.ToString() + " and State>=" + state + ") scount"); if (dt.Rows[0]["ccount"].ToString() == dt.Rows[0]["scount"].ToString()) { int n = WX.Main.ExcuteUpdate("WorkOrder_Dept", "State=" + deptstate + (deptstate == 2 ? ",FPTime=getdate()" : (deptstate == 7 ? ",YSTime=getdate()" : "")) + ",StateTime=getdate()", "DeptID=" + this.CurUser.UserModel.DepartmentID.ToString() + " and WID=" + order.PID.ToString() + " and State<" + deptstate); if (n > 0) { mess = WX.WorkOrder.Message.NewDataModel(); mess.WID.value = Request["OrderID"]; mess.Remarks.value = WX.CommonUtils.GetDeptNameListByDeptIdList(order.DeptWorkID.ToString()) + "的工作“" + WX.WorkOrder.Order.StateStr[deptstate] + "”"; mess.Insert(); } } System.Data.DataTable dt2 = ULCode.QDA.XSql.GetDataTable("select (select count(*) from WorkOrder_Dept where WID=" + order.PID.ToString() + ") ccount,(select count(*) from WorkOrder_Dept where WID=" + order.PID.ToString() + " and State>=" + deptstate + ") scount"); if (dt2.Rows[0]["ccount"].ToString() == dt2.Rows[0]["scount"].ToString()) { int n = WX.Main.ExcuteUpdate("WorkOrder_Orders", "State=" + deptstate + (deptstate == 2 ? ",FPTime=getdate()" : (deptstate == 7 ? ",YSTime=getdate()" : "")) + ",StateTime=getdate()", "ID=" + order.PID.ToString() + " and State<" + deptstate); if (n > 0) { mess = WX.WorkOrder.Message.NewDataModel(); mess.WID.value = Request["OrderID"]; mess.Remarks.value = "全部参与部门的工作“" + WX.WorkOrder.Order.StateStr[deptstate] + "”"; mess.Insert(); } } Response.Redirect(WX.Main.DealWithUrlForClient("WorkOrder_My_Show.aspx?OrderID=" + order.ID.ToString())); }
protected void Button1_Click(object sender, EventArgs e) { WX.Main.CurUser.LoadUserModel(false); WX.WorkOrder.Order.MODEL porder = WX.WorkOrder.Order.NewDataModel(Request["OrderID"]); WX.WorkOrder.Order.MODEL order = WX.WorkOrder.Order.NewDataModel(); if (Request["POrderID"] != null && Request["POrderID"] != "") { order = WX.WorkOrder.Order.NewDataModel(Request["POrderID"]); } else { order.ExecUserID.value = Request["UserID"]; order.PID.value = Request["OrderID"]; } order.DeptWorkID.value = WX.Main.CurUser.UserModel.DepartmentID.value; order.UserID.value = porder.UserID.value; order.AssignUserID.value = WX.Main.CurUser.UserID; order.Remarks.value = Remarks_txt.Text; order.Title.value = Title_txt.Text; order.Proj.value = porder.Proj.value; order.Type.value = porder.Type.value; order.Count.value = Count_txt.Text; order.State.value = 3; order.YJTime.value = YJTime_txt.Text; order.StateTime.value = DateTime.Now; if (Request["POrderID"] != null && Request["POrderID"] != "") { order.Update(); } else { order.Insert(); } if (porder.State.ToInt32() < 2) { porder.State.value = 2; porder.Update(); } Response.Redirect("WorkOrder_Fenpei.aspx?OrderID=" + Request["OrderID"]); }
private void PageInit() { if (Request["OrderID"] != null && Request["OrderID"] != "") { WX.WorkOrder.Order.MODEL porder = WX.WorkOrder.Order.NewDataModel(Request["OrderID"]); if (Request["POrderID"] != null && Request["POrderID"] != "") { WX.WorkOrder.Order.MODEL order = WX.WorkOrder.Order.NewDataModel(Request["POrderID"]); Title_txt.Text = order.Title.ToString(); YJTime_txt.Text = order.YJTime.ToString(); Remarks_txt.Text = order.Remarks.ToString(); ExecUserID_li.Text = WX.CommonUtils.GetRealNameListByUserIdList(order.ExecUserID.ToString()); Count_txt.Text = order.Count.ToString(); } else { Title_txt.Text = porder.Title.ToString(); YJTime_txt.Text = porder.YJTime.ToString(); Remarks_txt.Text = porder.Remarks.ToString(); ExecUserID_li.Text = WX.CommonUtils.GetRealNameListByUserIdList(Request["UserID"]); } } }
private void PageInit() { if (Request["OrderID"] != null && Request["OrderID"] != "") { WX.WorkOrder.Order.MODEL order = WX.WorkOrder.Order.NewDataModel(Request["OrderID"]); YJTime_my.Text = order.YJTime.ToString(); FPTime_my.Text = WX.CommonUtils.GetRealNameListByUserIdList(order.AssignUserID.ToString()) + " " + order.FPTime.ToString(); AddTime_my.Text = order.AddTime.ToString(); YSTime_my.Text = order.YSTime.ToString(); StopTime_my.Text = order.StopTime.ToString(); Count_my.Text = order.Count.ToString(); State_my.Text = WX.WorkOrder.Order.StateStr[order.State.ToInt32()]; WX.WorkOrder.Order.MODEL porder = WX.WorkOrder.Order.NewDataModel(order.PID.ToString()); Title_li.Text = porder.Title.ToString(); Proj_li.Text = WX.WorkOrder.Order.ProjStr[porder.Proj.ToInt32()]; Type_li.Text = WX.WorkOrder.Order.TypeStr[porder.Type.ToInt32()]; YJTime_li.Text = porder.YJTime.ToString(); SubTime_li.Text = porder.SubTime.ToString(); FPTime_li.Text = porder.AddTime.ToString(); YSTime_li.Text = porder.YSTime.ToString(); StopTime_li.Text = porder.StopTime.ToString(); State_li.Text = WX.WorkOrder.Order.StateStr[porder.State.ToInt32()]; StateTime_la.Text = WX.CommonUtils.GetRealNameListByUserIdList(porder.UserID.ToString()) + " " + porder.AddTime.ToString(); FS_drop.Items.Add(new ListItem("@" + WX.CommonUtils.GetRealNameListByUserIdList(porder.UserID.ToString()), porder.UserID.ToString())); if (order.UserID.ToString() != order.AssignUserID.ToString()) { FS_drop.Items.Add(new ListItem("@" + WX.CommonUtils.GetRealNameListByUserIdList(order.AssignUserID.ToString()), order.AssignUserID.ToString())); } state = order.State.ToInt32(); Remarks_li.Text = WX.WorkOrder.Order.EnCoding(porder.Remarks.ToString()); Button2.Visible = false; Button3.Visible = false; Button4.Visible = false; Button5.Visible = false; if (order.State.ToInt32() == 3) { Button2.Visible = true; } else if (order.State.ToInt32() == 4 || order.State.ToInt32() == 6) { System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable("select count(*) scount from WorkOrder_Orders where ExecUserID='" + this.CurUser.UserID + "' and State=5"); if (dt.Rows[0]["scount"].ToString() == "0") { Button3.Visible = true; } } else if (order.State.ToInt32() == 5) { Button4.Visible = true; Button5.Visible = true; } if (order.State.ToInt32() > 3) { MessBind(porder.ID.ToInt32()); mess.Visible = true; if (order.State.ToInt32() == 6 || order.State.ToInt32() == 8) { messfs.Visible = false; mess.Width = "418px"; } if (order.State.ToInt32() >= 6) { AppBind(); pingjiafs.Visible = true; pingjiafs.Width = "418px"; } } } }
protected void Button1_Click(object sender, EventArgs e) { WX.Main.CurUser.LoadUserModel(false); WX.WorkOrder.Order.MODEL porder = WX.WorkOrder.Order.NewDataModel(Request["OrderID"]); WX.WorkOrder.Order.MODEL order; WX.WorkOrder.Dept.MODEL deptmodel = WX.WorkOrder.Dept.GetModel("select * from WorkOrder_Dept where WID=" + porder.ID.ToString() + " and DeptID=" + WX.Main.CurUser.UserModel.DepartmentID.value); if (deptmodel != null && deptmodel.SubTime.ToString() == "") { deptmodel.SubTime.value = DateTime.Now; deptmodel.Update(); } for (int i = 0; i < DataList2.Items.Count; i++) { order = WX.WorkOrder.Order.NewDataModel(); CheckBox cbox = (CheckBox)DataList2.Items[i].FindControl("CheckBox1"); HiddenField hf = (HiddenField)DataList2.Items[i].FindControl("HiddenField1"); TextBox tbox = (TextBox)DataList2.Items[i].FindControl("TextBox1"); if (cbox.Checked) { if (hf.Value == "") { order.PID.value = Request["OrderID"]; order.DeptWorkID.value = WX.Main.CurUser.UserModel.DepartmentID.value; order.UserID.value = porder.UserID.value; order.AssignUserID.value = WX.Main.CurUser.UserID; order.ExecUserID.value = cbox.ToolTip; order.Remarks.value = porder.Remarks.ToString(); order.Title.value = porder.Title.ToString(); order.Proj.value = porder.Proj.value; order.Type.value = porder.Type.value; order.Count.value = tbox.Text; order.State.value = 3; order.SubTime.value = DateTime.Now; order.YJTime.value = porder.YJTime.value; order.StateTime.value = DateTime.Now; order.Insert(); } else { order = WX.WorkOrder.Order.NewDataModel(hf.Value); order.Count.value = tbox.Text; order.StateTime.value = DateTime.Now; order.Update(); } } else { if (hf.Value != "") { WX.Main.ExecuteDelete("WorkOrder_Orders", "ID", hf.Value); } } } System.Data.DataTable dt2 = ULCode.QDA.XSql.GetDataTable("select (select count(*) from WorkOrder_Dept where WID=" + porder.ID.ToString() + ") ccount,(select count(*) from WorkOrder_Dept where WID=" + porder.ID.ToString() + " and State>=2) scount"); if (dt2.Rows[0]["ccount"].ToString() == dt2.Rows[0]["scount"].ToString() && porder.State.ToInt32() < 2) { porder.State.value = 2; porder.Update(); } Response.Write("<script type=\"text/javascript\">window.parent.Dialog.close(); </script>"); }
private void EditOrder(int state) { WX.WorkOrder.Order.MODEL order = WX.WorkOrder.Order.NewDataModel(); if (Request["OrderID"] != null && Request["OrderID"] != "") { order = WX.WorkOrder.Order.NewDataModel(Request["OrderID"]); } order.UserID.value = this.CurUser.UserID; order.Remarks.value = Remarks_txt.Text; order.Title.value = Title_txt.Text; order.Proj.value = Proj_drop.SelectedValue; order.Type.value = Type_drop.SelectedValue; order.State.value = state; if (state == 1) { order.SubTime.value = DateTime.Now; } if (YJTime_txt.Text.Trim() != "") { order.YJTime.value = YJTime_txt.Text; } order.StateTime.value = DateTime.Now; int id = 0; if (otherDept.SelectedValue == "-1") { order.DeptWorkID.value = -1; } if (Request["OrderID"] != null && Request["OrderID"] != "") { id = order.ID.ToInt32(); order.Update(); //WX.Main.ExecuteDelete("WorkOrder_Dept", "WID", id.ToString()); } else { id = order.Insert(true); } WX.WorkOrder.Dept.MODEL dept; if (otherDept.SelectedValue == "-1") { WX.Main.ExecuteDelete("WorkOrder_Orders", "PID", id.ToString()); this.CurUser.LoadUserModel(false); if (!(Request["OrderID"] != null && Request["OrderID"] != "")) { dept = WX.WorkOrder.Dept.NewDataModel(); dept.WID.value = id; dept.DeptID.value = this.CurUser.UserModel.DepartmentID.ToString(); if (state == 1) { dept.SubTime.value = DateTime.Now; } dept.Insert(); } else { dept = WX.WorkOrder.Dept.GetModel("select * from WorkOrder_Dept where WID=" + id + " and DeptID=" + this.CurUser.UserModel.DepartmentID.value); if (state == 1 && dept.SubTime.ToString() == "") { dept.SubTime.value = DateTime.Now; dept.Update(); } } WX.WorkOrder.Order.MODEL corder; for (int i = 0; i < DataList2.Items.Count; i++) { corder = WX.WorkOrder.Order.NewDataModel(); CheckBox cbox = (CheckBox)DataList2.Items[i].FindControl("CheckBox1"); HiddenField hf = (HiddenField)DataList2.Items[i].FindControl("HiddenField1"); TextBox tbox = (TextBox)DataList2.Items[i].FindControl("TextBox1"); if (cbox.Checked) { corder.PID.value = id; corder.DeptWorkID.value = this.CurUser.UserModel.DepartmentID.value; corder.UserID.value = order.UserID.value; corder.AssignUserID.value = this.CurUser.UserID; corder.ExecUserID.value = cbox.ToolTip; corder.Remarks.value = order.Remarks.ToString(); corder.Title.value = order.Title.ToString(); corder.Proj.value = order.Proj.value; corder.Type.value = order.Type.value; corder.Count.value = IsNUM(tbox.Text); corder.State.value = 3; if (state == 1) { corder.SubTime.value = DateTime.Now; } if (order.YJTime.ToString() != "") { corder.YJTime.value = order.YJTime.value; } corder.StateTime.value = DateTime.Now; corder.Insert(); } } } else { WX.Main.ExecuteDelete("WorkOrder_Dept", "WID", id.ToString()); for (int i = 0; i < Dept_check.Items.Count; i++) { if (Dept_check.Items[i].Selected) { dept = WX.WorkOrder.Dept.NewDataModel(); dept.WID.value = id; dept.DeptID.value = Dept_check.Items[i].Value; if (state == 1) { dept.SubTime.value = DateTime.Now; } dept.Insert(); } } } Response.Redirect("WorkOrder_List.aspx"); }