//分页
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
string po_no = id_po_NO.Value.Trim();
string item_name = id_item_Name.Value.Trim();
string receipt_no = id_receipt_NO.Value.Trim();
GridView1.PageIndex = e.NewPageIndex;
Receive_mtlDC receive_mtlDC = new Receive_mtlDC();//po退回的DataCenter对象
DataSet ds = receive_mtlDC.getSomeFieldsByReceipt_noAndPO_noAndItem_name(receipt_no, po_no, item_name);
GridView1.DataSource = ds;
GridView1.DataBind();
}
public void ProcessRequest(HttpContext context)
{
Receive_mtlDC receive_mtldc = new Receive_mtlDC();
List <string> list = new List <string>();
list = receive_mtldc.getAllReceipt_no();
string json = toJson(list);
context.Response.ContentType = "text/plain";
context.Response.Write(json);
}
//查询
protected void select_click(object sender, EventArgs e)
{
string po_no = id_po_NO.Value.Trim();
string item_name = id_item_Name.Value.Trim();
string receipt_no = id_receipt_NO.Value.Trim();
Receive_mtlDC receive_mtlDC = new Receive_mtlDC();//po退回的DataCenter对象
DataSet ds = receive_mtlDC.getSomeFieldsByReceipt_noAndPO_noAndItem_name(receipt_no, po_no, item_name);
if (ds == null)
{
PageUtil.showToast(this, "未查询到数据！");
id_receipt_NO.Value = "";
id_item_Name.Value = "";
id_po_NO.Value = "";
return;
}
else
{
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
dt.Rows[i]["rcv_qty"] = int.Parse(dt.Rows[i]["rcv_qty"].ToString()) - int.Parse(dt.Rows[i]["return_qty"].ToString()) - int.Parse(dt.Rows[i]["deliver_qty"].ToString());
}
catch (Exception ex)
{
//PageUtil.showToast(this, "数据异常");
Console.Write(ex.Source);
}
}
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
//退回操作
protected void return_click(object sender, EventArgs e)
{
string return_user = null, po_no = null, item_name = null, receipt_no = null, vendor_key = null;
int rcv_qty = 0, return_qty = 0, deliver_qty = 0;
int line_num = 0, required_qty = 0, can_return = 0;
try
{
//操作人员姓名
return_user = Session["LoginName"].ToString();
}
catch (Exception ex)
{
PageUtil.showToast(this, "请登录后在操作！");
return;
}
receipt_no = receipt_no_id.Value.Trim();
if (string.IsNullOrEmpty(receipt_no))
{
PageUtil.showToast(this, "请输入暂收单号");
return;
}
string return_sub = DropDownList1.SelectedValue.ToString();
string return_region = DropDownList2.SelectedValue.ToString();
if (return_sub.Equals("--选择库别--") || return_region.Equals("--选择区域--"))
{
PageUtil.showToast(this, "请选择库别和区域！");
return;
}
Receive_mtlDC receive_mtlDC = new Receive_mtlDC();//po退回的DataCenter对象
DataSet ds = receive_mtlDC.getSomeFieldsByReceipt_no(receipt_no);
if (ds != null)
{
po_no = ds.Tables[0].Rows[0]["po_no"].ToString();
item_name = ds.Tables[0].Rows[0]["item_name"].ToString();
vendor_key = ds.Tables[0].Rows[0]["VENDOR_CODE"].ToString();
try
{
line_num = int.Parse(ds.Tables[0].Rows[0]["line_num"].ToString());
}
catch (Exception ex)
{
PageUtil.showToast(this, "Line Num数据异常！");
Console.Write(ex.Message);
line_num = 0;
}
try
{
//暂收量
rcv_qty = int.Parse(ds.Tables[0].Rows[0]["rcv_qty"].ToString());
}
catch (Exception ex)
{
Console.Write(ex.Message);
PageUtil.showToast(this, "暂收量数据异常！");
rcv_qty = 0;
}
try
{
//退回量
return_qty = int.Parse(ds.Tables[0].Rows[0]["return_qty"].ToString());
}
catch (Exception ex)
{
Console.Write(ex.Message);
PageUtil.showToast(this, "退回量数据异常！");
return_qty = 0;
}
try
{
//入库量
deliver_qty = int.Parse(ds.Tables[0].Rows[0]["deliver_qty"].ToString());
}
catch (Exception ex)
{
Console.Write(ex.Message);
PageUtil.showToast(this, "入库量数据异常！");
deliver_qty = 0;
}
can_return = rcv_qty - return_qty - deliver_qty;
}
else
{
PageUtil.showToast(this, "未找到该暂收单号，请检查暂收单号是否正确！");
return;
}
try
{
required_qty = int.Parse(return_num_id.Value.Trim());
if (required_qty <= 0)
{
PageUtil.showToast(this, "退回量应大于0");
return;
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
PageUtil.showToast(this, "请输入正确的数量");
return_num_id.Value = "";
return;
}
if (required_qty > can_return)
{
PageUtil.showToast(this, "退料量不得大于可退量!");
return_num_id.Value = "";
return;
}
//else if (can_return == required_qty)//退料量等于可退量
//{
// //删除暂收表中的数据，修改po退回总表，po退回明细表，交易表
// if (receive_mtlDC.poReturn_second(receipt_no, vendor_key, line_num, po_no, item_name, required_qty, return_sub, return_region, return_user, DateTime.Now, DateTime.Now))
// {
// PageUtil.showToast(this, "PO退回成功！");
// select_click(sender, e);
// }
// else
// {
// PageUtil.showToast(this, "PO退回失败，请重新操作！");
// }
//}
//退料量小于可退量
else
{
//修改暂收表中的数据，，po退回总表，po退回明细表，交易表
if (receive_mtlDC.poReturn_first(receipt_no, vendor_key, line_num, po_no, item_name, required_qty, return_sub, return_region, return_user, DateTime.Now, DateTime.Now))
{
PageUtil.showToast(this, "PO退回成功！");
select_click(sender, e);
}
else
{
PageUtil.showToast(this, "PO退回失败，请重新操作！");
}
}
}
