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();
}
//上移
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();
}
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"]);
}
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");
}
