コード例 #1
0
        protected void MonthYear_Combo_Init(object sender, EventArgs e)
        {
            ASPxComboBox combo = sender as ASPxComboBox;

            combo.DataSource = POClass.MRPMonthYearTable();

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "PK";
            l_value.Width     = 0;
            combo.Columns.Add(l_value);

            ListBoxColumn l_text = new ListBoxColumn();

            l_text.FieldName = "MRPMonth";
            l_text.Caption   = "Month";
            combo.Columns.Add(l_text);

            ListBoxColumn l_text2 = new ListBoxColumn();

            l_text2.FieldName = "MRPYear";
            l_text2.Caption   = "Year";
            combo.Columns.Add(l_text2);

            combo.ValueField = "PK";
            combo.TextField  = "MRPMonth";
            combo.DataBind();
            combo.TextFormatString = "{1} {2}";
        }
コード例 #2
0
        protected void Code_Init(object sender, EventArgs e)
        {
            ASPxComboBox combo = sender as ASPxComboBox;

            combo.DataSource = POClass.PO_EntityCode_Table();

            ListBoxColumn lv = new ListBoxColumn();

            lv.FieldName = "ID";
            lv.Caption   = "Code";
            lv.Width     = 50;
            combo.Columns.Add(lv);

            ListBoxColumn lt = new ListBoxColumn();

            lt.FieldName = "NAME";
            lt.Caption   = "Entity";
            lt.Width     = 250;
            combo.Columns.Add(lt);

            combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
            combo.ValueField     = "ID";
            combo.TextField      = "NAME";
            combo.DataBind();

            GridViewEditItemTemplateContainer container = ((ASPxComboBox)sender).NamingContainer as GridViewEditItemTemplateContainer;

            if (!container.Grid.IsNewRowEditing)
            {
                combo.Value = DataBinder.Eval(container.DataItem, "Code").ToString();
                combo.Text  = DataBinder.Eval(container.DataItem, "Code").ToString();
            }
        }
コード例 #3
0
        protected void Vendor_Init(object sender, EventArgs e)
        {
            ASPxComboBox combo = sender as ASPxComboBox;

            combo.DataSource = POClass.VendTableTable();;

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "ACCOUNTNUM";
            l_value.Caption   = "Vendor Code";
            l_value.Width     = 100;
            combo.Columns.Add(l_value);

            ListBoxColumn l_text = new ListBoxColumn();

            l_text.FieldName = "NAME";
            l_text.Caption   = "Vendor Name";
            l_text.Width     = 350;
            combo.Columns.Add(l_text);

            combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
            combo.ValueField     = "ACCOUNTNUM";
            combo.TextField      = "NAME";
            combo.DataBind();
            //combo.TextFormatString = "{0}{1}";
        }
コード例 #4
0
        private void VendorCombo_Data()
        {
            ASPxComboBox combo = VendorCombo as ASPxComboBox;

            combo.Columns.Clear();
            combo.DataSource = POClass.VendTableTable();;

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "ACCOUNTNUM";
            l_value.Caption   = "Vendor Code";
            l_value.Width     = 100;
            combo.Columns.Add(l_value);

            ListBoxColumn l_text = new ListBoxColumn();

            l_text.FieldName = "NAME";
            l_text.Caption   = "Vendor Name";
            l_text.Width     = 350;
            combo.Columns.Add(l_text);

            combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
            combo.ValueField     = "ACCOUNTNUM";
            combo.TextField      = "NAME";
            combo.DataBind();
        }
コード例 #5
0
        private void SiteCombo_Data()
        {
            ASPxComboBox combo = SiteCombo as ASPxComboBox;

            combo.Columns.Clear();
            combo.DataSource = POClass.InventSiteTable(entity);

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "SITEID";
            l_value.Caption   = "Site ID";
            combo.Columns.Add(l_value);

            ListBoxColumn l_text = new ListBoxColumn();

            l_text.FieldName = "NAME";
            l_text.Width     = 200;
            l_text.Caption   = "Name";
            combo.Columns.Add(l_text);

            combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
            combo.TextField      = "NAME";
            combo.ValueField     = "SITEID";
            combo.DataBind();
        }
コード例 #6
0
        private void WarehouseCombo_Data()
        {
            ASPxComboBox combo = WarehouseCombo as ASPxComboBox;

            combo.Columns.Clear();

            combo.Value      = "";
            combo.DataSource = POClass.InventSiteWarehouseTable(SiteCombo.Text.ToString());

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "warehouse";
            l_value.Caption   = "Warehouse";
            combo.Columns.Add(l_value);

            ListBoxColumn l_text = new ListBoxColumn();

            l_text.FieldName = "NAME";
            l_text.Caption   = "Name";
            combo.Columns.Add(l_text);

            combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
            combo.TextField      = "NAME";
            combo.ValueField     = "warehouse";
            combo.DataBind();
            combo.ClientEnabled = true;
        }
コード例 #7
0
        private void LocationCombo_Data()
        {
            ASPxComboBox combo = LocationCombo as ASPxComboBox;

            combo.Columns.Clear();

            combo.Value = "";

            combo.DataSource = POClass.InventSiteLocationTable(WarehouseCombo.Text.ToString());

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "LocationCode";
            combo.Columns.Add(l_value);

            //ListBoxColumn l_text = new ListBoxColumn();
            //l_text.FieldName = "NAME";
            //Location.Columns.Add(l_text);

            //Location.TextField = "NAME";
            combo.ValueField = "LocationCode";
            combo.DataBind();
            combo.TextFormatString = "{0}";
            combo.ClientEnabled    = true;
        }
コード例 #8
0
        protected void OK_SUBMIT_Click(object sender, EventArgs e)
        {
            SqlConnection  conn = new SqlConnection(GlobalClass.SQLConnString());
            DataTable      dt   = new DataTable();
            SqlCommand     cmd  = null;
            SqlDataAdapter adp;
            DataTable      dt1  = new DataTable();
            SqlCommand     cmd1 = null;
            SqlDataAdapter adp1;

            ponumber = gridCreatedPO.GetRowValues(gridCreatedPO.FocusedRowIndex, "PONumber").ToString();

            string qry = "SELECT tbl_POCreation_Details.* FROM tbl_POCreation_Details WHERE (PONumber = '" + ponumber + "')";

            cmd            = new SqlCommand(qry);
            cmd.Connection = conn;
            adp            = new SqlDataAdapter(cmd);
            adp.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow row in dt.Rows)
                {
                    if (row["TaxGroup"].ToString().Trim() == "")
                    {
                        ModalPopupExtenderLoading.Hide();
                        POListNotify.HeaderText     = "Error...";
                        POListNotifyLbl.Text        = "Details has no Tax Group.";
                        POListNotify.ShowOnPageLoad = true;
                        return;
                    }
                    if (row["TaxItemGroup"].ToString().Trim() == "")
                    {
                        ModalPopupExtenderLoading.Hide();
                        POListNotify.HeaderText     = "Error...";
                        POListNotifyLbl.Text        = "Details has no Tax Item Group.";
                        POListNotify.ShowOnPageLoad = true;
                        return;
                    }
                }
            }
            else
            {
                ModalPopupExtenderLoading.Hide();
                POListNotify.HeaderText     = "Error...";
                POListNotifyLbl.Text        = "No Data to submit.";
                POListNotify.ShowOnPageLoad = true;
                return;
            }
            dt.Clear();
            conn.Close();

            //Submit_Method();

            //POClass.SubmitToAX(ponumber, POListNotify, POListNotifyLbl, ModalPopupExtenderLoading);

            POClass.SubmitToAXTable(ponumber, Session["UserCompleteName"].ToString(), POListNotify, POListNotifyLbl, ModalPopupExtenderLoading);


            Bind_PO_List();
        }
コード例 #9
0
        private void Bind_PO_List()
        {
            DataTable dtTable = POClass.PO_Created_List();

            gridCreatedPO.DataSource   = dtTable;
            gridCreatedPO.KeyFieldName = "PK";
            gridCreatedPO.DataBind();
        }
コード例 #10
0
        private void TermsCombo_Data()
        {
            //string query = "SELECT PAYMTERMID, DESCRIPTION FROM[dbo].[vw_AXVendTable] WHERE [ACCOUNTNUM] = '" + VendorCombo.Text.ToString() + "'";
            string       query = "SELECT dbo.vw_AXVendTable.PAYMTERMID, ISNULL(dbo.vw_AXPaymTerm.DESCRIPTION, N'') AS DESCRIPTION, dbo.vw_AXVendTable.ACCOUNTNUM FROM dbo.vw_AXVendTable LEFT OUTER JOIN  dbo.vw_AXPaymTerm ON dbo.vw_AXVendTable.PAYMTERMID = dbo.vw_AXPaymTerm.PAYMTERMID WHERE(dbo.vw_AXVendTable.ACCOUNTNUM = '" + VendorCombo.Text.ToString() + "')";
            ASPxComboBox combo = TermsCombo as ASPxComboBox;

            combo.Columns.Clear();

            SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());

            conn.Open();
            SqlCommand cmd = new SqlCommand(query, conn);
            //SqlDataReader reader = cmd.ExecuteReader();
            //while (reader.Read())
            //{
            //    combo.Value = reader["PAYMTERMID"].ToString();
            //}
            //reader.Close();

            string        value = "", text = "";
            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                value = reader["PAYMTERMID"].ToString();
                text  = reader["DESCRIPTION"].ToString();
            }
            reader.Close();
            conn.Close();

            combo.DataSource = null;
            combo.DataSource = POClass.PaymTermTable();

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "PAYMTERMID";
            l_value.Width     = 100;
            combo.Columns.Add(l_value);

            ListBoxColumn l_text = new ListBoxColumn();

            l_text.FieldName = "DESCRIPTION";
            l_text.Width     = 250;
            combo.Columns.Add(l_text);

            combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
            combo.ValueField     = "PAYMTERMID";
            combo.TextField      = "DESCRIPTION";
            combo.DataBind();
            combo.ClientEnabled = true;

            combo.Value = value;
            combo.Text  = value;

            combo.IsValid = (!string.IsNullOrEmpty(value)) ? true : false;

            TermsLbl.Text = text;   //set text label of terms
        }
コード例 #11
0
        private void BindTable(string docnumber, int month, string year, ArrayList prod)
        {
            //if (month == -1) return;
            int checkedBox = 0;

            if (CheckboxAll.Checked)
            {
                checkedBox = 1;
            }

            MainGrid_PO.DataSource   = POClass.POSelecetedItemTable(checkedBox, docnumber, month, year, prod);
            MainGrid_PO.KeyFieldName = "PK";
            MainGrid_PO.DataBind();
        }
コード例 #12
0
        private void BindGrid(string creatorkey)
        {
            DataTable dtRecord = POClass.POCreate_TmpTable(creatorkey);

            POCreateGrid.DataSource   = dtRecord;
            POCreateGrid.KeyFieldName = "PK";
            POCreateGrid.DataBind();

            //for row updating
            DataSet ds = new DataSet();

            ds.Tables.Add(dtRecord);
            Session["DataSet"] = ds;
        }
コード例 #13
0
        public string PoNumber()
        {
            string SerailNO    = "";
            var    LPONoResult = webServices.Post(new SingleStringValueResult(), "Quotation/QuotaNumber");

            if (LPONoResult.StatusCode == System.Net.HttpStatusCode.Accepted)
            {
                if (LPONoResult.Data != "[]")
                {
                    string LPNo = (new JavaScriptSerializer()).Deserialize <string>(LPONoResult.Data);


                    SerailNO = LPNo.Substring(4, 8);

                    SerailNO = SerailNO.ToString().Substring(0, 6);


                    string TotdayNumber = POClass.PONumber().Substring(0, 6);
                    int    Counts       = 0;
                    if (SerailNO == TotdayNumber)
                    {
                        Counts = Convert.ToInt32(LPNo.Substring(10, 2)) + 1;

                        if (Counts.ToString().Length == 1)
                        {
                            SerailNO = "QUO-" + TotdayNumber + "0" + Counts;
                        }
                        else
                        {
                            SerailNO = "QUO-" + TotdayNumber + Counts.ToString();
                        }
                    }
                    else
                    {
                        SerailNO = "QUO-" + POClass.PONumber();
                    }
                }
                else
                {
                    SerailNO = "QUO-" + POClass.PONumber();
                }
            }
            else
            {
                SerailNO = "QUO-" + POClass.PONumber();
            }

            return(SerailNO);
        }
コード例 #14
0
        protected void TaxGroup_Init(object sender, EventArgs e)
        {
            ASPxComboBox comboBox = (ASPxComboBox)sender;

            comboBox.DataSource = POClass.TaxGroupTable();

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "TaxGroup";
            comboBox.Columns.Add(l_value);

            comboBox.ValueField = "TaxGroup";
            comboBox.TextField  = "TaxGroup";
            comboBox.DataBind();
        }
コード例 #15
0
        private void CurrencyCombo_Data()
        {
            ASPxComboBox combo = CurrencyCombo as ASPxComboBox;

            combo.Columns.Clear();

            string query = "SELECT dbo.vw_AXVendTable.VENDGROUP, dbo.vw_AXVendTable.PAYMTERMID, dbo.vw_AXVendTable.CURRENCY, dbo.vw_AXCurrency.TXT FROM dbo.vw_AXVendTable LEFT OUTER JOIN dbo.vw_AXCurrency ON dbo.vw_AXVendTable.CURRENCY = dbo.vw_AXCurrency.CURRENCYCODE WHERE[ACCOUNTNUM] = '" + VendorCombo.Text.ToString() + "'";

            SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());

            conn.Open();
            SqlCommand    cmd = new SqlCommand(query, conn);
            string        value = "", text = "";
            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                value = reader["CURRENCY"].ToString();
                text  = reader["TXT"].ToString();
            }
            reader.Close();
            conn.Close();

            combo.DataSource = POClass.CurrencyTable();;

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "CURRENCYCODE";
            l_value.Caption   = "Currency Code";
            l_value.Width     = 100;
            combo.Columns.Add(l_value);

            ListBoxColumn l_text = new ListBoxColumn();

            l_text.FieldName = "TXT";
            l_text.Width     = 250;
            l_text.Caption   = "Currency Name";
            combo.Columns.Add(l_text);

            combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
            combo.ValueField     = "CURRENCYCODE";
            combo.TextField      = "TXT";
            combo.DataBind();
            combo.ClientEnabled = true;

            combo.Value = value;
            combo.Text  = value + ";" + text;
        }
コード例 #16
0
        protected void LocationCallback_Callback(object sender, CallbackEventArgsBase e)
        {
            Location.Value = "";

            Location.DataSource = POClass.InventSiteLocationTable(Warehouse.Text.ToString());

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "LocationCode";
            Location.Columns.Add(l_value);

            //ListBoxColumn l_text = new ListBoxColumn();
            //l_text.FieldName = "NAME";
            //Location.Columns.Add(l_text);

            //Location.TextField = "NAME";
            Location.ValueField = "LocationCode";
            Location.DataBind();
            Location.TextFormatString = "{0}";
            Location.ClientEnabled    = true;
        }
コード例 #17
0
        protected void TaxItemGroup_Init(object sender, EventArgs e)
        {
            ASPxComboBox combo = (ASPxComboBox)sender;

            combo.DataSource = POClass.TaxItemGroupTable();

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "TaxItemGroup";
            combo.Columns.Add(l_value);

            combo.ValueField = "TaxItemGroup";
            combo.TextField  = "TaxItemGroup";
            combo.DataBind();

            GridViewEditItemTemplateContainer container = combo.NamingContainer as GridViewEditItemTemplateContainer;

            if (!container.Grid.IsNewRowEditing)
            {
                combo.Value = DataBinder.Eval(container.DataItem, "TaxItemGroup").ToString();
            }
        }
コード例 #18
0
        protected void MOPNum_Combo_Callback(object sender, CallbackEventArgsBase e)
        {
            ASPxComboBox combo = sender as ASPxComboBox;

            string monthyear = MonthYear_Combo.Text;

            if (!string.IsNullOrEmpty(monthyear))
            {
                string[] strarr = monthyear.Split(' ');
                string   month  = strarr[0].ToString();
                string   year   = strarr[1].ToString();

                int monthindex = Convertion.MONTH_TO_INDEX(month);

                combo.DataSource = POClass.DocumentNumber_By_Month_Year(monthindex, year);
            }
            else
            {
                combo.DataSource = POClass.DocumentNumber_By_Month_Year(0, "");
            }

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "PK";
            l_value.Caption   = "PK";
            l_value.Width     = 0;
            combo.Columns.Add(l_value);

            ListBoxColumn l_text = new ListBoxColumn();

            l_text.FieldName = "DocumentNumber";
            l_text.Caption   = "Document Number";
            combo.Columns.Add(l_text);

            combo.Value = "PK";
            combo.Text  = "DocumentNumber";
            combo.DataBind();
            combo.TextFormatString = "{1}";
        }
コード例 #19
0
        protected void Site_Init(object sender, EventArgs e)
        {
            string query = "SELECT DISTINCT dbo.tbl_MRP_List.EntityCode FROM dbo.tbl_POCreation_Tmp LEFT OUTER JOIN dbo.tbl_MRP_List ON dbo.tbl_POCreation_Tmp.MOPNumber = dbo.tbl_MRP_List.DocNumber WHERE UserKey = '" + Session["CreatorKey"].ToString() + "'";

            SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());

            conn.Open();
            SqlCommand    cmd    = new SqlCommand(query, conn);
            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                entitycode = reader[0].ToString();
            }

            ASPxComboBox combo = sender as ASPxComboBox;

            combo.DataSource = POClass.InventSiteTable(entitycode);

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "SITEID";
            l_value.Caption   = "Site ID";
            combo.Columns.Add(l_value);

            ListBoxColumn l_text = new ListBoxColumn();

            l_text.FieldName = "NAME";
            l_text.Width     = 200;
            l_text.Caption   = "Name";
            combo.Columns.Add(l_text);

            combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
            combo.TextField      = "NAME";
            combo.ValueField     = "SITEID";
            combo.DataBind();
        }
コード例 #20
0
        protected void MOPNum_Combo_Init(object sender, EventArgs e)
        {
            ASPxComboBox combo = sender as ASPxComboBox;

            combo.DataSource = POClass.DocumentNumber_By_Month_Year(0, "");

            ListBoxColumn l_text = new ListBoxColumn();

            l_text.FieldName = "DocumentNumber";
            l_text.Caption   = "Document Number";
            l_text.Width     = 150;
            combo.Columns.Add(l_text);

            ListBoxColumn lt2 = new ListBoxColumn();

            lt2.FieldName = "EntityCode";
            lt2.Width     = 0;
            combo.Columns.Add(lt2);

            ListBoxColumn lt3 = new ListBoxColumn();

            lt3.FieldName = "Entity";
            lt3.Width     = 300;
            combo.Columns.Add(lt3);

            ListBoxColumn lt4 = new ListBoxColumn();

            lt4.FieldName = "BU";
            lt4.Caption   = "SSU/BU";
            lt4.Width     = 300;
            combo.Columns.Add(lt4);

            combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
            combo.ValueField     = "DocumentNumber";
            combo.TextField      = "DocumentNumber";
            combo.DataBind();
        }
コード例 #21
0
        protected void WarehouseCallback_Callback(object sender, CallbackEventArgsBase e)
        {
            Warehouse.Value      = "";
            Warehouse.DataSource = POClass.InventSiteWarehouseTable(Site.Text.ToString());

            ListBoxColumn l_value = new ListBoxColumn();

            l_value.FieldName = "warehouse";
            l_value.Caption   = "Warehouse";
            Warehouse.Columns.Add(l_value);

            ListBoxColumn l_text = new ListBoxColumn();

            l_text.FieldName = "NAME";
            l_text.Caption   = "Name";
            l_text.Width     = 200;
            Warehouse.Columns.Add(l_text);

            Warehouse.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
            Warehouse.TextField      = "NAME";
            Warehouse.ValueField     = "warehouse";
            Warehouse.DataBind();
            Warehouse.ClientEnabled = true;
        }
コード例 #22
0
 private void BindGrid()
 {
     POGrid.DataSource   = POClass.PO_Uploading_Table();
     POGrid.KeyFieldName = "PK";
     POGrid.DataBind();
 }
コード例 #23
0
        protected void Submit_Click(object sender, EventArgs e)
        {
            bool         cancel = false;
            ASPxGridView grid   = POAddEditGrid as ASPxGridView;

            for (int i = 0; i < grid.VisibleRowCount; i++)
            {
                object taxgroup     = grid.GetRowValues(i, "TaxGroup");
                object taxitemgroup = grid.GetRowValues(i, "TaxItemGroup");
                object identifier   = grid.GetRowValues(i, "Identifier");
                object cip          = grid.GetRowValues(i, "CapexCIP");
                object prodcat      = grid.GetRowValues(i, "ProdCat");

                if (string.IsNullOrEmpty(taxgroup.ToString()) || string.IsNullOrEmpty(taxitemgroup.ToString()))
                {
                    cancel = true;
                    break;
                }

                if (identifier.ToString() == "4")
                {
                    MRPClass.PrintString(prodcat.ToString());
                    MRPClass.PrintString(string.IsNullOrEmpty(cip.ToString()).ToString());
                    if (prodcat.ToString() != "CIP")
                    {
                        if (string.IsNullOrEmpty(cip.ToString()))
                        {
                            cancel = true;
                            break;
                        }
                    }
                }
            }
            if (cancel)//if empty taxgroup this is true
            {
                ModalPopupExtenderLoading.Hide();
                PONotify.HeaderText     = "Alert";
                PONotifyLbl.Text        = "Some selected items are empty.";
                PONotify.ShowOnPageLoad = true;
            }
            else
            {
                if (grid.VisibleRowCount > 0)
                {
                    //Submit_Method();
                    //POClass.SubmitToAX(ponumber, PONotify, PONotifyLbl, ModalPopupExtenderLoading);

                    POClass.SubmitToAXTable(ponumber, Session["UserCompleteName"].ToString(), PONotify, PONotifyLbl, ModalPopupExtenderLoading);
                }

                else
                {
                    ModalPopupExtenderLoading.Hide();

                    Submit.ClientEnabled    = false;
                    PONotify.HeaderText     = "Alert";
                    PONotifyLbl.Text        = "No data to submit";
                    PONotify.ShowOnPageLoad = true;
                }
            }

            ScriptManager.RegisterStartupScript(this.Page, typeof(string), "Resize", "changeWidth.resizeWidth();", true);
            BindData();
        }
コード例 #24
0
 private void BindGrid()
 {
     POAddEditGrid.DataSource   = POClass.PO_AddEdit_Table(ponumber);
     POAddEditGrid.KeyFieldName = "PK";
     POAddEditGrid.DataBind();
 }
コード例 #25
0
 private void BindInfo()
 {
     InfoGrid.DataSource   = POClass.PO_Info_Table();
     InfoGrid.KeyFieldName = "PK";
     InfoGrid.DataBind();
 }
コード例 #26
0
        public ActionResult Create()
        {
            try
            {
                string SerailNO      = "";
                string AlreadyNumber = "";

                var LPONoResult = webServices.Post(new SingleStringValueResult(), "LPO/LPOGetPONumber");
                if (LPONoResult.StatusCode == System.Net.HttpStatusCode.Accepted)
                {
                    if (LPONoResult.Data != "[]")
                    {
                        string LPNo = (new JavaScriptSerializer()).Deserialize <string>(LPONoResult.Data);

                        SerailNO = LPNo.Substring(4, 8);
                        SerailNO = SerailNO.ToString().Substring(0, 6);

                        string TotdayNumber = POClass.PONumber().Substring(0, 6);
                        int    Counts       = 0;
                        if (SerailNO == TotdayNumber)
                        {
                            Counts = Convert.ToInt32(LPNo.Substring(10, 2)) + 1;

                            if (Counts.ToString().Length == 1)
                            {
                                SerailNO = "LPO-" + TotdayNumber + "0" + Counts;
                            }
                            else
                            {
                                SerailNO = "LPO-" + TotdayNumber + Counts.ToString();
                            }
                        }
                        else
                        {
                            AlreadyNumber = POClass.PONumber();

                            SerailNO = "LPO-" + AlreadyNumber;
                        }
                    }
                    else
                    {
                        AlreadyNumber = POClass.PONumber();

                        SerailNO = "LPO-" + AlreadyNumber;
                    }
                }
                else
                {
                    AlreadyNumber = POClass.PONumber();
                    SerailNO      = "LPO-" + AlreadyNumber;
                }

                var result = webServices.Post(new ProductViewModel(), "Product/All");
                ProductViewModel = (new JavaScriptSerializer()).Deserialize <List <ProductViewModel> >(result.Data.ToString());
                ProductViewModel.Insert(0, new ProductViewModel()
                {
                    Id = 0, Name = "Select Item"
                });
                ViewBag.Product = ProductViewModel;

                var results = webServices.Post(new ProductUnitViewModel(), "ProductUnit/All");
                productUnitViewModels = (new JavaScriptSerializer()).Deserialize <List <ProductUnitViewModel> >(results.Data.ToString());
                productUnitViewModels.Insert(0, new ProductUnitViewModel()
                {
                    Id = 0, Name = "Select Unit"
                });
                ViewBag.ProductUnit = productUnitViewModels;

                var Res = webServices.Post(new DriverViewModel(), "Vender/All");
                venderViewModels = (new JavaScriptSerializer()).Deserialize <List <VenderViewModel> >(Res.Data.ToString());
                venderViewModels.Insert(0, new VenderViewModel()
                {
                    Id = 0, Name = "Select Vender"
                });

                ViewBag.Vender = venderViewModels;

                ViewBag.titles = "LPO";
                ViewBag.PO     = SerailNO;

                LPOInvoiceViewModel lPOInvoiceVModel = new LPOInvoiceViewModel();

                lPOInvoiceVModel.FromDate = System.DateTime.Now;
                lPOInvoiceVModel.DueDate  = System.DateTime.Now;

                return(View(lPOInvoiceVModel));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }