예제 #1
0
        public void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
                {
                    CommitProduce SID = db.CommitProduce.SingleOrDefault(u => u.StorageInProduceID == _detailID);


                    SID.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
                    SID.MaterialID  = Convert.ToInt32(this.txtID.Text.Trim());

                    SID.QuantityGentaojian = Convert.ToDecimal(this.txtGTJ.Text.Trim());
                    SID.QuantityMetre      = Convert.ToDecimal(this.txtMetre.Text.Trim());
                    SID.QuantityTon        = Convert.ToDecimal(this.txtTon.Text.Trim());



                    if (this.ddlproject.SelectedIndex == 0)
                    {
                        ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择预期使用项目!')</script>");
                        return;
                    }


                    SID.ExpectedProject = Convert.ToInt32(this.ddlproject.SelectedValue.Trim());


                    SID.ExpectedTime = this.DateTimeStorageIn.SelectedDate;


                    if (this.ddlbatch.SelectedItem.Text == "--请选择--")
                    {
                        ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择入库批次')</script>");
                        return;
                    }

                    SID.BatchIndex = this.ddlbatch.SelectedItem.Text.ToString();
                    var SevTime = db.ExecuteQuery <DateTime>("select  getdate()", new object[] { });
                    SID.CreateTime = SevTime.First();
                    SID.Creator    = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
                    SID.Remark     = this.txtRemark.Text.Trim();
                    db.SubmitChanges();
                    if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"]))
                    {
                        Response.Redirect("StorageDetailedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "");
                    }
                    else
                    {
                        Response.Redirect("StorageDetailedManage.aspx?StorageInID=" + Request.QueryString["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_INSERTERROR));
            }
        }
예제 #2
0
        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");
            }
        }
예제 #3
0
        private bool checkInFlow(string selID)
        {
            using (MMSProDBDataContext data = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
            {
                CommitProduce sid      = data.CommitProduce.SingleOrDefault(u => u.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && u.StorageInProduceID == Convert.ToInt32(selID));
                string        CurBatch = sid.BatchIndex;

                var temp = from a in data.TaskStorageIn
                           where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.StorageInType == "委外入库" && a.QCBatch == CurBatch
                           select a;


                if (temp.ToList().Count > 0)
                {
                    return(false);
                }
            }

            return(true);
        }