/**
*
* 查询复验参数表信息*
*
***/
protected void Select(object sender, EventArgs e)
{
//获取前台数据
string PN_HEAD = pn_head.Value;
Pn_Leng(PN_HEAD, "Pn_head");
string REINSPECT_WEEK = reinspect_week.Value;
Re_Leng(REINSPECT_WEEK, "复验周期");
//查询复验参数表数据
Reinspect_parameterDC reinspect_parameterDC = new Reinspect_parameterDC();
DataSet ds = new DataSet();
ds = reinspect_parameterDC.searchReinspect_parameters(PN_HEAD, REINSPECT_WEEK);
if (ds == null)
{
if (PN_HEAD == string.Empty && REINSPECT_WEEK == string.Empty)
{
PageUtil.showToast(this, "复验参数表中无任何数据！");
}
else
{
PageUtil.showToast(this, "复验参数表中无符合条件的数据！");
}
}
else
{
Line_Repeater.DataSource = ds;
Line_Repeater.DataBind();
}
}
/**
*
* 修改区域表信息*
*
***/
protected void Update(object sender, EventArgs e)
{
//获取输入的数据
string UNIQUE_ID2 = Request.Form["unique_id2"];
string PN_HEAD2 = Request.Form["pn_head2"];
Pn_Leng(PN_HEAD2, "Pn_head");
string REINSPECT_WEEK2 = Request.Form["reinspect_week2"];
Re_Leng(REINSPECT_WEEK2, "复验周期");
string REINSPECT_QTY2 = "";
//修改数据
Reinspect_parameterDC reinspect_parameterDC = new Reinspect_parameterDC();
DataSet ds = new DataSet();
try
{
ds = reinspect_parameterDC.updateReinspect_parameters(UNIQUE_ID2, PN_HEAD2, REINSPECT_WEEK2, REINSPECT_QTY2);
Line_Repeater.DataSource = ds;
Line_Repeater.DataBind();
PageUtil.showToast(this, "修改复验参数表信息成功！");
}
catch
{
PageUtil.showToast(this, "修改复验参数表信息失败！");
}
}
/**
*
* 删除区域表信息*
*
* **/
protected void Delete(object sender, EventArgs e)
{
//取主键（Unique_id）的值
string UNIQUE_ID3 = Request.Form["unique_id3"];
//删除复验参数数据
Reinspect_parameterDC reinspect_parameterDC = new Reinspect_parameterDC();
DataSet ds = new DataSet();
try
{
ds = reinspect_parameterDC.deleteReinspect_parameters(UNIQUE_ID3);
Line_Repeater.DataSource = ds;
Line_Repeater.DataBind();
}
catch
{
PageUtil.showToast(this, "删除复验参数表信息失败！");
}
}
/**
*
* 新增复验参数表信息*
*
***/
protected void Insert(object sender, EventArgs e)
{
//获取输入的数据
string PN_HEAD1 = pn_head1.Value;
Pn_Leng(PN_HEAD1, "Pn_head");
string REINSPECT_WEEK1 = reinspect_week1.Value;
Re_Leng(REINSPECT_WEEK1, "复验周期");
string REINSPECT_QTY1 = "";
//判断输入是否全为空
if (PN_HEAD1 == string.Empty && REINSPECT_WEEK1 == string.Empty)
{
PageUtil.showToast(this, "新增复验参数表数据的输入不能全为空！");
return;
}
//将数据插入数据表
Reinspect_parameterDC reinspect_parameterDC = new Reinspect_parameterDC();
DataSet ds = new DataSet();
ds = reinspect_parameterDC.searchReinspect_parameters(PN_HEAD1, "");
if (ds != null)
{
PageUtil.showToast(this, "该Pn_head已存在！");
}
else
{
try
{
ds = reinspect_parameterDC.insertReinspect_parameters(PN_HEAD1, REINSPECT_WEEK1, REINSPECT_QTY1);
Line_Repeater.DataSource = ds;
Line_Repeater.DataBind();
}
catch
{
PageUtil.showToast(this, "新增复验参数表信息失败！");
}
}
}
//提交按钮
protected void Commite_reinspect(object sender, EventArgs e)
{
string item_name = select_name_reinspect.Value.Trim();
string datecode = DateCode_reinspect.Value.Trim();
string frame_name = Request.Form["frame_name_reinspect"]; //frame_name_reinspect.Value;
string status = reinspect_select.Value;
string remark = remark_reinspect.Value.Trim();
//判断输入框输入数据是否超出范围
StrItem_name(item_name);
StrRemark(remark);
StrDatecode(datecode);
bool flag;
string temp_flag;
string check_user = "";
try
{
check_user = Session["LoginName"].ToString();
}
catch (Exception ex)
{
PageUtil.showToast(this, "请重新登录！");
return;
}
Reinspect_parameterDC reinspectdc = new Reinspect_parameterDC();
if (!reinspectdc.checkItem_name(item_name))
{
PageUtil.showToast(this, "该料号未设置复验周期，无法复验！");
return;
}
DateTime check_time = new DateTime();
check_time = DateTime.Now;
int item_id, frame_key;
DataSet list;
PnDC pn = new PnDC();
PoDC DC = new PoDC();
try
{
item_id = DC.getItem_idByItem_name(item_name);
frame_key = DC.getFrame_keyByFrame_name(frame_name);
}
catch
{
PageUtil.showToast(this, "输入格式错误！");
return;
}
//判断库存明细表中是否存在该料号、库别和料架
DataSet table = DC.getItems_onhand_qty_detailByITEM_NAMEandSubinventoryandFrame_key(item_name, datecode, frame_key);
if (table != null && table.Tables[0].Rows.Count > 0)
{
temp_flag = reinspect.getLineNumByPoHeaderId(item_id, datecode, frame_key)[0].ToString();
//如果复验状态是PASS,则需要复验
if ((temp_flag.Equals("PENDING")))
{
int unique_id = reinspect.getSome(item_name, datecode, frame_name, status);
//判断是否存在
if (unique_id == -1)
{
//不存在，新增一条数据
flag = reinspect.insertReinspectHeader(item_name, datecode, frame_name, status, remark, check_user, check_time);
PageUtil.showToast(this, "该料号未复验过，复验成功！");
}
else
{
//已存在，更新数据
flag = reinspect.updateReinspectHeader(unique_id, status, remark, check_user, check_time);
PageUtil.showToast(this, "该料号已复验过，更新成功！");
}
if (flag)
{
Material_ioDC iodc = new Material_ioDC();
if (iodc.updateStatus(item_name, datecode, frame_name, status, check_time))
{
pending(sender, e);
PageUtil.showToast(this, "库存信息更新成功！");
}
else
{
PageUtil.showToast(this, "库存信息更新失败！");
}
}
else
{
PageUtil.showToast(this, "操作失败！");
}
}
else
{
PageUtil.showToast(this, "该料不需要复验！");
}
}
else
{
PageUtil.showToast(this, "没有该条数据！");
return;
}
CleanAllMeassage_Click(sender, e);
}
