Exemple #1
0
        protected override object GetEditObject()
        {
            if (_facade == null)
            {
                _facade = new MaterialFacade(this.DataProvider);
            }
            WorkPlan workPlan = this._facade.CreateNewWorkPlan();

            workPlan.PlanDate  = FormatHelper.TODateInt(this.txtdateDateEdit.Text);
            workPlan.BigSSCode = FormatHelper.CleanString(this.txtBigSSCodeGroupEdit.Text.Trim().ToUpper());
            workPlan.MoCode    = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOCodeGroupEdit.Text, 40));
            workPlan.MoSeq     = Convert.ToDecimal(FormatHelper.CleanString(this.txtMOSeqEdit.Text.Trim().ToUpper()));

            workPlan = (WorkPlan)_facade.GetWorkPlan(workPlan.BigSSCode, workPlan.PlanDate, workPlan.MoCode, workPlan.MoSeq);
            if (workPlan == null)
            {
                return(null);
            }

            if (this.timePromiseTimeEdit.Text.Trim().Length > 0)
            {
                workPlan.PromiseTime = FormatHelper.TOTimeInt(this.timePromiseTimeEdit.Text);
            }

            return(workPlan);
        }
        protected override void cmdDelete_Click(object sender, EventArgs e)
        {
            if (_facade == null)
            {
                _facade = new MaterialFacade(this.DataProvider);
            }

            ArrayList            rowList           = this.gridHelper.GetCheckedRows();
            List <MaterialIssue> materialIssueList = new List <MaterialIssue>();

            foreach (UltraGridRow row in rowList)
            {
                if (row.Cells[6].Text == this.languageComponent1.GetString(MaterialIssueStatus.MaterialIssueStatus_Close))
                {
                    WebInfoPublish.PublishInfo(this, "$Close_Cannot_Delete", this.languageComponent1);
                    return;
                }
                MaterialIssue materialIssue = (MaterialIssue)_facade.GetMaterialIssue(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtBigSSCodeGroupQuery.Text)),
                                                                                      FormatHelper.TODateInt(this.txtPlanDateFromQuery.Text),
                                                                                      FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoQuery.Text)),
                                                                                      Convert.ToDecimal(this.txtMOSeqQuery.Text.Trim()),
                                                                                      Convert.ToDecimal(row.Cells[1].Text));
                if (materialIssue != null)
                {
                    materialIssueList.Add(materialIssue);
                }
            }

            if (materialIssueList.Count > 0)
            {
                this._facade.DeleteMaterialIssue((MaterialIssue[])materialIssueList.ToArray());
            }

            this.RequestData();
        }
Exemple #3
0
 protected override void UpdateDomainObject(object domainObject)
 {
     if (_Facade == null)
     {
         _Facade = new MaterialFacade(base.DataProvider);
     }
     this._Facade.UpdateMaterialReqStd((MaterialReqStd)domainObject);
 }
Exemple #4
0
 protected override void DeleteDomainObjects(ArrayList domainObjects)
 {
     if (_Facade == null)
     {
         _Facade = new MaterialFacade(base.DataProvider);
     }
     this._Facade.DeleteMaterialReqStd((MaterialReqStd[])domainObjects.ToArray(typeof(MaterialReqStd)));
 }
Exemple #5
0
 protected override void DeleteDomainObjects(ArrayList domainObjects)
 {
     if (_facade == null)
     {
         _facade = new MaterialFacade(this.DataProvider);
     }
     this._facade.DeleteWorkPlan((WorkPlan[])domainObjects.ToArray(typeof(WorkPlan)));
     this.RequestData();
 }
        protected override void AddDomainObject(object domainObject)
        {
            if (_Facade == null)
            {
                _Facade = new MaterialFacade(base.DataProvider);
            }

            this._Facade.AddWorkPlan((WorkPlan)domainObject);
        }
Exemple #7
0
 protected override int GetRowCount()
 {
     if (_facade == null)
     {
         _facade = new MaterialFacade(base.DataProvider);
     }
     return(this._facade.GetWorkPlanCountByItemCode(FormatHelper.CleanString(this.txtItemCode.Text.Trim().ToUpper()),
                                                    ViewState["bigSSCode"].ToString(),
                                                    Convert.ToInt32(ViewState["planDate"].ToString()),
                                                    this.txtMOEdit.Text.Trim().ToUpper(),
                                                    Convert.ToDecimal(ViewState["moSeq"].ToString())));
 }
Exemple #8
0
 protected override int GetRowCount()
 {
     if (_Facade == null)
     {
         _Facade = new MaterialFacade(base.DataProvider);
     }
     return(this._Facade.QueryMaterialReqStdCount(
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMaterialCodeQuery.Text)),
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(drpFirstClassQuery.SelectedValue)),
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(drpSecondClassQuery.SelectedValue)),
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(drpThirdClassQuery.SelectedValue))
                ));
 }
Exemple #9
0
 protected override object[] LoadDataSource(int inclusive, int exclusive)
 {
     if (_Facade == null)
     {
         _Facade = new MaterialFacade(base.DataProvider);
     }
     return(this._Facade.QueryMaterialReqStd(
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMaterialCodeQuery.Text)),
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(drpFirstClassQuery.SelectedValue)),
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(drpSecondClassQuery.SelectedValue)),
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(drpThirdClassQuery.SelectedValue)),
                inclusive, exclusive));
 }
Exemple #10
0
        protected override void UpdateDomainObject(object domainObject)
        {
            if (_facade == null)
            {
                _facade = new MaterialFacade(this.DataProvider);
            }

            WorkPlan workPlan = domainObject as WorkPlan;

            workPlan.MaterialStatus = MaterialWarningStatus.MaterialWarningStatus_Responsed;

            this._facade.UpdateWorkPlan(workPlan);
            this.RequestData();
        }
 protected override int GetRowCount()
 {
     if (_facade == null)
     {
         _facade = new MaterialFacade(this.DataProvider);
     }
     return(this._facade.GetMaterialIssueCount(
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtBigSSCodeGroupQuery.Text)),
                FormatHelper.TODateInt(this.txtPlanDateFromQuery.Text),
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoQuery.Text)),
                Convert.ToDecimal(this.txtMOSeqQuery.Text.Trim()),
                MaterialIssueType.MaterialIssueType_Issue
                ));
 }
Exemple #12
0
        protected override object GetEditObject()
        {
            if (_Facade == null)
            {
                _Facade = new MaterialFacade(base.DataProvider);
            }
            MaterialReqStd MaterialReqStd = this._Facade.CreateNewMaterialReqStd();

            MaterialReqStd.ItemCode       = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeEdit.Text));
            MaterialReqStd.RequestQTY     = int.Parse(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtQTY.Text)));
            MaterialReqStd.MaintainUser   = this.GetUserCode();
            MaterialReqStd.OrganizationID = int.Parse(this.DropDownListOrg.SelectedValue);
            return(MaterialReqStd);
        }
Exemple #13
0
        protected override object[] LoadDataSource(int inclusive, int exclusive)
        {
            if (_facade == null)
            {
                _facade = new MaterialFacade(base.DataProvider);
            }

            return(this._facade.QueryWorkPlanByItemCode(FormatHelper.CleanString(this.txtItemCode.Text.Trim().ToUpper()),
                                                        ViewState["bigSSCode"].ToString(),
                                                        Convert.ToInt32(ViewState["planDate"].ToString()),
                                                        this.txtMOEdit.Text.Trim().ToUpper(),
                                                        Convert.ToDecimal(ViewState["moSeq"].ToString()),
                                                        inclusive, exclusive));
        }
        protected override void DeleteDomainObjects(ArrayList domainObjects)
        {
            if (_Facade == null)
            {
                _Facade = new MaterialFacade(base.DataProvider);
            }

            ShiftModelFacade shiftModelFacade = new ShiftModelFacade(base.DataProvider);
            DBDateTime       dbDateTime       = FormatHelper.GetNowDBDateTime(base.DataProvider);

            List <WorkPlan> mKeyPartList = new List <WorkPlan>();

            WorkPlan[] deliveryNotes = (WorkPlan[])domainObjects.ToArray(typeof(WorkPlan));

            if (deliveryNotes != null)
            {
                this.DataProvider.BeginTransaction();

                try
                {
                    foreach (WorkPlan deliveryNote in deliveryNotes)
                    {
                        int shiftDay = shiftModelFacade.GetShiftDayByBigSSCode(deliveryNote.BigSSCode, dbDateTime.DateTime);
                        if (deliveryNote.PlanDate < shiftDay)
                        {
                            WebInfoPublish.Publish(this, "$if_date_cannotmodify", languageComponent1);

                            return;
                        }

                        if (deliveryNote.ActionStatus == WorkPlanActionStatus.WorkPlanActionStatus_Open || deliveryNote.ActionStatus == WorkPlanActionStatus.WorkPlanActionStatus_Close)
                        {
                            WebInfoPublish.Publish(this, "$STATUS_ERROR_DELETE", languageComponent1);
                            return;
                        }

                        this._Facade.DeleteWorkPlan(deliveryNote);
                    }

                    this.DataProvider.CommitTransaction();
                }
                catch (Exception ex)
                {
                    this.DataProvider.RollbackTransaction();

                    ExceptionManager.Raise(deliveryNotes[0].GetType(), "$Error_Delete_Domain_Object", ex);
                }
            }
        }
Exemple #15
0
 protected override int GetRowCount()
 {
     if (_facade == null)
     {
         _facade = new MaterialFacade(this.DataProvider);
     }
     return(this._facade.QueryWorkPlanCount(
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtBigSSCodeGroupQuery.Text)),
                FormatHelper.TODateInt(this.datePlanDateFromQuery.Text),
                FormatHelper.TODateInt(this.datePlanDateToQuery.Text),
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoQuery.Text)),
                this.drpActionStatusQuery.SelectedValue,
                this.drpMaterialStatusQuery.SelectedValue
                ));
 }
        protected override int GetRowCount()
        {
            if (_Facade == null)
            {
                _Facade = new MaterialFacade(base.DataProvider);
            }
            return(this._Facade.QueryWorkPlanCount(
                       FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtBigSSCodeWhere.Text)),
                       FormatHelper.TODateInt(FormatHelper.CleanString(dateVoucherDateFrom.Text)),
                       FormatHelper.TODateInt(FormatHelper.CleanString(dateVoucherDateTo.Text)),

                       FormatHelper.PKCapitalFormat(FormatHelper.CleanString(txtConditionMo.Text)),
                       drpAactionStatus.SelectedValue, drpMaterialStatus.SelectedValue
                       ));
        }
Exemple #17
0
        protected override object GetEditObject(Infragistics.WebUI.UltraWebGrid.UltraGridRow row)
        {
            if (_Facade == null)
            {
                _Facade = new MaterialFacade(base.DataProvider);
            }
            object obj = _Facade.GetMaterialReqStd(row.Cells[1].Text.ToString(), int.Parse(row.Cells[4].Text.ToString()));

            if (obj != null)
            {
                return((MaterialReqStd)obj);
            }

            return(null);
        }
 protected override object[] LoadDataSource(int inclusive, int exclusive)
 {
     if (_Facade == null)
     {
         _Facade = new MaterialFacade(base.DataProvider);
     }
     return(this._Facade.QueryWorkPlan(
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtBigSSCodeWhere.Text)),
                FormatHelper.TODateInt(FormatHelper.CleanString(dateVoucherDateFrom.Text)),
                FormatHelper.TODateInt(FormatHelper.CleanString(dateVoucherDateTo.Text)),
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(txtConditionMo.Text)),
                drpAactionStatus.SelectedValue,
                drpMaterialStatus.SelectedValue,
                inclusive, exclusive));
 }
        protected override object[] LoadDataSource(int inclusive, int exclusive)
        {
            if (_facade == null)
            {
                _facade = new MaterialFacade(this.DataProvider);
            }

            return(this._facade.QueryMaterialIssue(
                       FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtBigSSCodeGroupQuery.Text)),
                       FormatHelper.TODateInt(this.txtPlanDateFromQuery.Text),
                       FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoQuery.Text)),
                       Convert.ToDecimal(this.txtMOSeqQuery.Text.Trim()),
                       MaterialIssueType.MaterialIssueType_Issue,
                       inclusive, exclusive));
        }
        protected override object GetEditObject(Infragistics.WebUI.UltraWebGrid.UltraGridRow row)
        {
            if (_Facade == null)
            {
                _Facade = new MaterialFacade(base.DataProvider);
            }
            object obj = _Facade.GetWorkPlan(row.Cells.FromKey("BIGSSCODE").Text.ToString(), int.Parse(row.Cells.FromKey("PlanDateFrom").Text.ToString()), row.Cells.FromKey("MOCODE").Text.ToString(), decimal.Parse(row.Cells.FromKey("MOSEQ").Text.ToString()));

            if (obj != null)
            {
                return((WorkPlan)obj);
            }

            return(null);
        }
        protected override void UpdateDomainObject(object domainObject)
        {
            if (_Facade == null)
            {
                _Facade = new MaterialFacade(base.DataProvider);
            }

            WorkPlan workPlan = domainObject as WorkPlan;

            if (decimal.Parse(this.txtPlanInQTYEdit.Text) < decimal.Parse(this.txtActQty.Text))
            {
                WebInfoPublish.Publish(this, "$planqty_isnotequ_actqty", languageComponent1);
                return;
            }

            this._Facade.UpdateWorkPlan((WorkPlan)domainObject);
        }
Exemple #22
0
        protected void cmdMOExport_ServerClick(object sender, System.EventArgs e)
        {
            string downloadPhysicalPath = this.Request.PhysicalApplicationPath + @"upload\";

            if (!Directory.Exists(downloadPhysicalPath))
            {
                Directory.CreateDirectory(downloadPhysicalPath);
            }

            string filename = string.Format("{0}_{1}", FormatHelper.TODateInt(System.DateTime.Now).ToString(), FormatHelper.TOTimeInt(System.DateTime.Now).ToString());
            string filepath = string.Format(@"{0}{1}{2}", downloadPhysicalPath, filename, ".csv");

            while (File.Exists(filepath))
            {
                filename = string.Format("{0}_{1}", filename, "0");
                filepath = string.Format(@"{0}{1}{2}", downloadPhysicalPath, filename, ".csv");
            }

            StreamWriter writer = new StreamWriter(filepath, false, System.Text.Encoding.GetEncoding("GB2312"));

            writer.WriteLine("物料代码" + "," + "物料描述" + "," + "需求标准数量");

            if (_Facade == null)
            {
                _Facade = new MaterialFacade(base.DataProvider);
            }
            ArrayList array = this.gridHelper.GetCheckedRows();

            if (array.Count > 0)
            {
                ArrayList objs = new ArrayList(array.Count);

                foreach (UltraGridRow row in array)
                {
                    writer.WriteLine(ReplaceStr(row.Cells[1].Text.Trim()) + ","
                                     + ReplaceStr(row.Cells[2].Text.Trim()) + "," + ReplaceStr(row.Cells[3].ToString()));
                }
            }

            writer.Flush();
            writer.Close();

            this.DownloadFile(filename);
        }
        protected override object GetEditObject()
        {
            if (_Facade == null)
            {
                _Facade = new MaterialFacade(base.DataProvider);
            }

            if (_MoFacade == null)
            {
                _MoFacade = new MOFacade(base.DataProvider);
            }

            DBDateTime dBDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);

            object objMo = _MoFacade.GetMO(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOEdit.Text)));

            WorkPlan workPlan = (WorkPlan)this._Facade.GetWorkPlan(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtBigSSCodeGroup.Text)),
                                                                   FormatHelper.TODateInt(FormatHelper.CleanString(this.dateDateFrom.Date_String)),
                                                                   FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOEdit.Text)),
                                                                   Convert.ToDecimal(FormatHelper.CleanString(this.txtMOSeqEdit.Text)));

            if (workPlan == null)
            {
                workPlan                = _Facade.CreateNewWorkPlan();
                workPlan.PlanDate       = FormatHelper.TODateInt(FormatHelper.CleanString(this.dateDateFrom.Date_String));
                workPlan.BigSSCode      = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtBigSSCodeGroup.Text));
                workPlan.MoCode         = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOEdit.Text));
                workPlan.MoSeq          = Convert.ToDecimal(FormatHelper.CleanString(this.txtMOSeqEdit.Text));
                workPlan.ItemCode       = ((BenQGuru.eMES.Domain.MOModel.MO)objMo).ItemCode;
                workPlan.ActQty         = 0;
                workPlan.MaterialQty    = 0;
                workPlan.ActionStatus   = WorkPlanActionStatus.WorkPlanActionStatus_Init;
                workPlan.MaterialStatus = MaterialWarningStatus.MaterialWarningStatus_No;
            }

            workPlan.PlanSeq       = int.Parse(FormatHelper.CleanString(this.txtMactureSeq.Text));
            workPlan.PlanQty       = decimal.Parse(FormatHelper.CleanString(this.txtPlanInQTYEdit.Text));
            workPlan.PlanStartTime = FormatHelper.TOTimeInt(this.timeFrom.Text);
            workPlan.MaintainUser  = this.GetUserCode();
            workPlan.MaintainDate  = dBDateTime.DBDate;
            workPlan.MaintainTime  = dBDateTime.DBTime;

            return(workPlan);
        }
Exemple #24
0
        protected override object GetEditObject(Infragistics.WebUI.UltraWebGrid.UltraGridRow row)
        {
            if (_facade == null)
            {
                _facade = new MaterialFacade(this.DataProvider);
            }
            object obj = _facade.GetWorkPlan(row.Cells.FromKey("BigSSCode").Text.ToString(),
                                             FormatHelper.TODateInt(row.Cells.FromKey("MaterialPlanDate").Text.ToString()),
                                             row.Cells.FromKey("MoCode").Text.ToString().Trim(),
                                             Convert.ToDecimal(row.Cells.FromKey("MoSeq").Text.ToString())
                                             );

            if (obj != null)
            {
                return((WorkPlan)obj);
            }

            return(null);
        }
        protected override void AddDomainObject(object domainObject)
        {
            if (_facade == null)
            {
                _facade = new MaterialFacade(this.DataProvider);
            }
            DBDateTime    dBDateTime    = FormatHelper.GetNowDBDateTime(this.DataProvider);
            MaterialIssue materialIssue = domainObject as MaterialIssue;

            this._facade.AddMaterialIssue(materialIssue);
            WorkPlan workPlan = (WorkPlan)_facade.GetWorkPlan(materialIssue.BigSSCode, materialIssue.PlanDate, materialIssue.MoCode, materialIssue.MoSeq);

            if (workPlan != null)
            {
                workPlan.MaterialStatus = MaterialWarningStatus.MaterialWarningStatus_Responsed;
                workPlan.PromiseTime    = dBDateTime.DBTime;
                _facade.UpdateWorkPlan(workPlan);
            }
            this.txtRationNumberEdit.Text = string.Empty;
        }
Exemple #26
0
        protected override object[] LoadDataSource(int inclusive, int exclusive)
        {
            if (_facade == null)
            {
                _facade = new MaterialFacade(this.DataProvider);
            }
            if (!QuerydateInput())
            {
                return(null);
            }

            return(this._facade.QueryWorkPlan(
                       FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtBigSSCodeGroupQuery.Text)),
                       FormatHelper.TODateInt(this.datePlanDateFromQuery.Text),
                       FormatHelper.TODateInt(this.datePlanDateToQuery.Text),
                       FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoQuery.Text)),
                       this.drpActionStatusQuery.SelectedValue,
                       this.drpMaterialStatusQuery.SelectedValue,
                       inclusive, exclusive));
        }
        protected override object GetEditObject()
        {
            if (_facade == null)
            {
                _facade = new MaterialFacade(this.DataProvider);
            }
            DBDateTime    dBDateTime    = FormatHelper.GetNowDBDateTime(this.DataProvider);
            MaterialIssue materialIssue = this._facade.CreateNewMaterialIssue();

            materialIssue.PlanDate     = FormatHelper.TODateInt(this.txtPlanDateFromQuery.Text);
            materialIssue.BigSSCode    = FormatHelper.CleanString(this.txtBigSSCodeGroupQuery.Text.Trim().ToUpper());
            materialIssue.MoCode       = FormatHelper.CleanString(this.txtMoQuery.Text.Trim().ToUpper());
            materialIssue.MoSeq        = Convert.ToDecimal(this.txtMOSeqQuery.Text.Trim());
            materialIssue.IssueSEQ     = _facade.GetMaterialIssueMaxIssueSEQ(materialIssue.BigSSCode, materialIssue.PlanDate, materialIssue.MoCode, materialIssue.MoSeq);
            materialIssue.IssueQTY     = Convert.ToDecimal(this.txtRationNumberEdit.Text);
            materialIssue.IssueType    = MaterialIssueType.MaterialIssueType_Issue;
            materialIssue.IssueStatus  = MaterialIssueStatus.MaterialIssueStatus_Delivered;
            materialIssue.MaintainUser = this.GetUserCode();
            materialIssue.MaintainDate = dBDateTime.DBDate;
            materialIssue.MaintainTime = dBDateTime.DBTime;

            return(materialIssue);
        }
Exemple #28
0
        protected void cmdImport_ServerClick(object sender, System.EventArgs e)
        {
            this._Facade = new MaterialFacade(this.DataProvider);
            string errorItemCode = string.Empty;
            string fileName      = FileLoadProcess.UploadFile2ServerUploadFolder(this.Page, this.fileInit, null);

            if (fileName == null)
            {
                WebInfoPublish.Publish(this, "$Error_UploadFileIsEmpty", this.languageComponent1);
                return;
            }
            if (!fileName.ToLower().EndsWith(".csv"))
            {
                WebInfoPublish.Publish(this, "$Error_UploadFileTypeError", this.languageComponent1);
                return;
            }

            this.ViewState.Add("UploadedFileName", fileName);

            if (items == null)
            {
                items = GetAllItem();
                if (items == null)
                {
                    return;
                }
            }
            if (items == null || items.Length == 0)
            {
                return;
            }

            int    successNum = 0;
            int    failNum    = 0;
            string objValue   = string.Empty;


            string orgID = GlobalVariables.CurrentOrganizations.First().OrganizationID.ToString();

            string mUser = GetUserCode();

            for (int i = 0; i < items.Length; i++)
            {
                string itemCode   = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(GetFieldValue(items[i], "ITEMCODE")));
                string requestQty = FormatHelper.CleanString(GetFieldValue(items[i], "RequestQTY"));

                if (string.Compare(GetFieldValue(items[i], "EAttribute1"), "OK", true) == 0 ||
                    string.Compare(GetFieldValue(items[i], "EAttribute1"), "Insert", true) == 0)
                {
                    object         obj = _Facade.GetMaterialReqStd(itemCode, int.Parse(orgID));
                    MaterialReqStd newMaterialReqStd = new MaterialReqStd();
                    if (string.Compare(GetFieldValue(items[i], "EAttribute1"), "Insert", true) == 0)
                    {
                        newMaterialReqStd.ItemCode       = itemCode;
                        newMaterialReqStd.OrganizationID = int.Parse(orgID);
                        newMaterialReqStd.RequestQTY     = int.Parse(requestQty);
                        newMaterialReqStd.MaintainUser   = mUser;
                        _Facade.AddMaterialReqStd(newMaterialReqStd);
                    }
                    else
                    {
                        MaterialReqStd objMaterialReqStd = obj as MaterialReqStd;
                        objValue = requestQty.ToString();
                        if (objValue != string.Empty)
                        {
                            objMaterialReqStd.RequestQTY = int.Parse(objValue);
                        }
                        objMaterialReqStd.MaintainUser = mUser;
                        if (string.Compare(GetFieldValue(items[i], "EAttribute1"), "OK", true) == 0)
                        {
                            _Facade.UpdateMaterialReqStd(objMaterialReqStd);
                        }
                    }
                    successNum++;
                }
                else
                {
                    failNum++;
                    errorItemCode += GetFieldValue(items[i], "ITEMCODE").ToString() + "\\n";;
                }
            }

            errorItemCode = "\\n导入失败的料号:\\n" + errorItemCode;

            string strMessage = "导入完成: 成功" + successNum + "笔, 失败" + failNum + "笔\\n" + errorItemCode;
            string alertInfo  =
                string.Format("<script language=javascript>alert('{0}');</script>", strMessage);

            if (!this.IsClientScriptBlockRegistered("ImportAlert"))
            {
                this.RegisterClientScriptBlock("ImportAlert", alertInfo);
            }
            items = null;
        }
Exemple #29
0
        private void ValidateItems()
        {
            if (items == null || items.Length == 0)
            {
                return;
            }

            CultureInfo culture = new System.Globalization.CultureInfo("en-US");

            for (int i = 0; i < items.Length; i++)
            {
                string result = string.Empty;
                object item   = items[i];

                this._ItemFacade = new ItemFacade(this.DataProvider);

                string itemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(GetFieldValue(items[i], "ITEMCODE")));
                Int32  orgID    = GlobalVariables.CurrentOrganizations.First().OrganizationID;
                object obj      = _ItemFacade.GetMaterial(itemCode, orgID);
                if (obj == null)
                {
                    result = "物料代码不存在";
                }
                else
                {
                    this._Facade = new MaterialFacade(this.DataProvider);

                    object objExit = _Facade.GetMaterialReqStd(itemCode, orgID);

                    if (objExit == null)
                    {
                        result = "Insert";
                    }
                }

                string requestQty = GetFieldValue(items[i], "RequestQTY");
                if (requestQty != string.Empty)
                {
                    try
                    {
                        int numRequestQty = int.Parse(requestQty);
                    }
                    catch
                    {
                        result = string.Format("{0};数量必须是数字", result);
                    }
                }

                if (result != string.Empty && result != null)
                {
                    int j = result.IndexOf(";");
                    if (j == 0)
                    {
                        result = result.Substring(1, result.Length - 1);
                    }
                }

                if (result == string.Empty)
                {
                    result = "OK";
                }

                SetFieldValue(item, "EAttribute1", result);
            }
        }
        protected override bool ValidateInput()
        {
            PageCheckManager manager = new PageCheckManager();

            manager.Add(new DateCheck(this.lblDate, this.dateDateFrom.Text, true));
            manager.Add(new LengthCheck(lblBigSSCodeGroup, txtBigSSCodeGroup, 40, true));
            manager.Add(new LengthCheck(lblMOEdit, txtMOEdit, 40, true));
            manager.Add(new LengthCheck(lblMactureSeq, txtMactureSeq, 10, true));
            manager.Add(new LengthCheck(lblMOSeqEdit, txtMOSeqEdit, 10, true));
            manager.Add(new DecimalCheck(lblPlanInQTYEdit, txtPlanInQTYEdit, 0, 9999999999, true));


            manager.Add(new TimeRangeCheck(this.lblPlanInStartDateEdit, this.timeFrom.Text, this.timeFrom.Text, true));

            if (this.txtMOSeqEdit.Text.Trim().Length > 0)
            {
                manager.Add(new NumberCheck(lblMOSeqEdit, txtMOSeqEdit, 0, 9999999999, true));
            }

            if (this.txtMactureSeq.Text.Trim().Length > 0)
            {
                manager.Add(new NumberCheck(lblMactureSeq, txtMactureSeq, 0, 9999999999, true));
            }

            if (!manager.Check())
            {
                WebInfoPublish.Publish(this, manager.CheckMessage, this.languageComponent1);
                return(false);
            }

            if (_MoFacade == null)
            {
                _MoFacade = new MOFacade(base.DataProvider);
            }

            object objMo = _MoFacade.GetMO(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOEdit.Text)));

            if (objMo == null)
            {
                WebInfoPublish.Publish(this, "$CS_MO_Not_Exist", languageComponent1);
                return(false);
            }

            if (_Facade == null)
            {
                _Facade = new MaterialFacade(base.DataProvider);
            }

            ShiftModelFacade shiftModelFacade = new ShiftModelFacade(base.DataProvider);
            DBDateTime       dbDateTime       = FormatHelper.GetNowDBDateTime(base.DataProvider);

            WorkPlan GetWorkPlanByKeys = (WorkPlan)_Facade.GetWorkPlan(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(txtBigSSCodeGroup.Text)),
                                                                       FormatHelper.TODateInt(FormatHelper.CleanString(this.dateDateFrom.Date_String)),
                                                                       FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOEdit.Text)),
                                                                       int.Parse(FormatHelper.CleanString(this.txtMOSeqEdit.Text)));

            WorkPlan GetWorkPlanByUnipues = (WorkPlan)_Facade.GetWorkPlan(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(txtBigSSCodeGroup.Text)),
                                                                          FormatHelper.TODateInt(FormatHelper.CleanString(this.dateDateFrom.Date_String)),
                                                                          int.Parse(FormatHelper.CleanString(this.txtMactureSeq.Text)));

            if (GetWorkPlanByKeys == null && GetWorkPlanByUnipues != null)
            {
                WebInfoPublish.PublishInfo(this, "$date__isunique", languageComponent1);
                return(false);
            }

            if (GetWorkPlanByKeys != null && GetWorkPlanByUnipues != null)
            {
                if (GetWorkPlanByKeys.BigSSCode != GetWorkPlanByUnipues.BigSSCode ||
                    GetWorkPlanByKeys.PlanDate != GetWorkPlanByUnipues.PlanDate ||
                    GetWorkPlanByKeys.MoCode != GetWorkPlanByUnipues.MoCode ||
                    GetWorkPlanByKeys.MoSeq != GetWorkPlanByUnipues.MoSeq)
                {
                    WebInfoPublish.PublishInfo(this, "$date__isunique", languageComponent1);
                    return(false);
                }
            }

            int shiftDay = shiftModelFacade.GetShiftDayByBigSSCode(
                FormatHelper.PKCapitalFormat(FormatHelper.CleanString(txtBigSSCodeGroup.Text)),
                dbDateTime.DateTime);

            if (FormatHelper.TODateInt(FormatHelper.CleanString(this.dateDateFrom.Date_String)) < shiftDay)
            {
                WebInfoPublish.PublishInfo(this, "$if_date_cannotmodify", languageComponent1);
                return(false);
            }

            return(true);
        }