protected void Page_Load(object sender, EventArgs e)
{
try
{
this._taskid = Convert.ToInt32(Request.QueryString["TaskID"]);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID.Equals(_taskid));
_formid = tsi.StorageInID;
if (tsi.TaskState.Equals("已完成"))
{
bfinished = true;
}
}
InitializeCustomControls();
BindDataToCustomControls();
ShowCustomControls();
}
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_LOADERROR));
}
}
void btnOK_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//完成当前任务
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid);
if (tsi.TaskState.Equals("未完成"))//分支流程--处理IE回退
{
tsi.TaskState = "已完成";
}
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));
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
_taskstorageid = Convert.ToInt32(Request.QueryString["TaskStorageID"]);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskstorageid);
this._storageinid = tsi.StorageInID;
this._batchname = tsi.QCBatch;
}
init();
BindGridView();
InitButton();
}
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_LOADERROR));
}
}
void tbarbtnsend_Click(object sender, EventArgs e)
{
//发送资产组
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
if (btnko.Enabled == false)
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskID);
Response.Redirect("TaskCenter.aspx?StorageInID=" + _storageInID + "&&state=资产组长&&storageInType=正常入库&&QCBatch=" + _QCbatch + "&&TaskStorageID=" + _taskID + "&&InspectState=" + tsi.InspectState + "");
}
else
{
if (ViewState["Temp"] != null)
{
if (ViewState["Temp"].ToString() == "True")
{
Response.Redirect("TaskCenter.aspx?StorageInID=" + _storageInID + "&&state=资产组长&&storageInType=正常入库&&QCBatch=" + _QCbatch + "&&TaskStorageID=" + _taskID + "");
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请先保存数据后再发送! ')</script>");
return;
}
}
}
}
}
private void ShowCustomControls()
{
Panel p1 = (Panel)GetControltByMaster("Panel1");
p1.Controls.Add(this.spgvMaterial);
//分支流程--回收入库单已经发送资产组长审核的情况
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskType.Equals("回收入库单资产组长确认") && u.PreviousTaskID == _taskid && u.StorageInID == _receiptid);
if (tsi != null)
{
btnOK.Text = "通知保养&检验";
isSendTask = true;
strBackUrl = "../../default-old.aspx";
ltrInfo.Visible = true;
string strAChief = string.Format("<font style=\"font-size:x-small;font-weight:bold;color:red\">{0}</font>", tsi.EmpInfo1.EmpName);
ltrInfo.Text = string.Format("<br/>回收入库单已经提交资产组长{0}确认. . .<br/>", strAChief);
//分支流程--任务完成的情况
if (db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID.Equals(_taskid)).TaskState.Equals("已完成"))
{
btnOK.Visible = false;
}
}
}
}
void btnOK_Click(object sender, EventArgs e)
{
try
{
if (lblResult.Text.Equals("未通过"))
{
Response.Redirect(string.Format("CreateSrinTask.aspx?TaskID={0}&WorkID={1}&TaskType=处理物资组长审核问题&Executor={2}", _taskid, _formid, _executor), false);
}
else
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID.Equals(_taskid));
tsi.TaskState = "已完成";
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_UPDATEERROR));
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
this._taskid = Convert.ToInt32(Request.QueryString["TaskID"]);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
_receiptid = db.SrinReceipt.SingleOrDefault(u => u.TaskID == this.GetPreviousTaskID(0, _taskid)).SrinReceiptID;
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid);
if (tsi.TaskState.Equals("已完成"))//分支流程--任务已经完成的情况
{
bfinished = true;
strBackUrl = "../../default-old.aspx";
}
else
{
strBackUrl = string.Format("RiAChiefReceiptConfirm.aspx?TaskID={0}", _taskid);
}
}
InitializeCustomControls();
BindDataToCustomControls();
ShowCustomControls();
}
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_LOADERROR));
}
}
private void saveState()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskID);
var tp = from a in db.StorageInHead
where a.StorageInAssets.StorageInTest.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.StorageInAssets.StorageInTest.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.BatchIndex == Request.QueryString["QCBatch"].ToString()
select a;
if (tsi.InspectState == "驳回")
{
if (tsi.TaskState != "已完成")
{
btnko.Enabled = true;
checkPass.Enabled = true;
}
if (tp.ToArray().Length > 0)
{
btnko.Enabled = false;
checkPass.Enabled = false;
}
}
else
{
if (tp.ToArray().Length > 0)
{
btnko.Enabled = false;
checkPass.Enabled = false;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string strTaskstorageid = Request.QueryString["TaskStorageID"];
if (string.IsNullOrEmpty(strTaskstorageid))
{
Response.Redirect(_errorpage);
return;
}
else
{
this._taskstorageid = Convert.ToInt32(strTaskstorageid);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskstorageid);
this._storageinid = tsi.StorageInID;
this._taskstate = tsi.TaskState;
}
InitializeCustomControls();
BindGridView();
ShowCustomControls();
ChangeStatusStyle();
}
}
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_LOADERROR));
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
_taskid = Convert.ToInt32(Request.QueryString["TaskID"]);
if (!string.IsNullOrEmpty(Request.QueryString["Receivers"]))//触发发送消息的页面是否传递接收者信息
{
_receivers = HttpUtility.UrlDecode(Request.QueryString["Receivers"]);
}
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid);
_process = tsi.StorageInType;
_step = tsi.TaskType;
strFinishUrl = "../../default-old.aspx";
SetPageConfig();
}
InitializeCustomControls();
ShowCustomControls();
}
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_LOADERROR));
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
_taskid = Convert.ToInt32(Request.QueryString["TaskID"]);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid);
_formid = tsi.StorageInID;
//分支流程--任务已经完成的情况
if (tsi.TaskState.Equals("已完成"))
{
Response.Redirect(string.Format("RiMaterialRepairAuditMessage.aspx?TaskID={0}", _taskid), false);
return;
}
smra = db.SrinMaterialRepairAudit.SingleOrDefault(u => u.TaskID == _taskid);
}
InitializeCustomControls();
BindDataToCustomControls();
ShowCustomControls();
}
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_LOADERROR));
}
}
/// <summary>
/// 初始化
/// </summary>
private void LoadPageinfo()
{
//判断质检单是否存在
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
var tp = from a in db.CommitInQualified
where a.CommitInID == Convert.ToInt32(Request.QueryString["StorageInID"])
select a;
if (tp.ToArray().Length > 0)
{
this.btnOk.Enabled = false;
this.btnEdit.Enabled = true;
//初始化质检合格表
var cg = from u in db.CommitInQualified
where u.CommitInID == Convert.ToInt32(Request.QueryString["StorageInID"])
orderby u.CommitInQualifiedID ascending
select new { u.QuantityGentaojian, u.QuantityMetre, u.QuantityTon, u.InspectionReportNum };
var li = cg.ToList();
for (int i = 0; i < this.spgviewQualityControl.Rows.Count; i++)
{
TextBox gentaojian = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[10].Controls[0]);
gentaojian.Text = li[i].QuantityGentaojian.ToString();
TextBox metre = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[11].Controls[0]);
metre.Text = li[i].QuantityMetre.ToString();
TextBox ton = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[12].Controls[0]);
ton.Text = li[i].QuantityTon.ToString();
TextBox ti = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[13].Controls[0]);
ti.Text = li[i].InspectionReportNum.ToString();
}
}
else
{
this.btnOk.Enabled = true;
this.btnEdit.Enabled = false;
}
}
//修改任务完成状态
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tk = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
if (tk != null)
{
if (tk.TaskState == "已完成")
{
this.btnOk.Enabled = false;
this.btnEdit.Enabled = false;
}
}
}
}
/// <summary>
/// 根据任务状态显示控件状态
/// </summary>
private void taskState()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskID);
if (tsi.TaskState == "已完成")
{
this.btnko.Enabled = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
this.gv = new SPGridView();
this.gv.AutoGenerateColumns = false;
BindGridView();
//添加按钮到toolbar
ToolBar tbarTop = (ToolBar)GetControltByMaster("tbarbusiness");
//返回
ToolBarButton tbarbtnBack = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx");
tbarbtnBack.ID = "backRow";
tbarbtnBack.Text = "返回";
tbarbtnBack.ImageUrl = "/_layouts/images/BACK.GIF";
tbarbtnBack.Click += new EventHandler(tbarbtnBack_Click);
tbarTop.Buttons.Controls.Add(tbarbtnBack);
ToolBarButton btnRefresh = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx");
btnRefresh.ID = "btnRefresh";
btnRefresh.Text = "刷新";
btnRefresh.ImageUrl = "/_layouts/images/refresh.GIF";
btnRefresh.Padding = "0,5,0,0";
btnRefresh.Click += new EventHandler(btnRefresh_Click);
tbarTop.RightButtons.Controls.Add(btnRefresh);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tk = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
if (tk != null)
{
if (tk.TaskState == "已完成")
{
this.btnPass.Enabled = false;
this.chbAgree.Enabled = false;
this.txtOpinion.Enabled = 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_LOADERROR));
}
}
void btnOK_Click(object sender, EventArgs e)
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
if (chbAgree.Checked == true)
{
Response.Redirect("TaskCommitIn.aspx?CommitInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&state=材料会计审核&&storageInType=委外入库");
}
else
{
//任务信息
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(_taskID));
tsi.TaskState = "已完成";
CommitIn si = db.CommitIn.SingleOrDefault(u => u.CommitInID == 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.StorageInType;
TSI.TaskTitle = "质检任务：" + tsi.TaskTitle.ToString() + "(质检未通过)";
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "质检前清单";
TSI.InspectState = "驳回";
TSI.QCBatch = tsi.QCBatch;
TSI.Remark = "交货通知单编号为:" + si.CommitInCode + "的物资质检不合格,原因：" + 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);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
this._taskid = Convert.ToInt32(Request.QueryString["TaskID"]);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid);
//分支流程--任务已经完成的情况
if (tsi.TaskState.Equals("已完成"))
{
Response.Redirect(string.Format("RiAssetStorageDetails.aspx?TaskID={0}", _taskid), false);
return;
}
//分支流程--已经发送确认任务的情况
if (db.TaskStorageIn.Count(u => u.PreviousTaskID.Equals(_taskid) && u.TaskType.Equals("资产组长确认合格物资")) != 0)
{
Response.Redirect(string.Format("RiAssetQualifiedReceiptMessage.aspx?TaskID={0}", _taskid), false);
return;
}
//分支流程--已经生成回收入库单(合格)的情况
if (db.SrinQualifiedReceipt.Count(u => u.TaskID.Equals(_taskid)) != 0)
{
Response.Redirect(string.Format("RiAssetModifyQualifiedReceipt.aspx?TaskID={0}", _taskid), false);
return;
}
_transferid = tsi.StorageInID;
_tasktype = tsi.TaskType;
}
InitializeCustomControls();
BindDataToCustomControls();
ShowCustomControls();
}
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_LOADERROR));
}
}
private void ShowCustomControls()
{
Panel p1 = (Panel)GetControltByMaster("Panel1");
p1.Controls.Add(this.spgvMaterial);
if (lblResult.Text.Equals("清点有误"))
{
btnOK.Text = "通知核实";
}
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskType.Equals("物资组长确认清点结果") && u.StorageInID.Equals(_stocktakingid));
if (tsi != null)//分支流程--已经发送任务的情况
{
strBackUrl = "../../default-old.aspx";
btnOK.Text = "保养&检验";
ltrInfo.Visible = true;
string strMChief = string.Format("<font style=\"font-size:x-small;font-weight:bold;color:red\">{0}</font>", tsi.EmpInfo1.EmpName);
ltrInfo.Text = string.Format("清点结果已经发送物资组长{0}确认. . .<br/><br/>", strMChief);
bSendTask = true;
//分支流程--资产组员已经办理回收的情况
SrinReceipt srp = db.SrinReceipt.SingleOrDefault(u => u.SrinStocktakingConfirm.SrinStocktakingID.Equals(_stocktakingid));
if (srp == null)
{
btnOK.Enabled = false;
ltrInfo.Text = string.Format("清点结果已经发送物资组长{0}确认，请等待资产管理员办理回收入库单. . .<br/><br/>", strMChief);
}
else
{
_receiptid = srp.SrinReceiptID;
}
}
if (db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid).TaskState.Equals("已完成"))
{
btnOK.Visible = false;
ltrInfo.Visible = true;
ltrInfo.Text = "该任务已完成，您正在查看清点信息 . . .";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
this._taskid = Convert.ToInt32(Request.QueryString["TaskID"]);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID.Equals(_taskid));
_reportid = tsi.StorageInID;
SrinRepairReport srrp = db.SrinRepairReport.SingleOrDefault(u => u.SrinRepairReportID.Equals(_reportid));
//已生成质检清单的情况
if (db.SrinInspectorVerifyRDetails.Count(u => u.SrinInspectorVerifyDetails.SrinInspectorVerifyTransferID.Equals(srrp.SrinInspectorVerifyTransferID)) != 0)
{
//质检清单已经处理的情况
int count = db.TaskStorageIn.Count(u => u.StorageInType.Equals("回收入库") && u.TaskType.Equals("资产组处理修复合格物资") && u.StorageInID.Equals(srrp.SrinInspectorVerifyTransferID));
count += db.MessageInfo.Count(u => u.TaskID.Equals(_taskid));
if (count != 0)
{
Response.Redirect(string.Format("RiInspectorVerifyRDetailsMessage.aspx?TaskID={0}", _taskid), false);
}
else
{
Response.Redirect(string.Format("RiInspectorModifyVerifyRDetails.aspx?TaskID={0}", _taskid), false);
}
return;
}
}
InitializeCustomControls();
BindDataToCustomControls();
ShowCustomControls();
}
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_LOADERROR));
}
}
private void TerminateCurTask()
{
using (MMSProDBDataContext dc = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
if (_process.Contains("入库"))
{
TaskStorageIn tsi = dc.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid);
if (tsi.TaskState.Equals("未完成"))
{
tsi.TaskState = "已完成";
}
else
{
Response.Redirect("../../default-old.aspx", false);
return;
}
}
dc.SubmitChanges();
}
}
private void ShowCustomControls()
{
Panel p1 = (Panel)GetControltByMaster("Panel1");
p1.Controls.Add(this.spgvMaterial);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskType.Equals("资产组长确认合格物资") && u.StorageInID.Equals(_receiptid));
if (tsi != null)//分支流程--已经发送任务的情况
{
strBackUrl = "../../default-old.aspx";
btnOK.Text = lblWriteOff.Text.Equals("执行冲销") ? "冲销" : "入库";
ctAsset = lblWriteOff.Text.Equals("执行冲销") ? CommandType.WriteOff : CommandType.Storing;
//获取显示信息
ltrInfo.Visible = true;
string strAChief = string.Format("<font style=\"font-size:x-small;font-weight:bold;color:red\">{0}</font>", tsi.EmpInfo1.EmpName);
SrinAChiefQReceiptConfirm smqc = db.SrinAChiefQReceiptConfirm.SingleOrDefault(u => u.SrinQualifiedReceiptID == _receiptid);
if (smqc != null)//分支流程--资产组长已经确认的情况
{
if (lblWriteOff.Text.Equals("执行冲销"))
{
ltrInfo.Text = string.Format("回收入库单(合格)已经通过资产组长{0}确认，请执行冲销. . .<br/><br/>", strAChief);
}
else
{
ltrInfo.Text = string.Format("回收入库单(合格)已经通过资产组长{0}确认，请执行入库. . .<br/><br/>", strAChief);
}
btnOK.Enabled = true;
}
else
{
ltrInfo.Text = string.Format("回收入库单(合格)已经发送资产组长{0}确认，请等待. . .<br/><br/>", strAChief);
btnOK.Enabled = false;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
this._taskid = Convert.ToInt32(Request.QueryString["TaskID"]);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid);
_confirmid = tsi.StorageInID;
//分支流程--已经创建回收入库单的情况
SrinReceipt srp = db.SrinReceipt.SingleOrDefault(u => u.TaskID == _taskid);
if (srp != null)
{
if (db.TaskStorageIn.Count(u => u.TaskType.Equals("回收入库单资产组长确认") && u.PreviousTaskID == _taskid && u.StorageInID == srp.SrinReceiptID) != 0)//已经提交部门主管确认的情况
{
Response.Redirect(string.Format("RiAssetReceiptMessage.aspx?TaskID={0}", _taskid), false);
}
else//尚未提交部门主管确认的情况
{
Response.Redirect(string.Format("RiAssetModifyReceipt.aspx?TaskID={0}", _taskid), false);
}
return;
}
}
InitializeCustomControls();
BindDataToCustomControls();
ShowCustomControls();
}
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_LOADERROR));
}
}
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 = "已完成";
StorageInMain si = db.StorageInMain.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);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
try
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//判断所选质检批次是否在待质检表中
var tmp = from a in db.StorageProduce
where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.BatchIndex == batchStr
select new { a.StorageInProduceID };
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 && a.StorageInType == storageInType
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() == "材料会计审核")
{
StorageInMain si = db.StorageInMain.SingleOrDefault(u => u.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]));
}
//发送新任务
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 = 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));
}
}
void btnko_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
var tp = from a in db.CommitDirector
where a.CommitInHead.CommitInAssets.CommitInTest.CommitInMaterialsLeader.CommitInMaterials.CommitProduce.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.CommitInHead.CommitInAssets.CommitInTest.CommitInMaterialsLeader.CommitInMaterials.CommitProduce.BatchIndex == Request.QueryString["QCBatch"].ToString()
select a;
if (tp.ToArray().Length > 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不能重复插入记录! ')</script>");
return;
}
if (this.checkPass.Checked)
{
for (int i = 0; i < this.gv.Rows.Count; i++)
{
CommitDirector sih = new CommitDirector();
sih.HeadID = Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 1].Text.ToString());
sih.Approve = "是";
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
sih.CreateTime = SevTime.First();
sih.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
db.CommitDirector.InsertOnSubmit(sih);
db.SubmitChanges();
//写入线下数据库
TableOfStocks tos = new TableOfStocks();
tos.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
tos.StorageInType = "委外入库";
tos.MaterialID = Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 4].Text.ToString());
tos.MaterialCode = "N/A";
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.CurUnit = this.gv.Rows[i].Cells[7].Text.ToString();
tos.UnitPrice = Convert.ToDecimal(this.gv.Rows[i].Cells[8].Text.ToString());
tos.Amount = Convert.ToDecimal(this.gv.Rows[i].Cells[9].Text.ToString());
tos.ExpectedProject = Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 5].Text.ToString());
tos.Remark = this.gv.Rows[i].Cells[12].Text.ToString();
tos.BatchIndex = _QCbatch;
tos.ManufacturerID = Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 3].Text.ToString());
tos.SupplierID = Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 2].Text.ToString());
tos.PileID = Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 6].Text.ToString());
tos.StorageID = Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 9].Text.ToString());
tos.MaterialsManager = Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 7].Text.ToString());
tos.AssetsManager = Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 8].Text.ToString());
tos.ReceivingTypeName = this.gv.Rows[i].Cells[this.gv.Columns.Count - 12].Text.ToString();
tos.StorageInCode = this.gv.Rows[i].Cells[this.gv.Columns.Count - 11].Text.ToString();
tos.BillCode = this.gv.Rows[i].Cells[this.gv.Columns.Count - 10].Text.ToString();
tos.StorageTime = Convert.ToDateTime(this.gv.Rows[i].Cells[14].Text.ToString());
var Time = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
tos.CreateTime = Time.First();
tos.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
db.TableOfStocks.InsertOnSubmit(tos);
db.SubmitChanges();
//修改人物完成状态
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskID);
tsi.TaskState = "已完成";
db.SubmitChanges();
}
btnko.Enabled = false;
checkPass.Enabled = false;
}
else
{
//审核不通过，回退操作
//删除写入的数据
var temp = from a in db.CommitDirector
where a.CommitInHead.CommitInAssets.CommitInTest.CommitInMaterialsLeader.CommitInMaterials.CommitProduce.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.CommitInHead.CommitInAssets.CommitInTest.CommitInMaterialsLeader.CommitInMaterials.CommitProduce.BatchIndex == Request.QueryString["QCBatch"].ToString()
select new { a.StorageInDirectorID };
var li = temp.ToList();
for (int i = 0; i < li.Count; i++)
{
CommitDirector sd = db.CommitDirector.SingleOrDefault(u => u.StorageInDirectorID == li[i].StorageInDirectorID);
if (sd != null)
{
db.CommitDirector.DeleteOnSubmit(sd);
db.SubmitChanges();
}
}
//回发任务
//原任务
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskID);
tsi.TaskState = "已完成";
tsi.InspectState = "已审核";
//新任务
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 + "(主任审批未通过)";
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "资产组长";
TSI.InspectState = "驳回";
//TSI.BatchOfIndex = this.ddlbatch.SelectedItem.Text.ToString();
TSI.QCBatch = _QCbatch;
TSI.Remark = "审核未通过";
var Sev = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = Sev.First();
db.TaskStorageIn.InsertOnSubmit(TSI);
db.SubmitChanges();
Response.Redirect("../../default-old.aspx", false);
}
//存库标识
ViewState["Temp"] = flag = true;
}
//Response.Redirect("QualifiedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&QCBatch=" + Request.QueryString["QCBatch"] + " ");
}
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 InitControl()
{
_taskstorageid = Convert.ToInt32(Request.QueryString["TaskStorageID"]);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskstorageid);
this._storageinid = tsi.StorageInID;
}
((Label)this.GetControltByMaster("lblCreator")).Text = SPContext.Current.Web.CurrentUser.LoginName;
txtDirector = (TextBox)this.GetControltByMaster("txtDirector");
this.btnSave = (Button)GetControltByMaster("btnSave");
this.btnQuit = (Button)GetControltByMaster("btnQuit");
this.btnSave.Click += new EventHandler(btnSave_Click);
this.btnQuit.Click += new EventHandler(btnQuit_Click);
selUser(txtDirector);
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化交货通知单号
((Label)this.GetControltByMaster("lblStorageInCode")).Text = (db.CommitIn.SingleOrDefault(u => u.CommitInID == _storageinid)).CommitInCode;
//初始化入库单号
((Label)this.GetControltByMaster("lblMessageCode")).Text = (db.CommitIn.SingleOrDefault(u => u.CommitInID == _storageinid)).CommitInQualifiedNum;
//初始化规格类型信息
this.ddlReceivingType = (DropDownList)this.GetControltByMaster("ddlReceivingType");
this.ddlReceivingType.DataSource = from r in db.ReceivingTypeInfo
select new
{
r.ReceivingTypeName,
r.ReceivingTypeID
};
this.ddlReceivingType.DataTextField = "ReceivingTypeName";
this.ddlReceivingType.DataValueField = "ReceivingTypeID";
this.ddlReceivingType.DataBind();
this.ddlReceivingType.SelectedValue = (db.ReceivingTypeInfo.SingleOrDefault(u => u.ReceivingTypeName == "线下入库")).ReceivingTypeID.ToString();
this.ddlReceivingType.Enabled = false;
//若已经发送审批，则提示信息
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.StorageInID == _storageinid && u.TaskType == "主任审核" && u.InspectState == "未审核" && u.StorageInType == "委外入库");
if (tsi != null)
{
txtDirector.Text = (db.EmpInfo.SingleOrDefault(u => u.EmpID == tsi.TaskTargetID)).Account.Trim();
TextBox txtTaskTitle = (TextBox)this.GetControltByMaster("txtTaskTitle");
TextBox txtRemark = (TextBox)this.GetControltByMaster("txtRemark");
txtTaskTitle.Text = tsi.TaskTitle.Trim();
txtRemark.Text = tsi.Remark.Trim();
txtDirector.Enabled = false;
txtRemark.Enabled = false;
txtTaskTitle.Enabled = false;
this.btnSave.Enabled = false;
}
}
}
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.TaskType == "主任审核" && u.InspectState == "未审核" && u.StorageInType == "委外入库");
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中填入入库类型
CommitIn si = db.CommitIn.SingleOrDefault(u => u.CommitInID == _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.CommitInAudited
where a.CommitInID == _storageinid
select a;
foreach (CommitInAudited audited in Auditeds)
{
audited.Director = iDirector;
}
oldDor = iDirector;
iDirector = Proxy.send(iDirector, 2);
//发送新任务
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 = "第一批";
db.TaskStorageIn.InsertOnSubmit(TSI);
db.SubmitChanges();
//pd.TaskID = TSI.TaskStorageID;
//db.SubmitChanges();
//保存代理任务信息
Proxy.saveTask(TSI.TaskStorageID, Proxy.getProxyTaskId(oldDor, 2));
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));
}
}
void btnko_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
var tp = from a in db.StorageInMaterialsLeader
where a.StorageInMaterials.StorageProduce.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.StorageInMaterials.StorageProduce.BatchIndex == Request.QueryString["QCBatch"].ToString()
select a;
if (tp.ToArray().Length > 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不能重复插入记录! ')</script>");
return;
}
if (this.checkPass.Checked)
{
for (int i = 0; i < this.gv.Rows.Count; i++)
{
StorageInMaterialsLeader sil = new StorageInMaterialsLeader();
sil.MaterialsID = Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 1].Text.ToString());
sil.Auditing = "是";
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
sil.CreateTime = SevTime.First();
sil.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
db.StorageInMaterialsLeader.InsertOnSubmit(sil);
db.SubmitChanges();
}
btnko.Enabled = false;
checkPass.Enabled = false;
//存库标识
ViewState["Temp"] = flag = true;
}
else
{
//不审核库，回退操作
//删除写入的数据
var temp = from a in db.StorageInMaterialsLeader
where a.StorageInMaterials.StorageProduce.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.StorageInMaterials.StorageProduce.BatchIndex == Request.QueryString["QCBatch"].ToString()
select new { a.MaterialsLeaderID };
var li = temp.ToList();
for (int i = 0; i < li.Count; i++)
{
StorageInMaterialsLeader sd = db.StorageInMaterialsLeader.SingleOrDefault(u => u.MaterialsLeaderID == li[i].MaterialsLeaderID);
if (sd != null)
{
db.StorageInMaterialsLeader.DeleteOnSubmit(sd);
db.SubmitChanges();
}
}
//回发任务
//原任务
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskID);
tsi.TaskState = "已完成";
tsi.InspectState = "已审核";
//新任务
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 + "(物资组长审核未通过)";
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "物资组员";
TSI.InspectState = "驳回";
//TSI.BatchOfIndex = this.ddlbatch.SelectedItem.Text.ToString();
TSI.QCBatch = _QCbatch;
TSI.Remark = "审核未通过";
var Sev = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = Sev.First();
db.TaskStorageIn.InsertOnSubmit(TSI);
db.SubmitChanges();
Response.Redirect("../../default-old.aspx", false);
}
}
//Response.Redirect("QualifiedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&QCBatch=" + Request.QueryString["QCBatch"] + " ");
}
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 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;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Response.Expires = -1;
try
{
initControl();
//任务回退时
if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"]))
{
this.plinfo.Visible = true;
this.txtOpinion.Visible = true;
this.btnOK.Visible = true;
this.lblInfo.Text = "质检信息:";
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
_storageInID = tsi.StorageInID;
this.txtOpinion.Text = tsi.Remark;
if (tsi.TaskState == "已完成")
{
this.btnOK.Enabled = false;
flag = false;
}
}
}
//新建任务时
else
{
this.plinfo.Visible = false;
//this.txtOpinion.Visible = false;
//this.btnOK.Visible = false;
//this.lblInfo.Visible=false;
_storageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
showResoult(_storageInID, "../Storage/UploadExcelData.aspx?storageInID=" + _storageInID + "");
}
this.gv = new SPGridView();
this.gv.AutoGenerateColumns = false;
BindGridView();
//添加按钮到toolbar
ToolBar tbarTop = (ToolBar)GetControltByMaster("tbarbusiness");
//新建
ToolBarButton tbarbtnAdd = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx");
tbarbtnAdd.ID = "AddNewRow";
tbarbtnAdd.Text = "新建";
tbarbtnAdd.ImageUrl = "/_layouts/images/newitem.gif";
tbarbtnAdd.Click += new EventHandler(tbarbtnAdd_Click);
tbarbtnAdd.Visible = flag;
tbarTop.Buttons.Controls.Add(tbarbtnAdd);
//修改
ToolBarButton tbarbtnEdit = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx");
tbarbtnEdit.ID = "EditRow";
tbarbtnEdit.Text = "修改";
tbarbtnEdit.ImageUrl = "/_layouts/images/edit.gif";
tbarbtnEdit.Click += new EventHandler(tbarbtnEdit_Click);
tbarbtnEdit.Visible = flag;
tbarTop.Buttons.Controls.Add(tbarbtnEdit);
//删除
ToolBarButton tbarbtnDelte = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx");
tbarbtnDelte.ID = "DeleteRow";
tbarbtnDelte.Text = "删除";
tbarbtnDelte.ImageUrl = "/_layouts/images/delete.gif";
tbarbtnDelte.Click += new EventHandler(tbarbtnDelte_Click);
tbarbtnDelte.Visible = flag;
StringBuilder sbScript = new StringBuilder();
sbScript.Append("var aa= window.confirm('确认删除所选项?');");
sbScript.Append("if(aa == false){");
sbScript.Append("return false;}");
tbarbtnDelte.OnClientClick = sbScript.ToString();
tbarTop.Buttons.Controls.Add(tbarbtnDelte);
//导入数据
ToolBarButton tbarbtnImport = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx");
tbarbtnImport.ID = "ImportData";
tbarbtnImport.Text = "数据导入";
tbarbtnImport.ImageUrl = "/_layouts/images/wpqaicon.gif";
tbarbtnImport.Click += new EventHandler(tbarbtnImport_Click);
tbarbtnImport.Visible = flag;
tbarTop.Buttons.Controls.Add(tbarbtnImport);
//返回
ToolBarButton tbarbtnBack = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx");
tbarbtnBack.ID = "backRow";
tbarbtnBack.Text = "返回";
tbarbtnBack.ImageUrl = "/_layouts/images/BACK.GIF";
tbarbtnBack.Click += new EventHandler(tbarbtnBack_Click);
tbarTop.Buttons.Controls.Add(tbarbtnBack);
ToolBarButton btnRefresh = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx");
btnRefresh.ID = "btnRefresh";
btnRefresh.Text = "刷新";
btnRefresh.ImageUrl = "/_layouts/images/refresh.GIF";
btnRefresh.Padding = "0,5,0,0";
btnRefresh.Click += new EventHandler(btnRefresh_Click);
tbarTop.RightButtons.Controls.Add(btnRefresh);
}
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_LOADERROR));
}
}
private void InitializeCustomControls()
{
this.spgviewAuditControl = new SPGridView();
this.spgviewAuditControl.AutoGenerateColumns = false;
this.spgviewAuditControl.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
string[] ShowTlist =
{
"交货通知单编号:StorageInCode",
"入库单号:StorageInQualifiedNum",
"物料名称:MaterialName",
"物料编码:MaterialCode",
"规格型号:SpecificationModel",
"质检合格根/套/件数量:QuantityGentaojian",
"质检合格米数量:QuantityMetre",
"质检合格吨数量:QuantityTon",
"所选单位数量:Quantity",
"计量单位:CurUnit",
"质检时间:InspectionTime",
"检验报告号:InspectionReportNum",
"单价:UnitPrice",
"金额:Amount",
"所属仓库:StorageName",
"所属垛位:PileCode",
"财务编号:financeCode",
"到库时间:StorageTime",
"批次信息:BatchIndex",
"供应商:SupplierName",
"物资管理员:MaterialsManager",
"仓库员:WarehouseWorker",
"备注:Remark",
"MID:MaterialID"
};
string[] HideTlist =
{
"SupplierIDCol:SupplierID",
"MaterialsManagerIDCol:MaterialsManagerID",
"WarehouseWorkerIDCol:WarehouseWorkerID",
};
BoundField bfColumn;
foreach (var kvp in ShowTlist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgviewAuditControl.Columns.Add(bfColumn);
}
//为SPGridView添加状态列
TemplateField tlfAudit = new TemplateField();
tlfAudit.HeaderText = "状态";
tlfAudit.ItemTemplate = new LabelTemplate("状态", DataControlRowType.DataRow);
this.spgviewAuditControl.Columns.Insert(23, tlfAudit);
CommandField cdf = new CommandField();
cdf.HeaderText = "审核";
cdf.SelectText = "通过/未通过";
cdf.ShowSelectButton = true;
this.spgviewAuditControl.SelectedIndexChanging += new GridViewSelectEventHandler(spgviewAuditControl_SelectedIndexChanging);
this.spgviewAuditControl.Columns.Insert(24, cdf);
//添加隐藏列
foreach (var kvp in HideTlist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgviewAuditControl.Columns.Add(bfColumn);
}
//添加控件到panel1
btnSend = new Button();
btnSend.Text = "生成审核清单";
btnSend.Enabled = false;
btnSend.Width = 100;
btnSend.Click += new EventHandler(btnSend_Click);
btnCancel = new Button();
btnCancel.Text = "返回";
btnCancel.Width = 100;
btnCancel.Click += new EventHandler(btnCancel_Click);
chbAuditAll = new CheckBox();
chbAuditAll.Checked = false;
chbAuditAll.AutoPostBack = true;
chbAuditAll.Text = "<font size = 2pt>全部通过审核</font>";
chbAuditAll.CheckedChanged += new EventHandler(chbAuditAll_CheckedChanged);
//验证任务是否已经完成
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
if (tsi.TaskState == "已完成")
{
this.chbAuditAll.Enabled = false;
cdf.Visible = false;
}
}
}
