protected void tbarbtnAdd_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"]))
{
ClientScript.RegisterClientScriptBlock(typeof(string), "Messages", "<script>alert('回退任务不能新增批次.')</script>");
return;
}
else
{
Response.Redirect("StorageDetailedCreate.aspx?StorageInID=" + _storageInID + "");
}
}
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));
}
//ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('hello! ')</script>");
}
void btnmodify_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//更新数据
var tep = from a in db.StorageInTest
where a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"].ToString()) && a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.BatchIndex == _QCbatch
orderby a.StorageInTestID ascending
select new { a.StorageInTestID };
var li = tep.ToList();
for (int i = 0; i < this.gv.Rows.Count; i++)
{
StorageInTest st = new StorageInTest();
st = db.StorageInTest.SingleOrDefault(u => u.StorageInTestID == li[i].StorageInTestID);
st.MaterialsLeaderID = Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 1].Text.ToString());
TextBox gentaojian_qualified = (TextBox)(this.gv.Rows[i].Cells[5].Controls[0]);
st.TestGentaojian = Convert.ToDecimal(gentaojian_qualified.Text.Trim());
TextBox gentaojian_unqualified = (TextBox)(this.gv.Rows[i].Cells[6].Controls[0]);
st.FailedGentaojian = Convert.ToDecimal(gentaojian_unqualified.Text.Trim());
TextBox metre_qualified = (TextBox)(this.gv.Rows[i].Cells[8].Controls[0]);
st.TestMetre = Convert.ToDecimal(metre_qualified.Text.Trim());
TextBox metre_unqualified = (TextBox)(this.gv.Rows[i].Cells[9].Controls[0]);
st.FailedMetre = Convert.ToDecimal(metre_unqualified.Text.Trim());
TextBox ton_qualified = (TextBox)(this.gv.Rows[i].Cells[11].Controls[0]);
st.TestTon = Convert.ToDecimal(ton_qualified.Text.Trim());
TextBox ton_unqualified = (TextBox)(this.gv.Rows[i].Cells[12].Controls[0]);
st.FailedTon = Convert.ToDecimal(ton_unqualified.Text.Trim());
TextBox reportNum = (TextBox)(this.gv.Rows[i].Cells[13].Controls[0]);
st.InspectionReportNum = reportNum.Text.Trim();
st.FileNameStr = "reportqualified";
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
st.CreateTime = SevTime.First();
st.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
db.SubmitChanges();
}
//存库标识
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));
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string strTaskID = Request.QueryString["TaskID"];
_taskid = string.IsNullOrEmpty(strTaskID) ? -1 : Convert.ToInt32(strTaskID);
_tasktype = Request.QueryString["TaskType"];
string strNoticeID = Request.QueryString["NoticeID"];
_noticeid = string.IsNullOrEmpty(strNoticeID) ? -1 : Convert.ToInt32(strNoticeID);
_executor = Request.QueryString["Executor"];
strFinishUrl = "../../default-old.aspx";
InitControl();
}
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 btnOK_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
StorageOutDetails sod;
foreach (GridViewRow gvr in this.spgvMaterial.Rows)
{
sod = db.StorageOutDetails.SingleOrDefault(u => u.StorageOutDetailsID == Convert.ToInt32(gvr.Cells[11].Text));
sod.Gentaojian = Convert.ToDecimal((gvr.Cells[5].Controls[0] as TextBox).Text.Trim());
sod.Metre = Convert.ToDecimal((gvr.Cells[7].Controls[0] as TextBox).Text.Trim());
sod.Ton = Convert.ToDecimal((gvr.Cells[9].Controls[0] as TextBox).Text.Trim());
sod.Remark = (gvr.Cells[10].Controls[0] as TextBox).Text.Trim();
sod.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
db.SubmitChanges();
}
}
Response.Redirect(string.Format("NormalOutProduceDetailsMessage.aspx?TaskID={0}", _taskid), 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
{
_storageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
_taskID = Convert.ToInt32(Request.QueryString["TaskStorageID"]);
_QCbatch = Request.QueryString["QCBatch"];
control();
taskState();
initControl(_flag);
this.gv = new SPGridView();
this.gv.AutoGenerateColumns = false;
BindGridView();
if (!IsPostBack)
{
ViewState["Temp"] = false;
dataLoad();
}
}
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))
{
StorageOutTask sot = db.StorageOutTask.SingleOrDefault(u => u.TaskID == this._taskid);
if (sot.TaskState.Equals("已完成"))
{
Response.Redirect(string.Format("NormalOutAssetDetailsMessage.aspx?TaskID={0}", _taskid), false);
return;
}
_noticeid = sot.NoticeID;
}
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 int reEmpId(string Emp)
{
int valueEmp = 0;
try
{
using (MMSProDBDataContext dc = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
EmpInfo EI = dc.EmpInfo.SingleOrDefault(u => u.Account == Emp);
if (EI != null)
{
valueEmp = EI.EmpID;
}
}
}
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));
}
return(valueEmp);
}
private bool RealDetailsIsDone()
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
if (db.StorageCommitOutRealDetails.Count(u => u.StorageCommitOutNoticeID.Equals(_noticeid)) != 0)
{
return(true);
}
else
{
return(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_QUERYERROR));
return(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))
{
_receiptid = db.SrinQualifiedReceipt.SingleOrDefault(u => u.TaskID.Equals(_taskid)).SrinQualifiedReceiptID;
if (db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID.Equals(_taskid)).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 btnCancel_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//分支流程--任务已完成的情况
StorageOutTask sot = db.StorageOutTask.SingleOrDefault(u => u.StorageOutTaskID == this._taskid);
if (sot.TaskState.Equals("未完成") && lblDirectorResult.Text.Equals("未通过"))//主流程--任务未完成而且主任审批未通过则将出库数目清零
{
db.ExecuteCommand("Update StorageCommitOutRealDetails Set RealGentaojian = 0,RealMetre = 0,RealTon = 0,RealAmount = 0 Where StorageCommitOutNoticeID = {0}", this._noticeid);
}
if (sot.TaskState.Equals("未完成"))
{
sot.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_QUERYERROR));
}
}
void ddlProprietor_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
this.ddlProject.DataSource = from a in db.ProjectInfo
where a.Owner == Convert.ToInt32(ddlProprietor.SelectedValue)
select new {
Key = a.ProjectName,
Value = a.ProjectID,
};
this.ddlProject.DataTextField = "Key";
this.ddlProject.DataValueField = "Value";
this.ddlProject.DataBind();
this.ddlProject.Items.Insert(0, "--请选择--");
this.ddlProjectStage.Items.Clear();
}
}
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
{
this._userid = Convert.ToInt32(Request.QueryString["CurrentUserID"]);
this._noticeid = Convert.ToInt32(Request.QueryString["NoticeID"]);
InitializeCustomControl();
if (!Page.IsPostBack)
{
BindControl();
if (_noticeid != 0)//分支流程--修改Notice的情况
{
BindDataToCustomControls();
}
}
}
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
{
_noticeid = Convert.ToInt32(Request.QueryString["NoticeID"]);
strBackUrl = Request.QueryString["BackUrl"];
if (string.IsNullOrEmpty(strBackUrl))
{
strBackUrl = string.Format("ManageStorageOutDetails.aspx?NoticeID={0}", _noticeid);
}
else
{
strBackUrl = HttpUtility.UrlDecode(strBackUrl);
}
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 chbShowAll_CheckedChanged(object sender, EventArgs e)
{
try
{
if (!chbShowAll.Checked)
{
chbShowAll.Enabled = true;
}
else
{
txtFinanceCode.Text = string.Empty;
txtMaterialName.Text = string.Empty;
txtSpecificationModel.Text = string.Empty;
chbShowAll.Enabled = false;
}
Response.AddHeader("Refresh", "0");
}
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)
{
this.gv = new SPGridView();
this.gv.AutoGenerateColumns = false;
try
{
BindGridView();
//添加按钮到toolbar
ToolBar tbarTop = (ToolBar)GetControltByMaster("tbarbusiness");
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));
}
}
protected void tbarbtnDelte_Click(object sender, EventArgs e)
{
try
{
List <CheckBox> listString = GetCheckedID();
if (listString.Count > 0)
{
StorageInDetailed SID;
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
foreach (var li in listString)
{
SID = db.StorageInDetailed.SingleOrDefault(a => a.StorageDetailedID == int.Parse(li.ToolTip));
if (SID != null)
{
db.StorageInDetailed.DeleteOnSubmit(SID);
}
}
db.SubmitChanges();
}
Response.Redirect("StorageInDetailedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "");
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择需要删除的记录!')</script>");
}
}
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_DELETEERROR));
}
}
void btnOK_Click(object sender, EventArgs e)
{
try
{
//将审核结果保存到数据库
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
StorageCommitOutDirectorConfirm scodc;
//将审核结果保存到数据库
scodc = new StorageCommitOutDirectorConfirm();
scodc.StorageCommitOutNoticeID = _noticeid;
scodc.StorageCommitOutAssetAuditID = _aauditid;
scodc.ConfirmTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
scodc.Director = (db.EmpInfo.SingleOrDefault(u => u.EmpName == SPContext.Current.Web.CurrentUser.Name)).EmpID;
scodc.TaskID = _taskid;
db.StorageCommitOutDirectorConfirm.InsertOnSubmit(scodc);
db.SubmitChanges();
//转到审核表单页
Response.Redirect(string.Format("CommitOutDirectorMessage.aspx?TaskID={0}", _taskid), 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));
}
}
private void InsertAudited(GridViewRow gvr)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
Label lb = (Label)gvr.Cells[23].Controls[0];
//新增
StorageInAudited sia = new StorageInAudited();
sia.StorageInID = _storageinid;
sia.MaterialID = (db.MaterialInfo.SingleOrDefault(u => u.MaterialID == Convert.ToInt32(gvr.Cells[25].Text))).MaterialID;
sia.SpecificationModel = gvr.Cells[4].Text;
sia.QuantityGentaojian = Convert.ToDecimal(gvr.Cells[5].Text);
sia.QuantityMetre = Convert.ToDecimal(gvr.Cells[6].Text);
sia.QuantityTon = Convert.ToDecimal(gvr.Cells[7].Text);
sia.Quantity = Convert.ToDecimal(gvr.Cells[8].Text);
sia.CurUnit = gvr.Cells[9].Text;
sia.NumberQualified = 0;
sia.InspectionTime = Convert.ToDateTime(gvr.Cells[10].Text);
sia.InspectionReportNum = gvr.Cells[11].Text;
sia.UnitPrice = Convert.ToDecimal(gvr.Cells[12].Text);
sia.Amount = Convert.ToDecimal(gvr.Cells[13].Text);
sia.PileID = (db.PileInfo.SingleOrDefault(u => u.PileCode == gvr.Cells[15].Text)).PileID;
sia.financeCode = gvr.Cells[16].Text;
sia.StorageTime = Convert.ToDateTime(gvr.Cells[17].Text);
sia.BatchIndex = gvr.Cells[18].Text;
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
sia.AuditTime = SevTime.First();
sia.Remark = gvr.Cells[22].Text;
sia.SupplierID = Convert.ToInt32(gvr.Cells[26].Text);
sia.MaterialsManager = Convert.ToInt32(gvr.Cells[27].Text);
sia.WarehouseWorker = Convert.ToInt32(gvr.Cells[28].Text);
sia.AuditStatus = lb.Text == "未通过" ? "未通过" : "已通过";
sia.MaterialAccounting = (db.EmpInfo.SingleOrDefault(u => u.EmpName == SPContext.Current.Web.CurrentUser.Name)).EmpID;
db.StorageInAudited.InsertOnSubmit(sia);
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));
}
}
protected void InitControls()
{
this.lblFromProcess = (Label)GetControltByMaster("lblFromProcess");
this.lblFromTask = (Label)GetControltByMaster("lblFromTask");
this.lblFromEmp = (Label)GetControltByMaster("lblFromEmp");
this.lblCreateTime = (Label)GetControltByMaster("lblCreateTime");
this.lblMsgTitle = (Label)GetControltByMaster("lblMsgTitle");
this.lblMsgContent = (Label)GetControltByMaster("lblMsgContent");
this.lblMsgStatus = (Label)GetControltByMaster("lblMsgStatus");
this.btnEditStatus = (Button)GetControltByMaster("btnEditStatus");
btnEditStatus.Click += new EventHandler(btnEditStatus_Click);
using (MMSProDBDataContext dc = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
try
{
MessageInfo msgInfoTemp = dc.MessageInfo.SingleOrDefault(mi => mi.MessageInfoID == this.curMsgInfoID);
if (msgInfoTemp != null)
{
this.lblFromProcess.Text = msgInfoTemp.MessageSource;
if (msgInfoTemp.MessageSource == "回收入库")
{
this.lblFromTask.Text = dc.TaskStorageIn.SingleOrDefault(tsi => tsi.TaskStorageID == msgInfoTemp.TaskID).TaskTitle;
}
else if (msgInfoTemp.MessageSource == "正常入库")
{
this.lblFromTask.Text = dc.StorageOutTask.SingleOrDefault(sot => sot.TaskID == msgInfoTemp.TaskID).TaskTitle;
}
//this.lblFromEmp.Text = dc.EmpInfo.SingleOrDefault(ei => ei.EmpID == msgInfoTemp.Creater).EmpName;
this.lblFromEmp.Text = msgInfoTemp.EmpInfo.EmpName;
this.lblCreateTime.Text = msgInfoTemp.CreateTime.ToString();
this.lblMsgTitle.Text += msgInfoTemp.MessageTitle;
this.lblMsgContent.Text = msgInfoTemp.MessageContent;
this.lblMsgStatus.Text = msgInfoTemp.MessageStatus;
if (this.lblMsgStatus.Text == "未读")
{
this.lblMsgStatus.ForeColor = System.Drawing.Color.Red;
this.btnEditStatus.Text = "标记为已读?";
this.btnEditStatus.Enabled = true;
}
else
{
this.lblMsgStatus.ForeColor = System.Drawing.Color.Green;
this.btnEditStatus.Text = "已读状态";
this.btnEditStatus.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));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
InitControl();
checkSendPolicy();
if (!IsPostBack)
{
BindDefaultDate();
}
selUser(this.txtRecipient);
if (!string.IsNullOrEmpty(Request.QueryString["storageInType"]))
{
switch (Request.QueryString["storageInType"])
{
case "正常入库":
storageInType = "正常入库";
break;
case "委外入库":
storageInType = "委外入库";
break;
case "回收入库":
storageInType = "回收入库";
break;
}
}
if (Request.QueryString["state"].ToString() == "质检")
{
this.txtMessageCode.Enabled = false;
lblre.Text = "质检人";
currentFlow = "质检";
}
if (Request.QueryString["state"].ToString() == "材料会计审核")
{
this.txtMessageCode.Enabled = true;
lblre.Text = "材料会计";
currentFlow = "材料会计审核";
}
}
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))
{
CheckBox chb;
int iCount = 0;
SrinSubDetails ssd;
foreach (GridViewRow gvr in spgvMaterial.Rows)
{
chb = (CheckBox)gvr.Cells[0].Controls[0];
if (!chb.Checked)
{
continue;
}
//将选中项保存到数据库
ssd = new SrinSubDetails();
ssd.SrinSubDocID = _subdocid;
ssd.TotleGentaojian = Convert.ToDecimal(((TextBox)gvr.Cells[4].Controls[0]).Text.Trim());
ssd.TotleMetre = Convert.ToDecimal(((TextBox)gvr.Cells[5].Controls[0]).Text.Trim());
ssd.TotleTon = Convert.ToDecimal(((TextBox)gvr.Cells[6].Controls[0]).Text.Trim());
ssd.RetrieveCode = ((TextBox)gvr.Cells[7].Controls[0]).Text.Trim();
ssd.Remark = ((TextBox)gvr.Cells[8].Controls[0]).Text.Trim();
ssd.MaterialID = Convert.ToInt32(gvr.Cells[9].Text);
ssd.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
ssd.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID;
db.SrinSubDetails.InsertOnSubmit(ssd);
iCount++;
}
db.SubmitChanges();
//没有选中的情况
if (iCount == 0)
{
Response.Write("<script language='javaScript'>alert('没有选中要添加的物资明细！');</script>");
return;
}
}
Response.AddHeader("Refresh", "0");
}
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 btnmodify_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//更新数据
var tep = from a in db.StorageInAssets
where a.StorageInTest.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"].ToString()) && a.StorageInTest.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.BatchIndex == _QCbatch
orderby a.StorageInAssetsID ascending
select new { a.StorageInAssetsID };
var li = tep.ToList();
for (int i = 0; i < this.gv.Rows.Count; i++)
{
StorageInAssets sia = db.StorageInAssets.SingleOrDefault(u => u.StorageInAssetsID == li[i].StorageInAssetsID);
DropDownList ddlunit = (DropDownList)(this.gv.Rows[i].Cells[7].Controls[0]);
sia.CurUnit = ddlunit.SelectedItem.Text;
TextBox unitprice = (TextBox)(this.gv.Rows[i].Cells[8].Controls[0]);
sia.UnitPrice = Convert.ToDecimal(unitprice.Text.Trim());
//TextBox amount = (TextBox)(this.gv.Rows[i].Cells[9].Controls[0]);
sia.Amount = Convert.ToDecimal(this.gv.Rows[i].Cells[reCellIndex(ddlunit.SelectedItem.Text)].Text) * sia.UnitPrice;
TextBox reportNum = (TextBox)(this.gv.Rows[i].Cells[10].Controls[0]);
sia.BillCode = reportNum.Text.Trim();
TextBox material = (TextBox)(this.gv.Rows[i].Cells[11].Controls[0]);
sia.MaterialsAttribute = material.Text.Trim();
sia.financeCode = "009811";
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
sia.CreateTime = SevTime.First();
sia.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
db.SubmitChanges();
}
//存库标识
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));
}
}
void btnSave_Click(object sender, EventArgs e)
{
try
{
List <CheckBox> listString = GetCheckedID();
if (listString.Count > 0)
{
if (CheckStringEmpty())
{
for (int i = 0; i < this.gv.Rows.Count; i++)
{
chb = (CheckBox)this.gv.Rows[i].Cells[0].Controls[0];
if (!chb.Checked)
{
continue;
}
if (this.gv.Rows[i].Cells[4].Controls[0] is TextBox)
{
itembox = (TextBox)this.gv.Rows[i].Cells[4].Controls[0];
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
AwaitScrap asp = db.AwaitScrap.SingleOrDefault(u => u.AwaitScrapID == int.Parse(this.gv.Rows[i].Cells[this.gv.Columns.Count - 1].Text));
asp.ScrapReportNum = itembox.Text.Trim();
db.SubmitChanges();
}
}
}
Response.Redirect("AwaitScrapManage.aspx", false);
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请将选择的数据填写完整!')</script>");
return;
}
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择要提交的物资!')</script>");
return;
}
}
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.InitControl();
}
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));
}
}
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"]);
StorageInMain SI = db.StorageInMain.SingleOrDefault(a => a.StorageInID == id);
//单据编号唯一
StorageInMain scode = db.StorageInMain.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;
}
}
if (this.ddlType.SelectedIndex == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择入库类型！')</script>");
return;
}
SI.StorageInCode = this.txtBillCode.Text.Trim();
SI.ReceivingType = Convert.ToInt32(this.ddlType.SelectedValue.Trim());
SI.Remark = this.txtRemark.Text.Trim();
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
SI.CreateTime = SevTime.First();
db.SubmitChanges();
Response.Redirect("StorageManage.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));
}
}
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._batchname = tsi.QCBatch;
}
InitializeCustomControls();
BindGridView();
ShowCustomControls();
if (this.IsAudited())
{
Response.Redirect("AuditedModify.aspx?TaskStorageID=" + _taskstorageid + " ");
}
else
{
if (!Page.IsPostBack)
{
//初始化审核状态为"待审核"
SetAuditStatus(Audit.Init);
}
else
{
//审核后更改审核状态
SetAuditStatus(Audit.Normal);
}
}
}
}
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 tbarbtnDelete_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
int ichecked = 0;
CheckBox chb;
int idetailsid;
foreach (GridViewRow gvr in spgvMaterial.Rows)
{
chb = (CheckBox)gvr.Cells[0].Controls[0];
if (!chb.Checked)
{
continue;
}
ichecked++;
switch (_type)
{
case "维修保养":
idetailsid = Convert.ToInt32(gvr.Cells[12].Text);
SrinMaterialRepairDetails smrd = db.SrinMaterialRepairDetails.SingleOrDefault(a => a.SrinMaterialRepairDetailsID == idetailsid);
db.SrinMaterialRepairDetails.DeleteOnSubmit(smrd);
break;
case "回收检验":
idetailsid = Convert.ToInt32(gvr.Cells[9].Text);
SrinMaterialVerifyDetails smvd = db.SrinMaterialVerifyDetails.SingleOrDefault(a => a.SrinMaterialVerifyDetailsID == idetailsid);
db.SrinMaterialVerifyDetails.DeleteOnSubmit(smvd);
break;
}
}
if (ichecked != 0)
{
db.SubmitChanges();
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择需要删除的记录!')</script>");
}
}
Response.AddHeader("Refresh", "0");
}
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));
}
}
/// <summary>
/// 检查入库单下是否有物资
/// </summary>
/// <returns></returns>
//private bool checkDetail(int cid)
//{
// using (MMSProDBDataContext data = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
// {
// var temp = from a in data.StorageInDetailed
// where a.StorageInID == cid
// select a;
// if (temp.ToList().Count > 0)
// {
// return false;
// }
// }
// return true;
//}
protected void tbarbtnDelte_Click(object sender, EventArgs e)
{
try
{
List <CheckBox> listString = GetCheckedID();
if (listString.Count > 0)
{
StorageInMain SI;
using (MMSProDBDataContext data = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
foreach (var li in listString)
{
if (!isInTask(li.ToolTip))
{
//检查入库单下是否有明细物资
if (checkDetail(int.Parse(li.ToolTip)) == false)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('此入库单已存在物资,若要删除入库单,请先删除入库单下的物资!')</script>");
return;
}
SI = data.StorageInMain.SingleOrDefault(a => a.StorageInID == int.Parse(li.ToolTip));
if (SI != null)
{
data.StorageInMain.DeleteOnSubmit(SI);
data.SubmitChanges();
}
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('此入库单单已进入任务流程不能删除!')</script>");
return;
}
}
}
Response.Redirect("StorageManage.aspx");
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择需要删除的记录!')</script>");
return;
}
}
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));
}
}
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))
{
//分支流程--任务已经完成的情况
if (db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid).TaskState.Equals("已完成"))
{
if (db.SrinStocktaking.Count(u => u.TaskID == _taskid && u.StocktakingResult.Equals("清点有误")) != 0)//分支流程--清点有误的情况
{
Response.Redirect(string.Format("RiMaterialStocktakingMessage.aspx?TaskID={0}", _taskid), false);
}
else//清点无误的情况
{
Response.Redirect(string.Format("ViewRepairAndVerifyInfo.aspx?TaskID={0}", _taskid), false);
}
return;
}
else
{
//分支流程--已经发送确认任务的情况
if (db.TaskStorageIn.Count(u => u.PreviousTaskID.Equals(_taskid) && u.TaskType.Equals("物资组长确认清点结果")) != 0)
{
Response.Redirect(string.Format("RiMaterialStocktakingMessage.aspx?TaskID={0}", _taskid), false);
return;
}
//分支流程--已经清点过的情况
if (db.SrinStocktaking.Count(u => u.TaskID == _taskid) != 0)
{
Response.Redirect(string.Format("RiMaterialModifyStocktaking.aspx?TaskID={0}", _taskid), false);
return;
}
}
_subdocid = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid).StorageInID;
}
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
{
//保存清点结果
SrinStocktaking sst;
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
sst = new SrinStocktaking();
sst.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID;
sst.StocktakingDate = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
sst.SrinSubDocID = _subdocid;
sst.StocktakingResult = chbCheck.Checked ? "清点有误" : "清点无误";
sst.StocktakingProblem = txtProblem.Text.Trim();
sst.TaskID = _taskid;
db.SrinStocktaking.InsertOnSubmit(sst);
db.SubmitChanges();
//保存清点物资明细
int iDetailsID, iStorageID, iPileID;
SrinStocktakingDetails sstd;
foreach (GridViewRow gvr in this.spgvMaterial.Rows)
{
iDetailsID = Convert.ToInt32(gvr.Cells[10].Text);
iStorageID = Convert.ToInt32((gvr.Cells[6].Controls[0] as DropDownList).SelectedValue);
iPileID = Convert.ToInt32((gvr.Cells[7].Controls[0] as DropDownList).SelectedValue);
sstd = new SrinStocktakingDetails();
sstd.SrinStocktakingID = sst.SrinStocktakingID;
sstd.SrinSubDetailsID = iDetailsID;
sstd.StorageID = iStorageID == 0?new Nullable <int>():iStorageID;
sstd.PileID = iPileID == 0?new Nullable <int>():iPileID;
sstd.Remark = ((TextBox)gvr.Cells[9].Controls[0]).Text.Trim();
sstd.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
sstd.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID;
db.SrinStocktakingDetails.InsertOnSubmit(sstd);
}
db.SubmitChanges();
}
Response.Redirect(string.Format("RiMaterialStocktakingMessage.aspx?TaskID={0}", _taskid), 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));
}
}
