protected void update2(object sender, EventArgs e)
{
Return_lineDC DC = new Return_lineDC();
int return_line_id = int.Parse(return_line_id2.Value);
string return_wo_no = return_wo_no2.Value;
int seq_operation_num = 0;
string item_name = item_name2.Value;
int subinventory = 0;
string locator = DropDownList4.Items[DropDownList4.SelectedIndex].Value;
int quit_num = 0;
if (String.IsNullOrEmpty(item_name2.Value))
{
PageUtil.showToast(this.Page, "请输入料号！");
}
else if (String.IsNullOrEmpty(quit_num2.Value))
{
PageUtil.showToast(this.Page, "请输入退料数量！");
}
else
{
try
{
seq_operation_num = int.Parse(seq_operation_num2.Items[seq_operation_num2.SelectedIndex].Value);
subinventory = int.Parse(DropDownList3.Items[DropDownList3.SelectedIndex].Value);
quit_num = int.Parse(quit_num2.Value);
}
catch (Exception ex)
{
PageUtil.showToast(this.Page, "数据转换出错，请检查数据格式！");
return;
}
bool a = DC.updateReturn_line(return_wo_no, return_line_id, seq_operation_num, item_name, quit_num, subinventory, locator);
if (a == true)
{
try
{
Repeater1.DataSource = DC.getReturn_lineByReturn_line_id(return_line_id);
if (Repeater1.DataSource == null)
{
PageUtil.showToast(this.Page, "没有该条数据，查询失败!");
}
else
{
Repeater1.DataBind();
PageUtil.showToast(this.Page, "数据查询成功!");
}
}
catch (Exception ex)
{
PageUtil.showToast(this.Page, "数据查询错误!");
}
PageUtil.showToast(this.Page, "更新单身成功！");
}
else
{
PageUtil.showToast(this.Page, "更新单身失败！");
}
}
}
protected void Opration_SingelQuery(object sender, EventArgs e)
{
Return_lineDC DC = new Return_lineDC();
string subinventory = singlequery_subinventory.Value;
string region = singlequery_region.Value;
string item_name = singlequery_item_name.Value;
string return_qty = singlequery_return_qty.Value;
string return_line_id1 = return_line_id.Value;
int a, return_qty1, return_line_id2;
try
{
return_qty1 = int.Parse(return_qty);
return_line_id2 = int.Parse(return_line_id1);
a = DC.updateNum(subinventory, region, item_name, return_qty1, return_line_id2);
if (a > 0)
{
PageUtil.showToast(this.Page, "退料成功！");
}
else
{
PageUtil.showToast(this.Page, "数据失败！");
}
}
catch (Exception ex)
{
PageUtil.showToast(this.Page, "数据转换出错！");
}
}
protected void delete_single_query(object sender, EventArgs e)
{
Return_lineDC DC = new Return_lineDC();
//List<ModelReturn_line> Data;
int return_line_id = int.Parse(lab3.Value);
bool a = DC.deleteReturn_line(return_line_id);
if (a == true)
{
PageUtil.showToast(this.Page, "删除单身成功！");
//Data = DC.getReturn_lineBySome("", "", "", "", "");
Repeater1.DataSource = DC.getReturn_lineBySome("", "", "", "", "");
if (Repeater1.DataSource == null)
{
PageUtil.showToast(this.Page, "没有该条数据，查询失败!");
}
else
{
Repeater1.DataBind();
PageUtil.showToast(this.Page, "数据查询成功!");
}
Repeater1.DataBind();
}
else
{
PageUtil.showToast(this.Page, "删除单身失败！");
}
}
//删除单头
protected void delete1(object sender, EventArgs e)
{
Return_headerDC DC = new Return_headerDC();
string invoice_no = lab1.Value;
bool a = DC.deleteReturn_header(invoice_no);
if (a == true)
{
string invoice_no1 = invoice_no4.Value;
try
{
Line_Repeater.DataSource = DC.getReturn_headerByLikeINVOICE_NO(invoice_no1);
if (Line_Repeater.DataSource == null)
{
PageUtil.showToast(this, "数据库中没有对应数据，请添加数据后再查询");
}
else
{
Line_Repeater.DataBind();
}
}
catch (Exception ex)
{
PageUtil.showToast(this.Page, "数据查询失败！");
}
Return_lineDC DC1 = new Return_lineDC();
string return_wo_no = return_wo_no4.Value;
try
{
Repeater1.DataSource = DC1.getReturn_lineByLikeRETURN_WO_NO(return_wo_no);
if (Repeater1.DataSource == null)
{
PageUtil.showToast(this, "数据库中没有对应数据，请添加数据后再查询");
}
else
{
Repeater1.DataBind();
}
}
catch (Exception ex)
{
PageUtil.showToast(this.Page, "数据查询错误!");
}
PageUtil.showToast(this.Page, "单据号" + invoice_no + "删除成功！");
}
else
{
PageUtil.showToast(this.Page, "单据号" + invoice_no + "删除失败！");
}
}
//获取料号
protected void getItem_nameByReturn_wo_no(object sender, EventArgs e)
{
Return_lineDC DC = new Return_lineDC();
string Reurn_wo_no = return_wo_no.Value;
if (String.IsNullOrEmpty(Reurn_wo_no))
{
PageUtil.showToast(this.Page, "请输入工单号");
}
try
{
item_name_Insert.Value = DC.getItem_nameByReturn_wo_no(Reurn_wo_no);
}
catch
{
PageUtil.showToast(this.Page, "该工单号下，无料号对应");
}
}
protected void select_singlequery(object sender, EventArgs e)
{
List <ModelReturn_line> Data;
Return_lineDC DC = new Return_lineDC();
string region;
string return_wo_no = singlequery_return_wo_id.Value;
string uom = singlequery_uom_id.Value;
string seq_operation_num = seq_operation_num1.SelectedValue;
if (seq_operation_num.Equals("选择制程"))
{
seq_operation_num = "";
}
string Subinventory = Subinventory1.SelectedValue;
if (Subinventory.Equals("选择库别"))
{
Subinventory = "";
}
region = DropDownList2.SelectedValue;
if (region.Equals("选择区域"))
{
region = "";
}
//Data = DC.getReturn_lineBySome(Subinventory, return_wo_no, seq_operation_num, uom, region);
//if (Data != null)
//{
Repeater1.DataSource = DC.getReturn_lineBySome(Subinventory, return_wo_no, seq_operation_num, uom, region);
if (Repeater1.DataSource == null)
{
PageUtil.showToast(this.Page, "没有该条数据，查询失败!");
}
else
{
Repeater1.DataBind();
PageUtil.showToast(this.Page, "数据查询成功!");
}
//}
//else
PageUtil.showToast(this.Page, "没有该条数据，查询失败!");
seq_operation_num1.SelectedValue = "选择制程";
Subinventory1.SelectedValue = "选择库别";
DropDownList2.SelectedValue = "选择区域";
}
//查询单身
protected void select2(object sender, EventArgs e)
{
Return_lineDC DC = new Return_lineDC();
string return_wo_no = return_wo_no4.Value;
try
{
Repeater1.DataSource = DC.getReturn_lineByLikeRETURN_WO_NO(return_wo_no);
if (Repeater1.DataSource == null)
{
PageUtil.showToast(this, "数据库中没有对应数据，请添加数据后再查询");
}
Repeater1.DataBind();
}
catch (Exception ex)
{
PageUtil.showToast(this.Page, "数据查询错误!");
}
}
//提交单身
protected void insert2(object sender, EventArgs e)
{
Return_lineDC DC = new Return_lineDC();
WoDC woDC = new WoDC();
int return_header_id = int.Parse(Text1.Value);
string return_wo_no1 = return_wo_no.Value;
string item_name = item_name_Insert.Value;
int seq_operation_num = 0;
int subinventory = 0;
string region = DropDownList2.Items[DropDownList2.SelectedIndex].Text;
int quit_number = 0;
if (String.IsNullOrEmpty(quit_num.Value))
{
PageUtil.showToast(this.Page, "请输入退料量");
}
//Items_onhand_qty_detailDC DC2 = new Items_onhand_qty_detailDC();
//List<ModelItems_onhand_qty_detail> item;
//item = DC2.getItems_onhand_qty_detailByITEM_NAME(item_name);
//if (item == null)
//{
// PageUtil.showToast(this.Page, "您输入的料号不存在");
//}
//else
//{
try
{
seq_operation_num = int.Parse(seq_operation_num1.Items[seq_operation_num1.SelectedIndex].Value);
subinventory = int.Parse(DropDownList1.Items[DropDownList1.SelectedIndex].Value);
quit_number = int.Parse(quit_num.Value);
if (quit_number > woDC.getTarget_qtyByReturn_wo_no(return_wo_no1))
{
PageUtil.showToast(this.Page, "退料量大于领料量，请重新输入！");
}
}
catch (Exception ex)
{
PageUtil.showToast(this.Page, "数据转换出错，请检查数据格式！");
return;
}
bool a = DC.insertReturn_line(return_wo_no1, seq_operation_num, item_name, quit_number, subinventory, return_header_id, region);
if (a == true)
{
//string return_wo_no2 = return_wo_no4.Value;
try
{
Repeater1.DataSource = DC.getReturn_lineByLikeRETURN_WO_NO(return_wo_no1);
if (Repeater1.DataSource == null)
{
PageUtil.showToast(this, "数据库中没有对应数据，请添加数据后再查询");
}
else
{
Repeater1.DataBind();
}
}
catch (Exception ex)
{
PageUtil.showToast(this.Page, "数据查询错误!");
}
PageUtil.showToast(this.Page, "添加单身成功！");
}
else
{
PageUtil.showToast(this.Page, "添加单身失败！");
}
//}
}