public void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(this.txtBillCode.Text))
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
StorageIn SI = new StorageIn();
StorageIn scode = db.StorageIn.SingleOrDefault(u => u.StorageInCode == this.txtBillCode.Text.Trim());
if (scode != null)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('单据编码重复！')</script>");
return;
}
SI.StorageInCode = this.txtBillCode.Text.Trim();
SI.Remark = this.txtRemark.Text.Trim();
//var SevTime = db.ExecuteQuery<DateTime>("select getdate()", new object[] { });
SI.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
SI.CreateTime = this.DateTimeStorageIn.SelectedDate;
db.StorageIn.InsertOnSubmit(SI);
db.SubmitChanges();
Response.Redirect("StorageInManage.aspx");
}
}
}
catch (Exception ex)
{
MethodBase mb = MethodBase.GetCurrentMethod();
LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name));
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_INSERTERROR));
}
}
private void LoadData()
{
//单据ID
int mainID = 0;
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
int id = Convert.ToInt32(Request.QueryString["StorageDetailedID"]);
StorageInDetailed SID = db.StorageInDetailed.SingleOrDefault(a => a.StorageDetailedID == id);
if (SID != null)
{
//单据id
mainID = SID.StorageInID;
StorageIn SI = db.StorageIn.SingleOrDefault(u => u.StorageInID == mainID);
this.txtStorageinNum.Text = SI.StorageInCode;
this.txtMaterialCode.Text = SID.MaterialInfo.MaterialCode;
this.txtMaterialMod.Text = SID.SpecificationModel;
this.txtMaterialQuantity.Text = SID.Quantity.ToString();
this.txtGTJ.Text = SID.QuantityGentaojian.ToString();
this.txtMetre.Text = SID.QuantityMetre.ToString();
this.txtTon.Text = SID.QuantityTon.ToString();
this.ddlUnit.SelectedIndex = reIndex(SID.CurUnit.ToString());
this.txtMaterialUnitPrice.Text = SID.UnitPrice.ToString();
this.txtMaterialAmount.Text = SID.Amount.ToString();
this.ddlStorage.SelectedValue = SID.PileInfo.StorageID.ToString();
this.ddlPile.SelectedValue = SID.PileInfo.PileID.ToString();
this.txtMaterialfinance.Text = SID.financeCode.ToString();
this.DateTimeStorageIn.SelectedDate = SID.StorageTime;
this.ddlSupplier.SelectedValue = SID.SupplierInfo.SupplierID.ToString();
this.txtManager.Text = db.EmpInfo.SingleOrDefault(u => u.EmpID == SID.MaterialsManager).Account;
this.txtWarehouseWorker.Text = db.EmpInfo.SingleOrDefault(u => u.EmpID == SID.WarehouseWorker).Account;
this.ddlbatch.SelectedValue = SID.BatchIndex.Trim();
this.txtRemark.Text = SID.Remark.ToString();
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('记录不存在! ');</script>");
Response.Redirect("StorageInDetailedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "");
}
}
}
void btnOK_Click(object sender, EventArgs e)
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
if (chbAgree.Checked == true)
{
Response.Redirect("QualityControlMessage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&QCBatch=" + Request.QueryString["QCBatch"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&state=材料会计审核&&storageInType=正常入库");
}
else
{
//任务信息
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(_taskID));
tsi.TaskState = "已完成";
StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == tsi.StorageInID);
//发送新任务(回退任务)
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
TSI.TaskTargetID = tsi.TaskCreaterID;
if (TSI.TaskTargetID == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户，请同步AD账户 ')</script>");
return;
}
TSI.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
TSI.StorageInType = "正常入库";
TSI.TaskTitle = "质检任务：" + tsi.TaskTitle.ToString() + "(质检未通过)";
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "质检前清单";
TSI.InspectState = "驳回";
//TSI.BatchOfIndex = this.ddlbatch.SelectedItem.Text.ToString();
TSI.QCBatch = tsi.QCBatch;
TSI.Remark = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资质检不合格原因：" + this.txtOpinion.Text.Trim();
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = SevTime.First();
db.TaskStorageIn.InsertOnSubmit(TSI);
db.SubmitChanges();
Response.Redirect("../../default-old.aspx", false);
}
}
}
public void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(this.txtBillCode.Text))
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
int id = Convert.ToInt32(Request.QueryString["StorageInID"]);
StorageIn SI = db.StorageIn.SingleOrDefault(a => a.StorageInID == id);
//单据编号唯一
StorageIn scode = db.StorageIn.SingleOrDefault(u => u.StorageInCode == this.txtBillCode.Text.Trim());
if (scode == null)
{
SI.StorageInCode = this.txtBillCode.Text.Trim();
}
else
{
if (SI.StorageInID == scode.StorageInID)
{
SI.StorageInCode = this.txtBillCode.Text.Trim();
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('单据号重复！')</script>");
return;
}
}
SI.StorageInCode = this.txtBillCode.Text.Trim();
SI.Remark = this.txtRemark.Text.Trim();
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
SI.CreateTime = SevTime.First();
db.SubmitChanges();
Response.Redirect("StorageInManage.aspx");
}
}
}
catch (Exception ex)
{
MethodBase mb = MethodBase.GetCurrentMethod();
LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name));
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_UPDATEERROR));
}
}
private void BindDefaultDate()
{
int id = 0;
if (!string.IsNullOrEmpty(Request.QueryString["StorageInID"]))
{
id = Convert.ToInt32(Request.QueryString["StorageInID"]);
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
StorageIn temp = db.StorageIn.SingleOrDefault(u => u.StorageInID == id);
this.txtStorageinNum.Text = temp.StorageInCode.ToString();
this.txtStorageinNum.Enabled = false;
}
}
else
{
Response.Redirect("StorageInManage.aspx");
}
}
private void LoadData()
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
int id = Convert.ToInt32(Request.QueryString["StorageInID"]);
StorageIn SI = db.StorageIn.SingleOrDefault(a => a.StorageInID == id);
if (SI != null)
{
this.txtBillCode.Text = SI.StorageInCode.ToString();
this.DateTimeStorageIn.SelectedDate = SI.CreateTime;
this.txtRemark.Text = SI.Remark.ToString();
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('记录不存在! ');</script>");
Response.Redirect("StorageInManage.aspx");
}
}
}
void btnOK_Click(object sender, EventArgs e)
{
//修改审核状态为初始值
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//旧任务
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
tsi.TaskState = "已完成";
StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == tsi.StorageInID);
//新任务
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
TSI.TaskTargetID = tsi.TaskCreaterID;
if (TSI.TaskTargetID == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户，请同步AD账户 ')</script>");
return;
}
TSI.StorageInID = _storageInID;
TSI.StorageInType = "正常入库";
TSI.TaskTitle = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资已修改，请重新质检";
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "质检";
TSI.InspectState = "未审核";
TSI.QCBatch = tsi.QCBatch;
TSI.Remark = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资已修改";
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = SevTime.First();
db.TaskStorageIn.InsertOnSubmit(TSI);
db.SubmitChanges();
Response.Redirect("../../default-old.aspx", false);
}
}
private void BindGridView()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化TaskStoreIn信息
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(t => t.TaskStorageID == _taskstorageid);
if (tsi == null)
{
Response.Redirect(_errorpage);
return;
}
((Label)GetControltByMaster("labTaskCreater")).Text = tsi.EmpInfo.EmpName + "[" + tsi.EmpInfo.Account + "]";
((Label)GetControltByMaster("labCreateTime")).Text = tsi.CreateTime.ToString();
((Label)GetControltByMaster("labTaskTitle")).Text = tsi.TaskTitle;
((Label)GetControltByMaster("labRemark")).Text = tsi.Remark;
//初始化StoreInQualified信息
StorageIn siq = db.StorageIn.SingleOrDefault(s => s.StorageInID == _storageinid);
if (siq == null)
{
Response.Redirect(_errorpage);
return;
}
this.spgviewAuditControl.DataSource = from a in db.StorageInQualified
join b in db.StorageIn on a.StorageInID equals b.StorageInID
join c in db.MaterialInfo on a.MaterialID equals c.MaterialID
join d in db.PileInfo on a.PileID equals d.PileID
join e in db.SupplierInfo on a.SupplierID equals e.SupplierID
where a.StorageInID == this._storageinid && a.BatchIndex == _batchname
select new
{
a.StorageInQualifiedID,
b.StorageInQualifiedNum,
b.StorageInCode,
c.MaterialName,
c.MaterialCode,
c.MaterialID,
a.SpecificationModel,
a.Quantity,
a.QuantityGentaojian,
a.QuantityMetre,
a.QuantityTon,
a.CurUnit,
a.InspectionTime,
a.InspectionReportNum,
a.UnitPrice,
a.Amount,
d.StorageInfo.StorageName,
d.PileCode,
a.financeCode,
a.StorageTime,
a.BatchIndex,
e.SupplierName,
MaterialsManager = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.MaterialsManager).EmpName,
WarehouseWorker = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.WarehouseWorker).EmpName,
a.Remark,
e.SupplierID,
MaterialsManagerID = a.MaterialsManager,
WarehouseWorkerID = a.WarehouseWorker,
};
this.spgviewAuditControl.DataBind();
this.spgviewAuditControl.Columns[this.spgviewAuditControl.Columns.Count - 1].Visible = false;
this.spgviewAuditControl.Columns[this.spgviewAuditControl.Columns.Count - 2].Visible = false;
this.spgviewAuditControl.Columns[this.spgviewAuditControl.Columns.Count - 3].Visible = false;
}
}
public void btnSave_Click(object sender, EventArgs e)
{
try
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//判断所选质检批次是否在待质检表中
var tmp = from a in db.StorageInDetailed
where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.BatchIndex == batchStr
select new { a.StorageDetailedID };
if (tmp.ToArray().Length == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('无此待质检批次,请重新选择 ')</script>");
return;
}
//判断任务列表中是否已发过此条任务
var task = from a in db.TaskStorageIn
where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.QCBatch == batchStr && a.TaskType == currentFlow
select new { a.TaskCreaterID, a.InspectState };
if (task.ToArray().Length != 0)
{
//如果是驳回的信息允许再次发送
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不能重复发送相同任务 ')</script>");
return;
}
//修改完成状态
if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"]))
{
TaskStorageIn ts = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
if (ts != null)
{
ts.TaskState = "已完成";
}
}
//生成质检完成流水号
if (Request.QueryString["state"].ToString() == "材料会计审核")
{
StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]));
si.StorageInQualifiedNum = this.txtMessageCode.Text.Trim();
}
//发送新任务
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(this.lblCreator.Text.Trim());
TSI.TaskTargetID = reEmpId(this.txtRecipient.Text.Trim());
if (TSI.TaskTargetID == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户，请同步AD账户 ')</script>");
return;
}
TSI.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
TSI.StorageInType = "正常入库";
TSI.TaskTitle = this.txtTaskTitle.Text.Trim();
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = Request.QueryString["state"].ToString();
TSI.InspectState = "未审核";
//TSI.BatchOfIndex = this.ddlbatch.SelectedItem.Text.ToString();
TSI.QCBatch = batchStr;
TSI.Remark = this.txtRemark.Text.Trim();
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = SevTime.First();
db.TaskStorageIn.InsertOnSubmit(TSI);
db.SubmitChanges();
Response.Redirect("../../default-old.aspx", false);
}
}
catch (Exception ex)
{
MethodBase mb = MethodBase.GetCurrentMethod();
LogToDBHelper lhelper = LogToDBHelper.Instance;
lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name));
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_INSERTERROR));
}
}
/// <summary>
/// 发回重新质检
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void btnReCheck_Click(object sender, EventArgs e)
{
try
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//从审核表中删除此批次记录,之前写过库
var siaTemp = from a in db.StorageInAudited
where a.StorageInID == _storageinid && a.BatchIndex == _batchname
select new { a.StorageInAuditedID };
for (int i = 0; i < siaTemp.ToList().Count; i++)
{
StorageInAudited sia = db.StorageInAudited.SingleOrDefault(a => a.StorageInAuditedID == siaTemp.ToList()[i].StorageInAuditedID);
if (sia != null)
{
db.StorageInAudited.DeleteOnSubmit(sia);
}
}
db.SubmitChanges();
//任务信息
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskstorageid);
tsi.TaskState = "已完成";
tsi.InspectState = "已审核";
StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == tsi.StorageInID);
//发送新任务(回退任务)
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
TSI.TaskTargetID = tsi.TaskCreaterID;
if (TSI.TaskTargetID == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户，请同步AD账户 ')</script>");
return;
}
TSI.StorageInID = _storageinid;
TSI.StorageInType = "正常入库";
TSI.TaskTitle = "材料会计审核任务：" + tsi.TaskTitle.ToString() + "(未通过)";
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "质检";
TSI.InspectState = "驳回";
//TSI.BatchOfIndex = this.ddlbatch.SelectedItem.Text.ToString();
TSI.QCBatch = tsi.QCBatch;
TSI.Remark = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资审核不合格原因：" + this.txtOpinion.Text.Trim();
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = SevTime.First();
db.TaskStorageIn.InsertOnSubmit(TSI);
db.SubmitChanges();
Response.Redirect("../../default-old.aspx", false);
}
}
catch (Exception ex)
{
MethodBase mb = MethodBase.GetCurrentMethod();
LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name));
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_INSERTERROR));
}
}
public void btnSave_Click(object sender, EventArgs e)
{
try
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//用户IE回退操作检验
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.StorageInID == _storageinid && u.QCBatch == _batchname && u.TaskType == "主任审核" && u.InspectState == "未审核");
if (tsi != null)
{
Response.Redirect("../../default-old.aspx", false);
return;
}
//修改完成状态
if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"]))
{
TaskStorageIn ts = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskstorageid);
ts.TaskState = "已完成";
ts.InspectState = "已审核";
}
//审核完在主表StorageIn中填入入库类型
StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == _storageinid);
si.ReceivingType = Convert.ToInt32(ddlReceivingType.SelectedValue);
int iDirector = reEmpId(txtDirector.Text.Trim());
if (iDirector == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户，请同步AD账户 ')</script>");
return;
}
//在StorageInAudited表中填入审批主任
var Auditeds = from a in db.StorageInAudited
where a.StorageInID == _storageinid
select a;
foreach (StorageInAudited audited in Auditeds)
{
audited.Director = iDirector;
}
//检查当前登录用户是否有代理任务
oldDor = iDirector;
iDirector = Proxy.send(iDirector, 1);
//发送新任务
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(((Label)this.GetControltByMaster("lblCreator")).Text.Trim());
TSI.TaskTargetID = iDirector;
TSI.StorageInID = _storageinid;
TSI.StorageInType = "正常入库";
TSI.TaskTitle = ((TextBox)this.GetControltByMaster("txtTaskTitle")).Text.Trim();
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "主任审核";
//ProxyDirector pd = new ProxyDirector();
//TaskProxy TP = db.TaskProxy.SingleOrDefault(u => u.TaskProxyType.TaskProxyTypeName == "正常入库" && u.ProxyPrincipal == TSI.TaskTargetID);
//if (TSI.TaskType == "主任审核")
//{
// if (TP != null)
// {
// pd.TaskProxy.ProxyPrincipal = TP.ProxyPrincipal;
// pd.TaskID = TSI.TaskStorageID;
// pd.TaskProxyID = TP.TaskProxyID;
// pd.TaskProxy.ProxyFiduciary = TP.ProxyFiduciary;
// TSI.TaskTargetID = TP.ProxyFiduciary;
// TSI.TaskTitle = TP.EmpInfo.EmpName + "主任委托入库审批任务：" + TSI.TaskTitle;
// db.ProxyDirector.InsertOnSubmit(pd);
// }
//}
TSI.InspectState = "未审核";
TSI.Remark = ((TextBox)this.GetControltByMaster("txtRemark")).Text.Trim();
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = SevTime.First();
TSI.QCBatch = _batchname;
db.TaskStorageIn.InsertOnSubmit(TSI);
db.SubmitChanges();
//保存代理任务信息
Proxy.saveTask(TSI.TaskStorageID, Proxy.getProxyTaskId(oldDor, 1));
Response.Redirect("../../default-old.aspx", false);
//pd.TaskID = TSI.TaskStorageID;
//db.SubmitChanges();
}
}
catch (Exception ex)
{
MethodBase mb = MethodBase.GetCurrentMethod();
LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name));
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_INSERTERROR));
}
}
/// <summary>
/// 绑定Gridview
/// </summary>
private void BindGridView()
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
string strTaskID = this.Request.QueryString["TaskStorageID"];
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(a => a.TaskStorageID == int.Parse(strTaskID));
if (tsi == null)
{
Response.Redirect(strUrl);
}
Label labTaskCreater = (Label)GetControltByMaster("labTaskCreater");
labTaskCreater.Text = tsi.EmpInfo.EmpName + "[" + tsi.EmpInfo.Account + "]";
((Label)GetControltByMaster("labCreateTime")).Text = tsi.CreateTime.ToString();
((Label)GetControltByMaster("labTaskTitle")).Text = tsi.TaskTitle;
((Label)GetControltByMaster("labRemark")).Text = tsi.Remark;
string strID = this.Request.QueryString["StorageInID"];
StorageIn si = db.StorageIn.SingleOrDefault(a => a.StorageInID == int.Parse(strID));
if (si == null)
{
Response.Redirect(strUrl);
}
BoundField bf = new BoundField();
BoundField bfColumn;
TemplateField GentaojianTextBox = new TemplateField();
GentaojianTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtGentaojian");
GentaojianTextBox.HeaderTemplate = new MulTextBoxTemplate("根/套/件", DataControlRowType.Header);
GentaojianTextBox.ItemStyle.Width = 150;
TemplateField MetreTextBox = new TemplateField();
MetreTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtMetre");
MetreTextBox.HeaderTemplate = new MulTextBoxTemplate("米", DataControlRowType.Header);
MetreTextBox.ItemStyle.Width = 150;
TemplateField TonTextBox = new TemplateField();
TonTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtTon");
TonTextBox.HeaderTemplate = new MulTextBoxTemplate("吨", DataControlRowType.Header);
TonTextBox.ItemStyle.Width = 150;
//TemplateField tfieldTextBox = new TemplateField();
//tfieldTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtCount");
//tfieldTextBox.HeaderTemplate = new MulTextBoxTemplate("合格数量", DataControlRowType.Header);
//tfieldTextBox.ItemStyle.Width = 150;
TemplateField reportTextBox = new TemplateField();
reportTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtQualityNum");
reportTextBox.HeaderTemplate = new MulTextBoxTemplate("质检报告号", DataControlRowType.Header);
reportTextBox.ItemStyle.Width = 150;
foreach (var kvp in Tlist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgviewQualityControl.Columns.Add(bfColumn);
}
this.spgviewQualityControl.Columns.Insert(10, GentaojianTextBox);
this.spgviewQualityControl.Columns.Insert(11, MetreTextBox);
this.spgviewQualityControl.Columns.Insert(12, TonTextBox);
//this.spgviewQualityControl.Columns.Insert(13, tfieldTextBox);
this.spgviewQualityControl.Columns.Insert(13, reportTextBox);
this.spgviewQualityControl.DataSource = from a in db.StorageInDetailed
join b in db.StorageIn on a.StorageInID equals b.StorageInID
join c in db.MaterialInfo on a.MaterialID equals c.MaterialID
join d in db.PileInfo on a.PileID equals d.PileID
join e in db.SupplierInfo on a.SupplierID equals e.SupplierID
where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.BatchIndex == batchidx
select new
{
a.StorageDetailedID,
b.StorageInCode,
a.SpecificationModel,
a.BatchIndex,
c.MaterialName,
c.MaterialCode,
c.MaterialID,
a.Quantity,
a.UnitPrice,
a.Amount,
d.StorageInfo.StorageName,
d.PileCode,
a.financeCode,
a.StorageTime,
e.SupplierName,
a.QuantityGentaojian,
a.QuantityMetre,
a.QuantityTon,
a.CurUnit,
MaterialsManager = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.MaterialsManager).EmpName,
WarehouseWorker = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.WarehouseWorker).EmpName,
a.Remark,
e.SupplierID
};
this.spgviewQualityControl.DataBind();
this.spgviewQualityControl.Columns[0].Visible = false;
this.spgviewQualityControl.Columns[this.spgviewQualityControl.Columns.Count - 1].Visible = false;
p1 = (Panel)GetControltByMaster("Panel1");
p1.Controls.Add(this.spgviewQualityControl);
}
}
catch (Exception ex)
{
MethodBase mb = MethodBase.GetCurrentMethod();
LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name));
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_QUERYERROR));
}
}
void btnEdit_Click(object sender, EventArgs e)
{
try
{
//检查输入格式
if (CheckStringEmpty() != true)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请将数据填写完整,且合格数量只能是数字 ')</script>");
return;
}
//检查输入数据是否溢出
if (CheckOverFlow() != true)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('合格数量不能超过质检前数量! ')</script>");
return;
}
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
var task = from a in db.TaskStorageIn
where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.QCBatch == batchidx && a.TaskType == "质检" && a.InspectState == "驳回" && a.TaskState == "未完成"
select new { a.TaskCreaterID, a.InspectState };
//如果是回退到质检的调拨单
if (task.ToList().Count > 0)
{
//更新
var tep = from a in db.StorageInQualified
where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"].ToString()) && a.BatchIndex == batchidx
orderby a.StorageInQualifiedID ascending
select new { a.StorageInQualifiedID };
var li = tep.ToList();
for (int i = 0; i < this.spgviewQualityControl.Rows.Count; i++)
{
StorageInQualified SIQ = new StorageInQualified();
SIQ = db.StorageInQualified.SingleOrDefault(u => u.StorageInQualifiedID == li[i].StorageInQualifiedID);
TextBox gentaojian = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[10].Controls[0]);
SIQ.QuantityGentaojian = Convert.ToDecimal(gentaojian.Text.Trim());
TextBox metre = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[11].Controls[0]);
SIQ.QuantityMetre = Convert.ToDecimal(metre.Text.Trim());
TextBox ton = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[12].Controls[0]);
SIQ.QuantityTon = Convert.ToDecimal(ton.Text.Trim());
TextBox ti = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[13].Controls[0]);
SIQ.InspectionReportNum = ti.Text.Trim();
db.SubmitChanges();
//DataTable dt = new DataTable();
//dt.Columns.Add("UserID", typeof(int));
//dt.Columns.Add("userName", typeof(string));
//dt.Columns.Add("Gender", typeof(bool));
//var temp = from u in dt.AsEnumerable()
// where u.Field<bool>("Gender") == true
// select u;
}
//旧任务
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
tsi.TaskState = "已完成";
tsi.InspectState = "已审核";
StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == tsi.StorageInID);
//新任务
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
TSI.TaskTargetID = tsi.TaskCreaterID;
if (TSI.TaskTargetID == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户，请同步AD账户 ')</script>");
return;
}
TSI.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
TSI.StorageInType = "正常入库";
TSI.TaskTitle = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资已质检，请重新审核";
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "材料会计审核";
TSI.InspectState = "未审核";
TSI.QCBatch = tsi.QCBatch;
TSI.Remark = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资已重新质检";
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = SevTime.First();
db.TaskStorageIn.InsertOnSubmit(TSI);
db.SubmitChanges();
Response.Redirect("../../default-old.aspx", false);
}
else
{
//更新数据
var tep = from a in db.StorageInQualified
where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"].ToString()) && a.BatchIndex == batchidx
orderby a.StorageInQualifiedID ascending
select new { a.StorageInQualifiedID };
var li = tep.ToList();
for (int i = 0; i < this.spgviewQualityControl.Rows.Count; i++)
{
StorageInQualified SIQ = new StorageInQualified();
SIQ = db.StorageInQualified.SingleOrDefault(u => u.StorageInQualifiedID == li[i].StorageInQualifiedID);
TextBox gentaojian = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[10].Controls[0]);
SIQ.QuantityGentaojian = Convert.ToDecimal(gentaojian.Text.Trim());
TextBox metre = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[11].Controls[0]);
SIQ.QuantityMetre = Convert.ToDecimal(metre.Text.Trim());
TextBox ton = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[12].Controls[0]);
SIQ.QuantityTon = Convert.ToDecimal(ton.Text.Trim());
TextBox ti = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[13].Controls[0]);
SIQ.InspectionReportNum = ti.Text.Trim();
db.SubmitChanges();
}
Response.Redirect("QualifiedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&QCBatch=" + batchidx + " ");
}
}
}
catch (Exception ex)
{
MethodBase mb = MethodBase.GetCurrentMethod();
LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name));
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_UPDATEERROR));
}
}
void btnSend_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
var tp = from a in db.StorageInDirector
where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.BatchIndex == Request.QueryString["QCBatch"].ToString()
select a;
if (tp.ToArray().Length > 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不能重复插入记录!')</script>");
return;
}
}
if (chbAgree.Checked == true)
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
for (int i = 0; i < this.gv.Rows.Count; i++)
{
//写入流程中的主任审核表
StorageInDirector sid = new StorageInDirector();
sid.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
MaterialInfo mi = db.MaterialInfo.SingleOrDefault(u => u.MaterialID == Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 2].Text.ToString()));
sid.MaterialID = mi.MaterialID;
sid.SpecificationModel = this.gv.Rows[i].Cells[3].Text.ToString();
sid.BatchIndex = this.gv.Rows[i].Cells[20].Text.ToString();
sid.QuantityGentaojian = Convert.ToDecimal(this.gv.Rows[i].Cells[4].Text.ToString());
sid.QuantityMetre = Convert.ToDecimal(this.gv.Rows[i].Cells[5].Text.ToString());
sid.QuantityTon = Convert.ToDecimal(this.gv.Rows[i].Cells[6].Text.ToString());
sid.Quantity = Convert.ToDecimal(this.gv.Rows[i].Cells[7].Text.ToString());
sid.CurUnit = this.gv.Rows[i].Cells[8].Text.ToString();
sid.NumberQualified = 0;
sid.InspectionReportNum = this.gv.Rows[i].Cells[11].Text.ToString();
sid.InspectionTime = Convert.ToDateTime(this.gv.Rows[i].Cells[12].Text.ToString());
sid.UnitPrice = Convert.ToDecimal(this.gv.Rows[i].Cells[9].Text.ToString());
sid.Amount = Convert.ToDecimal(this.gv.Rows[i].Cells[10].Text.ToString());
PileInfo pi = db.PileInfo.SingleOrDefault(u => u.PileCode == this.gv.Rows[i].Cells[14].Text.ToString());
sid.PileID = pi.PileID;
sid.financeCode = this.gv.Rows[i].Cells[15].Text.ToString();
sid.StorageTime = Convert.ToDateTime(this.gv.Rows[i].Cells[16].Text.ToString());
//这里不唯一要出问题。
sid.SupplierID = Convert.ToInt32(this.gv.Rows[i].Cells[25].Text.ToString());
var temp = from a in db.StorageInAudited
where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.BatchIndex == Request.QueryString["QCBatch"].ToString()
select new { a.MaterialsManager, a.WarehouseWorker, a.MaterialAccounting };
var list = temp.ToList();
sid.MaterialsManager = list[i].MaterialsManager;
sid.WarehouseWorker = list[i].WarehouseWorker;
sid.MaterialAccounting = list[i].MaterialAccounting;
sid.AuditStatus = this.gv.Rows[i].Cells[21].Text.ToString();
sid.AuditTime = Convert.ToDateTime(this.gv.Rows[i].Cells[22].Text.ToString());
sid.DirectorStatus = "已审批";
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
sid.DirectorTime = SevTime.First();
sid.Remark = this.gv.Rows[i].Cells[24].Text.ToString();
sid.BatchIndex = this.gv.Rows[i].Cells[23].Text.ToString();
sid.Director = reEmpId(SPContext.Current.Web.CurrentUser.LoginName.ToString());
db.StorageInDirector.InsertOnSubmit(sid);
//写入库存表
TableOfStocks tos = new TableOfStocks();
tos.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
tos.StorageInType = "正常入库";
tos.MaterialID = mi.MaterialID;
tos.SpecificationModel = this.gv.Rows[i].Cells[3].Text.ToString();
tos.QuantityGentaojian = Convert.ToDecimal(this.gv.Rows[i].Cells[4].Text.ToString());
tos.QuantityMetre = Convert.ToDecimal(this.gv.Rows[i].Cells[5].Text.ToString());
tos.QuantityTon = Convert.ToDecimal(this.gv.Rows[i].Cells[6].Text.ToString());
tos.Quantity = Convert.ToDecimal(this.gv.Rows[i].Cells[7].Text.ToString());
tos.CurUnit = this.gv.Rows[i].Cells[8].Text.ToString();
tos.UnitPrice = Convert.ToDecimal(this.gv.Rows[i].Cells[9].Text.ToString());
tos.NumberQualified = 0;
tos.PileID = pi.PileID;
tos.financeCode = sid.financeCode;
tos.StorageTime = sid.StorageTime;
tos.SupplierID = sid.SupplierID;
tos.MaterialsManager = list[i].MaterialsManager;
tos.WarehouseWorker = list[i].WarehouseWorker;
tos.OnlineState = "线下";
sid.Remark = sid.Remark;
db.TableOfStocks.InsertOnSubmit(tos);
db.SubmitChanges();
}
//修改完成状态
if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"]))
{
TaskStorageIn ts = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
if (ts != null)
{
ts.TaskState = "已完成";
ts.InspectState = "已审核";
//修改代理任务完成状态
//ProxyDirector pd = db.ProxyDirector.SingleOrDefault(u => u.TaskID == Convert.ToInt32(Request.QueryString["TaskStorageID"]) && u.TaskProxy.TaskProxyType.TaskProxyTypeName == "正常入库");
//if (pd != null)
//{
// TaskProxy tp = db.TaskProxy.SingleOrDefault(u => u.TaskProxyType.TaskProxyTypeName == "正常入库" && u.ProxyPrincipal == pd.TaskProxy.ProxyPrincipal && u.TaskDispose == "未完成");
// tp.TaskDispose = "完成";
//}
}
db.SubmitChanges();
}
}
Response.Redirect("StorageInDirectorPass.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&QCBatch=" + Request.QueryString["QCBatch"] + " ");
}
else
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//任务信息
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
tsi.TaskState = "已完成";
tsi.InspectState = "已审核";
StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == tsi.StorageInID);
//发送新任务(回退任务)
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
TSI.TaskTargetID = tsi.TaskCreaterID;
if (TSI.TaskTargetID == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户，请同步AD账户 ')</script>");
return;
}
TSI.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
TSI.StorageInType = "正常入库";
TSI.TaskTitle = "主任审批任务：" + tsi.TaskTitle.ToString() + "(未通过)";
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "材料会计审核";
TSI.InspectState = "驳回";
//TSI.BatchOfIndex = this.ddlbatch.SelectedItem.Text.ToString();
TSI.QCBatch = tsi.QCBatch;
TSI.Remark = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资审批不合格原因：" + this.txtOpinion.Text.Trim();
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = SevTime.First();
db.TaskStorageIn.InsertOnSubmit(TSI);
db.SubmitChanges();
}
Response.Redirect("../../default-old.aspx", false);
}
}
catch (Exception ex)
{
MethodBase mb = MethodBase.GetCurrentMethod();
LogToDBHelper lhelper = LogToDBHelper.Instance;
lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name));
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_INSERTERROR));
}
//Response.Redirect("QualityControlMessage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&state=材料会计审核");
}
