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"]);
CommitInMain SI = db.CommitInMain.SingleOrDefault(a => a.StorageInID == id);
//单据编号唯一
CommitInMain scode = db.CommitInMain.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.ReceivingType = "委外入库";
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));
}
}
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))
{
CommitInMain temp = db.CommitInMain.SingleOrDefault(u => u.StorageInID == id);
this.txtStorageinNum.Text = temp.StorageInCode.ToString();
this.txtStorageinNum.Enabled = false;
}
}
else
{
Response.Redirect("StorageManage.aspx");
}
}
private void LoadData()
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
int id = Convert.ToInt32(Request.QueryString["StorageInID"]);
CommitInMain SI = db.CommitInMain.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("StorageManage.aspx");
}
}
}
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))
{
CommitInMain temp = db.CommitInMain.SingleOrDefault(u => u.StorageInID == id);
this.txtStorageinNum.Text = temp.StorageInCode.ToString();
this.txtStorageinNum.Enabled = false;
//初始化
CommitProduce sp = db.CommitProduce.SingleOrDefault(u => u.StorageInProduceID == _detailID);
if (sp != null)
{
this.txtMaterialCode.Text = sp.MaterialInfo.MaterialName;
this.txtMaterialMod.Text = sp.MaterialInfo.SpecificationModel;
this.txtID.Text = sp.MaterialID.ToString();
this.txtFinanceCode.Text = sp.MaterialInfo.FinanceCode;
this.txtGTJ.Text = sp.QuantityGentaojian.ToString();
this.txtMetre.Text = sp.QuantityMetre.ToString();
this.txtTon.Text = sp.QuantityTon.ToString();
this.ddlproject.SelectedValue = sp.ExpectedProject.ToString();
this.DateTimeStorageIn.SelectedDate = sp.ExpectedTime;
this.ddlbatch.Text = sp.BatchIndex.Trim();
this.txtRemark.Text = sp.Remark.Trim();
}
}
}
else
{
Response.Redirect("StorageManage.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 = "已完成";
CommitInMain si = db.CommitInMain.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
{
if (!string.IsNullOrEmpty(this.txtBillCode.Text))
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
CommitInMain SI = new CommitInMain();
CommitInMain scode = db.CommitInMain.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.ReceivingType = "委外入库";
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.CommitInMain.InsertOnSubmit(SI);
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_INSERTERROR));
}
}
public void btnSave_Click(object sender, EventArgs e)
{
try
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//判断所选质检批次是否在待质检表中
var tmp = from a in db.CommitProduce
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;
}
//判断任务列表中是否已发过此条任务
TaskStorageIn ts = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
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 (ts.InspectState != "驳回")
{
if (task.ToArray().Length != 0)
{
//如果是驳回的信息允许再次发送
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不能重复发送相同任务 ')</script>");
return;
}
}
//修改完成状态
if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"]))
{
if (ts != null)
{
ts.TaskState = "已完成";
}
}
//生成质检完成流水号
if (Request.QueryString["state"].ToString() == "材料会计审核")
{
CommitInMain si = db.CommitInMain.SingleOrDefault(u => u.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]));
}
//代理step1
int iDirector = reEmpId(this.txtRecipient.Text.Trim());//主任id
if (Request.QueryString["state"].ToString() == "主任审核")
{
//检查当前登录用户是否有代理任务
oldDor = iDirector; //保存主任id
iDirector = Proxy.send(iDirector, 2); //转给代理人
}
//发送新任务
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(this.lblCreator.Text.Trim());
TSI.TaskTargetID = iDirector;
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 = _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();
//代理step2
//保存代理任务信息
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));
}
}
