private void btnSubmitLogin_Click(object sender, EventArgs e) { using (OrderEntities db = new OrderEntities()) { string passwd = txtPassword.Text != "" ? HelperCS.Encrypt(txtPassword.Text) : ""; string usr = txtUserName.Text != "" ? txtUserName.Text.ToUpper() : ""; rownum = db.Login.Where(a => a.UserName == usr && a.Password == passwd).Count(); if (rownum > 0) { //DataInfo.UserLoginName = txtUserName.Text; HelperCS.UserName = usr; Form1 frm = this.FindForm() as Form1; //frm.CheckUserLogin(txtUserName.Text); //frm.pa frm.CheckUserLogin(); //password anan168,ac2018 } else { lblLoginValidate.Text = ""; lblLoginValidate.Text = "** InValid Username or Password "; lblLoginValidate.Visible = true; } } }
private void ProductManageUC_Load(object sender, EventArgs e) { HelperCS.AutoCompleteLoadValues(comboProductGroup, "Config-ProductCategory"); HelperCS.AutoCompleteLoadValues(comboProductCarry, "Config-ProductCarry"); HelperCS.AutoCompleteLoadValues(comboProductUnit, "Config-ProductUnit"); if (productid > 0) { btnProductDelete.Visible = true; BindProductData(); } else { txtbProductName.Text = ""; txtbProductAbbr.Text = ""; comboProductGroup.SelectedIndex = 0; txtbProductPrice.Text = ""; //txtbProductUnit.Text = ""; comboProductCarry.SelectedIndex = 0; comboProductUnit.SelectedIndex = 0; txtbProductAmount.Text = ""; txtbProductDescription.Text = ""; btnProductDelete.Visible = false; } }
private void GetInvoiceReportData(DateTime date, int customer) { string ReportName = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Value; using (var dailydb = new OrderEntities()) { var ds1 = (from x in dailydb.vwCustomerDetail where x.CustomerID == customer select x).ToList(); var ds2 = dailydb.GetOrderbyDay(date, customer).ToList(); if (ds1.Count() > 0 && ds2.Count() > 0) { ReportParameter p1 = new ReportParameter("ReportType", ReportName); ReportParameter p2 = new ReportParameter("Date", RptDatePicker.Value.ToLongDateString()); ReportParameter p3 = new ReportParameter("DocumentNo", "INV"); ReportParameter p4 = new ReportParameter("BahtText", BahtToText(ds2)); reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4 }); CustomerBindingSource.DataSource = HelperCS.ToDataTable(ds1); OrderBindingSource.DataSource = HelperCS.ToDataTable(ds2); ReportDataSource rtpsource1 = new ReportDataSource("DataSet1", CustomerBindingSource); ReportDataSource rtpsource2 = new ReportDataSource("DataSet2", OrderBindingSource); reportViewer1.LocalReport.DataSources.Add(rtpsource1); reportViewer1.LocalReport.DataSources.Add(rtpsource2); } else { OrderBindingSource.DataSource = null; } } }
private void btnEditPrice_Click(object sender, EventArgs e) { DialogResult res = InputBox.ShowDialog("กรุณาใส่รหัสเพื่อแก้ไขราคาสินค้า:", "Authentication", //Text message (mandatory), Title (optional) InputBox.Icon.Exclamation, //Set icon type (default info) InputBox.Buttons.OkCancel, //Set buttons (default ok) InputBox.Type.TextBoxPassword, //Set type (default nothing) new string[] { "Item1", "Item2", "Item3" }, //String field as ComboBox items (default null) true, //Set visible in taskbar (default false) new System.Drawing.Font("Calibri", 10F, System.Drawing.FontStyle.Bold)); //Set font (default by system) if (res == System.Windows.Forms.DialogResult.OK || res == System.Windows.Forms.DialogResult.Yes) { using (OrderEntities db = new OrderEntities()) { string passwd = InputBox.ResultValue != "" ? HelperCS.Encrypt(InputBox.ResultValue) : ""; //InputBox.ResultValue = textbox form dialogresult int rownum = db.Login.Where(a => a.UserName == "PRICE" && a.Password == passwd).Count(); if (rownum > 0) { log.Info("OrderUC:Edit Price user:"******" customerid:" + ComboOrderCustomer.SelectedItem.ToString() + " day:" + HelperCS.daycheckbox.ToString()); HelperCS.editprice = true; CheckTabActive(); } else { log.Error("OrderUC:Edit Price Error user:"******" customerid:" + ComboOrderCustomer.SelectedItem.ToString() + " day:" + HelperCS.daycheckbox.ToString()); Form frm = btnEditPrice.FindForm(); MessageBox.Show(frm, "คุณไม่มีสิทธิ์แก้ไขข้อมูล ", "Authorization Problem", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
//private DateTime sundate, mondate, tuedate, weddate, thudate, fridate, satdate; public OrderUC() { InitializeComponent(); HelperCS.AutoCompleteLoadValues(ComboOrderCustomer, "Customer"); CheckDate(); lblEditmode.Text = ""; }
public ReportTable() { InitializeComponent(); HelperCS.AutoCompleteLoadValues(ddlCustomer, "Customer"); HelperCS.AutoCompleteLoadValues(ddlCustomerZone, "Config-Zone"); BindPageSize(); }
private void GetProductTransportReportData(DateTime date, int customerzone) { string ReportName = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Value; string driver = ((KeyValuePair <string, string>)ddlCustomer.SelectedItem).Value; using (var dailydb = new OrderEntities()) { var ds = dailydb.GetProductTransport(date, customerzone).ToList(); if (ds.Count() > 0) { string datestring = HelperCS.DateTextThai(date, "TH", "dd MMM yyyy"); string day = HelperCS.daythai[(int)date.DayOfWeek - 1]; ReportParameter p1 = new ReportParameter("Date", datestring); //ReportParameter p1 = new ReportParameter("Date", date.ToString("yyyy-MM-dd")); ReportParameter p2 = new ReportParameter("Zone", driver); ReportParameter p3 = new ReportParameter("ReportName", ReportName); ReportParameter p4 = new ReportParameter("Day", day); reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4 }); OrderBindingSource.DataSource = HelperCS.ToDataTable(ds); ReportDataSource rtpsource1 = new ReportDataSource("DataSet1", OrderBindingSource); reportViewer1.LocalReport.DataSources.Add(rtpsource1); } else { OrderBindingSource.DataSource = null; } } }
private void GetCustomerTransportTofuReportData(DateTime date) { string ReportName = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Value; using (var dailydb = new OrderEntities()) { List <GetCustomerTransportTofu_Result> ds = null; ds = dailydb.GetCustomerTransportTofu(date).ToList(); if (ds.Count() > 0) { string datestring = HelperCS.DateTextThai(date, "TH", "dd MMM yyyy"); string day = HelperCS.daythai[(int)date.DayOfWeek - 1]; ReportParameter p1 = new ReportParameter("Date", datestring); ReportParameter p2 = new ReportParameter("ReportName", ReportName); ReportParameter p3 = new ReportParameter("Day", day); reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3 }); OrderBindingSource.DataSource = HelperCS.ToDataTable(ds); ReportDataSource rtpsource1 = new ReportDataSource("DataSet1", OrderBindingSource); reportViewer1.LocalReport.DataSources.Add(rtpsource1); } else { OrderBindingSource.DataSource = null; } } }
public CustomerUC() { InitializeComponent(); HelperCS.AutoCompleteLoadValues(ddlCustomer, "Customer"); HelperCS.AutoCompleteLoadValues(ddlCustomerZone, "Config-Zone"); BindPageSize(); fillGrid(); }
private void btnOrderSave_Click(object sender, EventArgs e) { MetroTile btn = (MetroTile)sender; HelperCS.SaveAllOrder(btn); lblEditmode.Text = ""; CheckTabActive(); }
public Form4() { InitializeComponent(); HelperCS.AutoCompleteLoadValues(MondayCustomerCombo, "Customer"); //BindTable(); }
private void ProductUC_Load(object sender, EventArgs e) { //lblValid.Text = ""; HelperCS.AutoCompleteLoadValues(ddlProduct, "Product"); HelperCS.AutoCompleteLoadValues(ddlProductCategory, "Config-ProductCategory"); //BindProductData(1); BindPageSize(); fillGrid(); }
private void btnNewProduct_Click(object sender, EventArgs e) { Form1 frm = this.FindForm() as Form1; frm.callControlPopup("ProductManageUC"); //BindProductData(1); HelperCS.AutoCompleteLoadValues(ddlProduct, "Product"); fillGrid(); }
private DataTable DataEntity() { using (var dailydb = new OrderEntities()) { // Get result from Stored Procedure var ds = dailydb.GetDailyOrder("Monday", 1).ToList(); // if found item rows if (ds.Count() > 0) { return(HelperCS.ToDataTable(ds)); } else { return(new DataTable()); } } }
//private void LoadReport() //{ // reportViewer1.ProcessingMode = ProcessingMode.Local; // //string date = "16/11/2017"; // //DateTime dt = Convert.ToDateTime(date); // //GetSalesOrderData(dt, 3); //} #region GET REPORT DATA private void GetSalesOrderData(DateTime date, int customer) { using (var dailydb = new OrderEntities()) { // Get result from Stored Procedure var ds = dailydb.GetOrderbyDay(date, customer).ToList(); //OrderUC orderUC = new OrderUC(); if (ds.Count() > 0) { OrderBindingSource.DataSource = HelperCS.ToDataTable(ds); ReportDataSource rtpsource = new ReportDataSource("DataSet1", OrderBindingSource); reportViewer1.LocalReport.DataSources.Add(rtpsource); } else { OrderBindingSource.DataSource = null; } } }
private DataTable DataEntityProduct() { using (var db = new OrderEntities()) { // Get result from Stored Procedure //db.sims.Where(x => x.has_been_modified).ToList(); var ds = (from x in db.Product select x).ToList(); // if found item rows if (ds.Count() > 0) { return(HelperCS.ToDataTable(ds)); } else { return(new DataTable()); } } }
private void ProductGrid_CellClick(object sender, DataGridViewCellEventArgs e) { DataGridView dgv = sender as DataGridView; if (dgv == null) { return; } if (dgv.CurrentRow.Selected) { //get value grid columnproductid ProductManageUC.productid = Convert.ToInt32(dgv.Rows[dgv.CurrentRow.Index].Cells[0].Value); } Form1 frm = this.FindForm() as Form1; frm.callControlPopup("ProductManageUC"); //BindProductData(1); HelperCS.AutoCompleteLoadValues(ddlProduct, "Product"); fillGrid(); }
private void GetInvoiceReportData(DateTime date, int customer) { string ReportName = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Value; using (var dailydb = new OrderEntities()) { //var ds1 = (from x in dailydb.vwCustomerDetail // where x.CustomerID == customer // select x).ToList(); List <GetOrderCustomer_Result> ds1 = null; List <GetOrderbyDay_Result> ds2 = null; ds1 = dailydb.GetOrderCustomer(date, customer, "INV").ToList(); ds2 = dailydb.GetOrderbyDay(date, customer).ToList(); if (ds1.Count() > 0 && ds2.Count() > 0) { string docid = (from c in ds1 select(string) c.DocumentID).FirstOrDefault(); string datestring = HelperCS.DateTextThai(date, "TH", "dd MMM yyyy"); ReportParameter p1 = new ReportParameter("ReportType", ReportName); //ReportParameter p2 = new ReportParameter("Date", RptDatePicker.Value.ToLongDateString()); ReportParameter p2 = new ReportParameter("Date", datestring); ReportParameter p3 = new ReportParameter("BahtText", BahtToText(ds2.Sum(item => item.OrderTotal))); ReportParameter p4 = new ReportParameter("DocumentID", docid); reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4 }); CustomerBindingSource.DataSource = null; OrderBindingSource.DataSource = null; CustomerBindingSource.DataSource = HelperCS.ToDataTable(ds1); OrderBindingSource.DataSource = HelperCS.ToDataTable(ds2); ReportDataSource rtpsource1 = new ReportDataSource("DataSet1", CustomerBindingSource); ReportDataSource rtpsource2 = new ReportDataSource("DataSet2", OrderBindingSource); reportViewer1.LocalReport.DataSources.Add(rtpsource1); reportViewer1.LocalReport.DataSources.Add(rtpsource2); } else { CustomerBindingSource.DataSource = null; OrderBindingSource.DataSource = null; } } }
private void CustomerManageUC_Load(object sender, EventArgs e) { HelperCS.AutoCompleteLoadValues(comboCustomerZone, "Config-Zone"); if (customerid > 0) { btnCustomerDelete.Visible = true; BindCustomerData(); } else { txtbCustomerName.Text = ""; txtbCustomerAbbr.Text = ""; txtbCustomerAddress1.Text = ""; txtbCustomerAddress2.Text = ""; txtbCustomerCitizenID.Text = ""; txtbCustomerDescription.Text = ""; txtbCustomerPhone.Text = ""; comboCustomerZone.SelectedIndex = 0; chkCustomerShowPrice.Checked = false; btnCustomerDelete.Visible = false; } }
private void ddlReportName_SelectedIndexChanged(object sender, EventArgs e) { string ReportNamekey = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Key; if (ReportNamekey != "") { if (ddlReportName.SelectedIndex == 1 || ddlReportName.SelectedIndex == 2) { lblCustomer.Visible = true; ddlCustomer.Visible = true; lblCustomer.Text = "รายชื่อลูกค้า"; HelperCS.AutoCompleteLoadValues(ddlCustomer, "Customer"); } else if (ddlReportName.SelectedIndex == 3 || ddlReportName.SelectedIndex == 4) { lblCustomer.Visible = true; ddlCustomer.Visible = true; lblCustomer.Text = "พื้นที่ส่งสินค้า"; HelperCS.AutoCompleteLoadValues(ddlCustomer, "Config-Zone"); } else if (ddlReportName.SelectedIndex == 5) { lblCustomer.Visible = false; ddlCustomer.Visible = false; lblCustomer.Text = ""; //HelperCS.AutoCompleteLoadValues(ddlCustomer, "Config-Zone"); } else { lblCustomer.Visible = false; ddlCustomer.Visible = false; lblCustomer.Text = ""; } } else { } }
public Form3() { InitializeComponent(); HelperCS.AutoCompleteLoadValues(comboBox1, "Product"); HelperCS.AutoCompleteLoadValues(comboBox2, "Customer"); }
private void BindTable(int cusid) { HelperCS.dt = null; HelperCS.CreatePanelTable(SundaytbHeadPanel, SundaytbPanel, "Monday", cusid); }
//private void BindGrid() //{ // using(OrderEntities db = new OrderEntities()) // { // var query = from x in db.Order // select x; // SetGridData(OrderTab.SelectedTab, query.ToList()); // //SundayGrid.DataSource = query.ToList(); // //SundayGrid.Font = new Font("Segoe UI", 11f, FontStyle.Regular, GraphicsUnit.Pixel); // } //} /* * private void BindGrid(DataGridView grid, string day) * { * try * { * if (comboBox1.SelectedIndex >= 0) * { * //int customerid = ddlCustomerOrder.SelectedIndex; * using (var dailydb = new DailyOrderEntities()) * { * // Get result from Stored Procedure * * var ds = dailydb.GetDailyOrder(day, customerid).ToList(); * * // if found item rows * if (ds.Count() > 0) * { * grid.DataSource = ds; * CreateProductComboBox(grid); * } * else * { * * //SetControlTemplateTable(Grid); * } * } * } * * } * catch (Exception ex) * { * * } * } * * private void CreateProductComboBox(DataGridView grid) * { * DataGridViewComboBoxColumn comboboxColumn = new DataGridViewComboBoxColumn(); * comboboxColumn = CreateProductComboBoxColumn(); * SetAlternateChoicesUsingDataSource(comboboxColumn); * comboboxColumn.HeaderText = "Product Combo"; * grid.Columns.Insert(0, comboboxColumn); * } * * * enum ColumnName * { * OrderId, * OrderDate, * CustomerID, * ProductID, * ProductPrice, * ProductAmount, * Description, * OrderStatus, * WeekDay, * ProductName * }; * private void SetAlternateChoicesUsingDataSource(DataGridViewComboBoxColumn comboboxColumn) * { * { * comboboxColumn.DataSource = DataEntityProduct(); * comboboxColumn.ValueMember = "Id"; * comboboxColumn.DisplayMember = "Text"; * //comboboxColumn.ValueMember = ColumnName.ProductName.ToString(); * //comboboxColumn.DisplayMember = comboboxColumn.ValueMember; * } * } * * private object DataEntityProduct() * { * using (var db = new OrderEntities()) * { * var ds = db.Product.Select(x => new * { * Id = x.ProductID, * Text = x.ProductName + " / " + x.ProductID * }).ToList(); * * // if found item rows * if (ds.Count() > 0) * { * return HelperCS.ToDataTable(ds); * } * else * { * return new DataTable(); * } * //var query = from x in db.Product select x; * //// customerGroup is an IGrouping<string, Customer> * //foreach (var item in query) * //{ * // string id = item.ProductID.ToString(); * // string Name = item.ProductName.ToString(); * //} * } * } * * private DataGridViewComboBoxColumn CreateProductComboBoxColumn() * { * DataGridViewComboBoxColumn column = * new DataGridViewComboBoxColumn(); * { * * column.DataPropertyName = ColumnName.ProductName.ToString(); * column.HeaderText = ColumnName.ProductName.ToString(); * column.DropDownWidth = 160; * column.Width = 90; * column.MaxDropDownItems = 3; * column.FlatStyle = FlatStyle.Flat; * } * return column; * } * * private void BindGrid(MetroGrid Grid,string day) * { * * try { * if (ddlCustomerOrder.SelectedIndex >= 0) * { * int customerid = ddlCustomerOrder.SelectedIndex; * //using (OrderEntities db = new OrderEntities()) * //{ * // var result_id = (from d in db.vwOrder * // where d.CustomerID == customerid * // select d); * // var result = from x in result_id * // where x.OrderDay.Contains(day) * // select x; * * // Grid.DataSource = result.ToList(); * // Grid.Font = new Font("Segoe UI", 14f, FontStyle.Regular, GraphicsUnit.Pixel); * //} * //using (DailyOrderEntities store = new DailyOrderEntities()) { } * using (var dailydb = new DailyOrderEntities()) * { * // Get result from Stored Procedure * * var ds = dailydb.GetDailyOrder(day, customerid).ToList(); * * // if found item rows * if (ds.Count() > 0) * { * Grid.DataSource = ds; * Grid.Font = new Font("Segoe UI", 14f, FontStyle.Regular, GraphicsUnit.Pixel); * DataGridTextBoxColumn txtPrice = new DataGridTextBoxColumn(); * } * else * { * * SetControlTemplateTable(Grid); * } * } * } * } * catch(Exception ex) * { * * } * } * * private void SetControlTemplateTable(MetroGrid Grid) * { * DataRow dr = dt.NewRow(); * dr["#"] = ""; * dr["run"] = 1; * dr["ProductName"] = 1; * DataGridTextBoxColumn txtPrice = new DataGridTextBoxColumn(); * DataGridTextBoxColumn txtAmount = new DataGridTextBoxColumn(); * * dr["ProductUnit"] = "1"; * dr["Price"] = txtPrice; * dr["ProductAmount"] = txtAmount; * dr["SumPrice"] = "2221"; * * } * * private void CreateTemplateTable() * { * dt = new DataTable(); * dt.Columns.Add("#", Type.GetType("System.String")); * dt.Columns.Add("run", Type.GetType("Int32")); * dt.Columns.Add("ProductName", Type.GetType("System.String")); * dt.Columns.Add("ProductUnit", Type.GetType("System.String")); * dt.Columns.Add("Price", Type.GetType("System.Decimal")); * dt.Columns.Add("ProductAmount", Type.GetType("Int32")); * dt.Columns.Add("SumPrice", Type.GetType("System.Decimal"));//String.Format("0.00", dtTable.Columns["TestQuantity"]); * dt.PrimaryKey = new DataColumn[] { dt.Columns["run"] }; * } * */ #region Method private void CheckTabActive() { OrderTab.AutoSize = true; //OrderTab.MaximumSize = //new (1800, 900); //check select customer beform bind data if (ComboOrderCustomer.SelectedIndex > 0) { HelperCS.editlabel = lblEditmode; HelperCS.editbtn = btnOrderEdit; if (OrderTab.SelectedTab == OrderTab.TabPages["SundayTab"]) { //if (chkbOrderSunday.Checked == true) //{ // HelperCS.WeekOrder[0] = true; // HelperCS.CreatePanelTable(pnlSundayHead, pnlMainSundayBody, "Sunday", customerid); //} //else //{ // HelperCS.WeekOrder[0] = false; // //ClearPanel("Sunday"); //} chkbOrderSunday.Checked = HelperCS.editmode ? true : chkbOrderSunday.Checked; HelperCS.WeekOrder[0] = chkbOrderSunday.Checked ? true : false; HelperCS.daycheckbox = chkbOrderSunday; HelperCS.CreatePanelTable(pnlSundayHead, pnlMainSundayBody, "Sunday", customerid); } else if (OrderTab.SelectedTab == OrderTab.TabPages["MondayTab"]) { //if (chkbOrderMonday.Checked == true) //{ // HelperCS.WeekOrder[1] = true; // HelperCS.CreatePanelTable(pnlMondayHead, pnlMainMondayBody, "Monday", customerid); //} //else //{ // HelperCS.WeekOrder[1] = false; // //ClearPanel("Monday"); //} chkbOrderMonday.Checked = HelperCS.editmode ? true : chkbOrderMonday.Checked; HelperCS.WeekOrder[1] = chkbOrderMonday.Checked ? true : false; HelperCS.daycheckbox = chkbOrderMonday; HelperCS.CreatePanelTable(pnlMondayHead, pnlMainMondayBody, "Monday", customerid); } else if (OrderTab.SelectedTab == OrderTab.TabPages["TuesdayTab"]) { //if (chkbOrderTuesday.Checked == true) //{ // HelperCS.WeekOrder[2] = true; // HelperCS.CreatePanelTable(pnlTuesdayHead, pnlMainTuesdayBody, "Tuesday", customerid); //} //else //{ // HelperCS.WeekOrder[2] = false; // //ClearPanel("Tuesday"); //} chkbOrderTuesday.Checked = HelperCS.editmode ? true : chkbOrderTuesday.Checked; HelperCS.WeekOrder[2] = chkbOrderTuesday.Checked ? true : false; HelperCS.daycheckbox = chkbOrderTuesday; HelperCS.CreatePanelTable(pnlTuesdayHead, pnlMainTuesdayBody, "Tuesday", customerid); } else if (OrderTab.SelectedTab == OrderTab.TabPages["WednesdayTab"]) { //if (chkbOrderWednesday.Checked == true) //{ // HelperCS.WeekOrder[3] = true; // HelperCS.CreatePanelTable(pnlWednesdayHead, pnlMainWednesdayBody, "Wednesday", customerid); //} //else //{ // HelperCS.WeekOrder[3] = false; // //ClearPanel("Wednesday"); //} chkbOrderWednesday.Checked = HelperCS.editmode ? true : chkbOrderWednesday.Checked; HelperCS.WeekOrder[3] = chkbOrderWednesday.Checked ? true : false; HelperCS.daycheckbox = chkbOrderWednesday; HelperCS.CreatePanelTable(pnlWednesdayHead, pnlMainWednesdayBody, "Wednesday", customerid); } else if (OrderTab.SelectedTab == OrderTab.TabPages["ThursdayTab"]) { //if (chkbOrderThursday.Checked == true) //{ // HelperCS.WeekOrder[4] = true; // HelperCS.CreatePanelTable(pnlThursdayHead, pnlMainThursdayBody, "Thursday", customerid); //} //else //{ // HelperCS.WeekOrder[4] = false; // //ClearPanel("Thursday"); //} chkbOrderThursday.Checked = HelperCS.editmode ? true : chkbOrderThursday.Checked; HelperCS.WeekOrder[4] = chkbOrderThursday.Checked ? true : false; HelperCS.daycheckbox = chkbOrderThursday; HelperCS.CreatePanelTable(pnlThursdayHead, pnlMainThursdayBody, "Thursday", customerid); } else if (OrderTab.SelectedTab == OrderTab.TabPages["FridayTab"]) { //if (chkbOrderFriday.Checked == true) //{ // HelperCS.WeekOrder[5] = true; // HelperCS.CreatePanelTable(pnlFridayHead, pnlMainFridayBody, "Friday", customerid); //} //else //{ // HelperCS.WeekOrder[5] = false; // //ClearPanel("Friday"); //} chkbOrderFriday.Checked = HelperCS.editmode ? true : chkbOrderFriday.Checked; HelperCS.WeekOrder[5] = chkbOrderFriday.Checked ? true : false; HelperCS.daycheckbox = chkbOrderFriday; HelperCS.CreatePanelTable(pnlFridayHead, pnlMainFridayBody, "Friday", customerid); } else if (OrderTab.SelectedTab == OrderTab.TabPages["SaturdayTab"]) { //if (chkbOrderSaturday.Checked == true) //{ // HelperCS.WeekOrder[6] = true; // HelperCS.CreatePanelTable(pnlSaturdayHead, pnlMainSaturdayBody, "Saturday", customerid); //} //else //{ // HelperCS.WeekOrder[6] = false; // //ClearPanel("Saturday"); //} chkbOrderSaturday.Checked = HelperCS.editmode ? true : chkbOrderSaturday.Checked; HelperCS.WeekOrder[6] = chkbOrderSaturday.Checked ? true : false; HelperCS.daycheckbox = chkbOrderSaturday; HelperCS.CreatePanelTable(pnlSaturdayHead, pnlMainSaturdayBody, "Saturday", customerid); } } else { //MetroMessageBox.Show(this, "Please Select Customer Before"); } }
private void BindTable(int cusid) { HelperCS.dt = null; HelperCS.CreatePanelTable(pnlMondayGridHead, pnlMondayGridBody, "Monday", cusid); }
public OrderMondayUC() { InitializeComponent(); HelperCS.AutoCompleteLoadValues(ComboMondayCustomer, "Customer"); }
private void GetReceiveWeeklyReportData(DateTime date, int customer, bool showprice) { string ReportName = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Value; using (var dailydb = new OrderEntities()) { List <GetOrderCustomer_Result> ds1 = null; List <GetReceiveWeeklyPrice_Result> ds2 = null; List <GetReceiveWeekly_Result> ds3 = null; ds1 = dailydb.GetOrderCustomer(date, customer, "RCD").ToList(); bool rowno = false; string bahttext = ""; DataTable dtorder; if (showprice) { ds2 = dailydb.GetReceiveWeeklyPrice(date, customer).ToList(); rowno = ds2.Count() > 0 ? true : false; bahttext = rowno ? BahtToText(ds2.Sum(item => item.total)) : ""; dtorder = HelperCS.ToDataTable(ds2); } else { ds3 = dailydb.GetReceiveWeekly(date, customer).ToList(); rowno = ds3.Count() > 0 ? true : false; bahttext = rowno ? BahtToText(ds3.Sum(item => item.total)) : ""; dtorder = HelperCS.ToDataTable(ds3); } //string datestring = HelperCS.DateTextThai(RptDatePicker.Value,"TH","dd MMM yyyy"); string datestring = HelperCS.DateTextThai(DateTime.Now, "TH", "dd MMM yyyy"); if (ds1.Count() > 0 && rowno) { CustomerBindingSource.DataSource = HelperCS.ToDataTable(ds1); OrderBindingSource.DataSource = dtorder; //string sunday = dt.Rows[i].Field<int>(j); DateTime startdate = (from c in ds1 select(DateTime) c.OrderStartDate).FirstOrDefault(); string docid = (from c in ds1 select(string) c.DocumentID).FirstOrDefault(); ReportParameter p1 = new ReportParameter("ReportType", ReportName); ReportParameter p2 = new ReportParameter("Date", datestring); ReportParameter p3 = new ReportParameter("BahtText", bahttext); ReportParameter p4 = new ReportParameter("suntext", HelperCS.DateTextThai(startdate, "TH", "dd-MMM")); ReportParameter p5 = new ReportParameter("montext", HelperCS.DateTextThai(startdate.AddDays(1), "TH", "dd-MMM")); ReportParameter p6 = new ReportParameter("tuetext", HelperCS.DateTextThai(startdate.AddDays(2), "TH", "dd-MMM")); ReportParameter p7 = new ReportParameter("wedtext", HelperCS.DateTextThai(startdate.AddDays(3), "TH", "dd-MMM")); ReportParameter p8 = new ReportParameter("thrtext", HelperCS.DateTextThai(startdate.AddDays(4), "TH", "dd-MMM")); ReportParameter p9 = new ReportParameter("fritext", HelperCS.DateTextThai(startdate.AddDays(5), "TH", "dd-MMM")); ReportParameter p10 = new ReportParameter("sattext", HelperCS.DateTextThai(startdate.AddDays(6), "TH", "dd-MMM")); ReportParameter p11 = new ReportParameter("DocumentID", docid); reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11 }); ReportDataSource rtpsource1 = new ReportDataSource("DataSet1", CustomerBindingSource); ReportDataSource rtpsource2 = new ReportDataSource("DataSet2", OrderBindingSource); reportViewer1.LocalReport.DataSources.Add(rtpsource1); reportViewer1.LocalReport.DataSources.Add(rtpsource2); } else { CustomerBindingSource.DataSource = null; OrderBindingSource.DataSource = null; } } }
public ReportViewerUC() { InitializeComponent(); HelperCS.AutoCompleteLoadValues(ddlCustomer, "Customer"); HelperCS.AutoCompleteLoadValues(ddlReportName, "Config-ReportName"); }