protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
WorkOrderManager.RepairData();
//设置工序开工班组
if (ToolManager.CheckParams("GXPRdouctId"))
{
string ids = ToolManager.GetParamsString("GXPRdouctId");
string team = ToolManager.GetParamsString("Team");
SetGXTeam(ids, team);
}
//显示工序信息
if (ToolManager.CheckParams("IsLoadGX"))
{
SetGX();
Response.Write(LoadGX());
Response.End();
return;
}
//生成工序开工单
if (ToolManager.CheckQueryString("IsGenerateGX"))
{
string userId = ToolCode.Tool.GetUser().UserNumber;
WorkOrderManager.RepairData();
var result = WorkOrderManager.GenerateGX(userId);
WorkOrderManager.RepairData();
Response.Write(result);
Response.End();
return;
}
//生成小组开工单
if (ToolManager.CheckQueryString("IsGenerateXZ"))
{
string userId = ToolCode.Tool.GetUser().UserNumber;
WorkOrderManager.RepairData();
var result = WorkOrderManager.GenerateXZ(userId);
WorkOrderManager.RepairData();
Response.Write(result);
Response.End();
return;
}
//更新小组开工单班组【制造】
if (ToolManager.CheckParams("SetType"))
{
string setType = ToolManager.GetParamsString("SetType");
UpdateTem(setType);
}
//检验
if (ToolManager.CheckParams("IsJY"))
{
LoadXZ(false, ToolManager.GetParamsString("ProductId"));
}
//加载小组临时数据[制造]
if (ToolManager.CheckParams("ProductId"))
{
LoadXZ(true, ToolManager.GetParamsString("ProductId"));
}
//第四步【小组开工单，不拆分】
if (ToolManager.CheckParams("Four"))
{
Four();
}
//往工序临时表插入数据
if (ToolManager.CheckQueryString("GetGX"))
{
SetGX();
}
//加载未完成订单明细
LoadPage();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (ToolManager.CheckParams("IsDelete"))
{
List <string> sqls = new List <string>();
string planNumber = ToolManager.GetParamsString("PlanNumber");
string sql = string.Format(@"delete ProductPlanSubDetail where PlanNumber='{0}' ", planNumber);
sqls.Add(sql);
sql = string.Format(@" delete ProductPlanSub where PlanNumber='{0}' ", planNumber);
sqls.Add(sql);
sql = string.Format(@" delete ProductPlanDetail where PlanNumber='{0}' ", planNumber);
sqls.Add(sql);
sql = string.Format(@" delete ProductPlan where PlanNumber='{0}' ", planNumber);
sqls.Add(sql);
string error = string.Empty;
string result = SqlHelper.BatchExecuteSql(sqls, ref error) ? "ok" : error;
Tool.WriteLog(Tool.LogType.Operating, "删除开工单" + planNumber, result);
Response.Write(result);
Response.End();
return;
}
//确认领料
if (ToolManager.CheckQueryString("IsConfirmCollar"))
{
string type = ToolManager.GetQueryString("IsConfirmCollar");
type = type.Equals("sc") ? "生产出库" : "包装出库";
string error = string.Empty;
string result = string.Empty;
string userId = ToolCode.Tool.GetUser().UserNumber;
string[] array = ToolManager.GetQueryString("PlanNumbers").Split(',');
foreach (string str in array)
{
if (!WorkOrderManager.EnterKGD(str, userId, ref error, type))
{
result += error;
}
}
if (string.IsNullOrEmpty(result))
{
Response.Write("1");
Response.End();
return;
}
else
{
Response.Write(result);
Response.End();
return;
}
}
//查询
if (ToolManager.CheckQueryString("pageIndex"))
{
GetPageOperation("btnSearch", "EditProductPlan.aspx", "ProductPlanDetailList.aspx", "ProductPlanSubList.aspx");
}
//审核
if (ToolManager.CheckQueryString("check"))
{
string check = ToolManager.GetQueryString("check");
string temp = ProductPlan.check(ToolManager.GetQueryString("check"));
bool result = temp == "1" ? true : false;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "审核开工单信息" + ToolManager.ReplaceSingleQuotesToBlank(check), "审核成功");
Response.Write(temp);
Response.End();
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "审核开工单信息" + ToolManager.ReplaceSingleQuotesToBlank(check), "审核失败！原因" + temp);
Response.Write(temp);
Response.End();
return;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (ToolManager.CheckParams("IsCheck"))
{
string numbers = ToolManager.GetParamsString("DNumbers");
string sql = string.Format(@" select DeliveryNumber from DeliveryNoteDetailed
where DeliveryNumber in ({0})
group by DeliveryNumber
having SUM(isnull(ConformenceQty,0))=0" , numbers);
DataTable dt = SqlHelper.GetTable(sql);
if (dt != null && dt.Rows.Count != 0)
{
Response.Write("系统检测出所选送货单中有未填写数量的送货单，请确认是否都填写好了实收数量！");
Response.End();
return;
}
else
{
Response.Write("ok");
Response.End();
return;
}
}
//删除
if (ToolManager.CheckQueryString("ids"))
{
string error = string.Empty;
List <string> sqls = new List <string>();
string deliveryNumbers = ToolManager.GetQueryString("ids");
string sql = string.Format(" delete DeliveryNoteDetailed where DeliveryNumber in ({0}) ", deliveryNumbers);
sqls.Add(sql);
sql = string.Format("delete DeliveryBill where DeliveryNumber in ({0})", deliveryNumbers);
sqls.Add(sql);
bool result = SqlHelper.BatchExecuteSql(sqls, ref error);
if (result)
{
Response.Write("1");
Tool.WriteLog(Tool.LogType.Operating, "删除送货单" + deliveryNumbers, "删除成功");
Response.End();
return;
}
else
{
Response.Write(error);
Tool.WriteLog(Tool.LogType.Operating, "删除送货单" + deliveryNumbers, "删除失败！原因" + error);
Response.End();
return;
}
}
//查询
if (ToolManager.CheckQueryString("pageIndex"))
{
GetPage("AddOrEditDeliveryBillList.aspx", "Transfer", "btnSearch", "340", "600");
}
//汇总
if (ToolManager.CheckQueryString("Numbers"))
{
string numbers = ToolManager.GetQueryString("Numbers");
CollectNumber(numbers);
}
//确认
if (ToolManager.CheckQueryString("confirmNumbers"))
{
string numbers = ToolManager.GetQueryString("confirmNumbers");
ConfirmNumber(numbers);
}
divExp.Visible = ToolCode.Tool.GetUserMenuFunc("L0104", "Exp");
}
}
