protected void GridView2_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView2.PageIndex = e.NewPageIndex;
issueHeaderDC = new IssueHeaderDC();
string SELECT_TEXT = select_text.Value;
List <ModelMtl_issue_header> modelMtl_issue_header = new List <ModelMtl_issue_header>();
modelMtl_issue_header = issueHeaderDC.getIssueHeaderByLikeINVOICE_NO(SELECT_TEXT);
GridView2.DataSource = modelMtl_issue_header;
GridView2.DataBind();
}
//领料单页面对应的Debit（扣账）操作
//public Boolean DebitAction(DataTable dataTable,string warehouse)
//{
// //对dataTable中的每行数据进行操作
// foreach (DataRow datarow in dataTable.Rows)
// {
// IssueHeaderDC issueHeaderDC = new IssueHeaderDC();
// Boolean flag = false;
// //领料单页面对应的Debit扣账）操作.此处ssued_sub_key 库别K值默认为下标为7
// flag = issueHeaderDC.DebitAction(datarow["ITEM_NAME"].ToString(), int.Parse(datarow["ISSUED_QTY"].ToString()), datarow["FRAME_KEY"].ToString(),warehouse);
// //操作失败时，则返回false
// if (flag == false)
// return false;
// }
// return true;
//}
// 传入DataRow,将其转换为ModelMtl_issue_header
private ModelMtl_issue_header toModel(DataRow dr)
{
ModelMtl_issue_header model = new ModelMtl_issue_header();
//通过循环为ModelMtl_issue_header赋值，其中为数据值为空时，DateTime类型的空值为：0001/1/1 0:00:00 int类型得空值为： 0，其余的还没试验
foreach (PropertyInfo propertyInfo in typeof(ModelMtl_issue_header).GetProperties())
{
//如果数据库的字段为空，跳过其赋值
if (dr[propertyInfo.Name].ToString() == "")
{
continue;
}
//赋值
model.GetType().GetProperty(propertyInfo.Name).SetValue(model, dr[propertyInfo.Name], null);
}
return(model);
}
//模糊查询领料单号
protected void select(object sender, EventArgs e)
{
issueHeaderDC = new IssueHeaderDC();
string SELECT_TEXT = select_text.Value;
List <ModelMtl_issue_header> modelMtl_issue_header = new List <ModelMtl_issue_header>();
try
{
modelMtl_issue_header = issueHeaderDC.getIssueHeaderByLikeINVOICE_NO(SELECT_TEXT);
}
catch (Exception)
{
PageUtil.showToast(this, "查询失败！");
return;
}
GridView2.DataSource = modelMtl_issue_header;
GridView2.DataBind();
}
//插入领料单--只是生成领料单号
protected void insert(object sender, EventArgs e)
{
string strInvoice_no = invoice_no.Value;
if (!string.IsNullOrWhiteSpace(strInvoice_no))
{
PageUtil.showToast(this, "当前领料单信息未提交！");
return;
}
issueHeaderDC = new IssueHeaderDC();
int end;
string end_text;
string month = string.Empty;
string year = string.Empty;
modelMtl_issue_header = issueHeaderDC.getTheNewestIssueHeaderByCreatetime();
//判断数据库是否有数据,没有数据则初始化一个流水号
if (modelMtl_issue_header == null)
{
end_text = "00001";
month = DateTime.Now.Month.ToString();
year = DateTime.Now.Year.ToString();
//为月份补0
for (int i = month.Length; i < 2; i++)
{
month = "0" + month;
}
//截取年份后两位
year = year.Substring(2, 2);
}
else
{
end = modelMtl_issue_header.Issue_header_id;
//判断id是否为99998,是则取下一个流水号为99999,否则取余+1作为下一个流水号
end = end % 99998 == 0 ? 99998 + 1 : end % 99999 + 1;
end_text = end.ToString();
//为流水号补0
for (int i = end_text.Length; i < 5; i++)
{
end_text = "0" + end_text;
}
month = DateTime.Now.Month.ToString();
year = DateTime.Now.Year.ToString();
year = year.Substring(2, 2);
for (int i = month.Length; i < 2; i++)
{
month = "0" + month;
}
}
invoice_no.Value = "Q" + year + month + end_text;
}
//提交领料单主表信息 ,并写入数据库.
protected void Issue_Header_Commit(object sender, EventArgs e)
{
issueHeaderDC = new IssueHeaderDC();
string INVOICE_NO = invoice_no.Value; //领料单号
/*避免重复提交*/
try
{
ModelMtl_issue_header header = header = issueHeaderDC.getTheNewestIssueHeaderByCreatetime();
if (header.Invoice_no == INVOICE_NO)
{
PageUtil.showToast(this, "请勿重复提交！");
return;
}
}
catch (Exception)
{
Boolean flag = false;
}
string WO_NO = Request.Form["wo_no_c"]; //工单号
string ISSUED_SUB_KEY = Request["issued_sub_key_c"]; //库别
string OPERATION_SEQ_NUM = Request.Form["operation_seq_num_c"]; //制程
string ISSUE_TYPE = issue_type.SelectedValue; //领料类别
string ISSUE_MAN = issue_man.Value; //领料人
string CUSTOMER_KEY = customer_key.Value; //客户代码
if (ISSUE_MAN.Length > 10)
{
PageUtil.showToast(this, "领料人长度超出范围！");
return;
}
if (CUSTOMER_KEY.Length > 10)
{
PageUtil.showToast(this, "客户代码长度超出范围！");
return;
}
DateTime CREATE_TIME = DateTime.Now;
DateTime UPDATE_TIME = DateTime.Now;
if (string.IsNullOrWhiteSpace(ISSUE_MAN) || string.IsNullOrWhiteSpace(CUSTOMER_KEY))
{
string error = "请填写完整信息!";
PageUtil.showToast(this, error);
return;
}
try
{
issueHeaderDC.insertIssueHeader(INVOICE_NO, WO_NO, ISSUED_SUB_KEY, CREATE_TIME, UPDATE_TIME, OPERATION_SEQ_NUM, ISSUE_TYPE, ISSUE_MAN, CUSTOMER_KEY);
PageUtil.showToast(this, "插入信息成功！");
}
catch (Exception)
{
PageUtil.showToast(this, "插入信息失败！");
return;
}
if (ISSUE_TYPE == "工单领料")
{
string target_qty = issueHeaderDC.getTarget(WO_NO);
required_qty.Value = target_qty;
}
}
