public List <SaleHeaderDTO> GetSearchCustomer(DateTime dtFrom, DateTime dtTo, string CusName) { List <SaleHeaderDTO> lst = new List <SaleHeaderDTO>(); try { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter() { ParameterName = "DateFrom", Value = dtFrom, DbType = DbType.DateTime }); param.Add(new SqlParameter() { ParameterName = "DateTo", Value = dtTo, DbType = DbType.DateTime }); param.Add(new SqlParameter() { ParameterName = "CustomerName", Value = CusName }); DataSet ds = conn.GetDataSet("GetCustomerHistorty", param); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null) { SaleHeaderDTO o = new SaleHeaderDTO(); foreach (DataRow dr in ds.Tables[0].Rows) { o = new SaleHeaderDTO(); o.SaleHeaderID = Convert.ToInt32(dr["SaleHeaderID"].ToString()); o.CustomerName = dr["CustomerName"].ToString(); o.Tel = dr["Tel"].ToString(); if (dr["ReceivedDate"].ToString() != "") { o.ReceivedDate = Convert.ToDateTime(dr["ReceivedDate"].ToString()); } o.ReceivedBy = dr["ReceivedBy"].ToString(); o.SaleNumber = dr["SaleNumber"].ToString(); o.ItemCode = dr["ItemCode"].ToString(); o.ItemName = dr["ItemName"].ToString(); o.ItemID = dr["ItemID"].ToString() == "" ? 0 : Convert.ToInt32(dr["ItemID"].ToString()); o.dAmount = Convert.ToDouble(dr["Amount"].ToString()); o.ItemPrice = Convert.ToDouble(dr["ItemPrice"].ToString()); o.Discount = Convert.ToDouble(dr["Discount"].ToString()); o.SerialNumber = dr["SerialNumber"].ToString(); o.BillType = dr["BillType"].ToString(); lst.Add(o); } } } catch (Exception ex) { } return(lst); }
protected List <SaleHeaderDTO> ModDataFromCustomerSale(List <SaleHeaderDTO> lst) { List <SaleHeaderDTO> result = new List <SaleHeaderDTO>(); try { SaleHeaderDTO o = new SaleHeaderDTO(); if (lst != null && lst.Count > 0) { string ItemCode = ""; int i = 0, saleID = 0; double SaleAmt = 0; foreach (SaleHeaderDTO item in lst) { if (saleID != item.SaleHeaderID) { if (i > 0) { ItemCode = ItemCode.Substring(0, ItemCode.Length - 2); o.ItemCode = ItemCode; o.SaleAmount = SaleAmt; result.Add(o); //Reset SaleAmt = 0; ItemCode = ""; } o = new SaleHeaderDTO(); o.SaleHeaderID = item.SaleHeaderID; o.SaleNumber = item.SaleNumber; o.CustomerName = item.CustomerName; o.Tel = item.Tel; o.CustomerAddress = item.CustomerAddress; o.CustomerDistrict = item.CustomerDistrict; o.CustomerCountry = item.CustomerCountry; o.CustomerProvince = item.CustomerProvince; o.CustomerPostalCode = item.CustomerPostalCode; //o.CustomerAddress2 = item.CustomerAddress2; //o.CustomerAddress3 = item.CustomerAddress3; o.ReceivedDate = item.ReceivedDate; o.ReceivedBy = item.ReceivedBy; o.COD = item.COD; o.dAmount = item.dAmount; o.BillType = string.IsNullOrEmpty(item.BillType) ? "" : item.BillType; ItemCode = ItemCode + item.ItemCode + ", "; SaleAmt = SaleAmt + item.DetailPrice; } else { ItemCode = ItemCode + item.ItemCode + ", "; SaleAmt = SaleAmt + item.DetailPrice; } saleID = item.SaleHeaderID; i++; } ItemCode = ItemCode.Substring(0, ItemCode.Length - 2); o.ItemCode = ItemCode; o.SaleAmount = SaleAmt; result.Add(o); result = result.OrderBy(od => od.SaleNumber).ToList(); } } catch (Exception ex) { } return(result); }
protected void btnExport_Click(object sender, EventArgs e) { try { if (Session["ReportSaleDeli"] == null) { BindData(); } #region Variable List <SaleHeaderDTO> lst = (List <SaleHeaderDTO>)Session["ReportSaleDeli"]; List <SaleHeaderDTO> lstChoose = new List <SaleHeaderDTO>(); SaleHeaderDTO o = new SaleHeaderDTO(); SaleHeaderDTO oP2 = new SaleHeaderDTO(); CheckBox cb, cbCOD, cbP2; HiddenField hdd; Int32 ID = 0; lst.ForEach(c => c.COD = "0"); #endregion foreach (GridViewRow item in gv.Rows) { cb = (CheckBox)item.FindControl("chk"); cbCOD = (CheckBox)item.FindControl("chkCOD"); cbP2 = (CheckBox)item.FindControl("chkP2"); if (cb != null && cb.Checked) { hdd = (HiddenField)item.FindControl("hddID"); if (hdd != null && !string.IsNullOrEmpty(hdd.Value)) { ID = ToInt32(hdd.Value); o = lst.FirstOrDefault(w => w.SaleHeaderID.Equals(ID)); if (o != null) { oP2 = (SaleHeaderDTO)o.Clone(); if (cbCOD != null && cbCOD.Checked) { o.COD = "1"; } lstChoose.Add(o); //P2 if (cbP2 != null && cbP2.Checked) { lstChoose.Add(oP2); } } } } } //เพิ่มเก็บเงินปลายทาง -- เพิ่มช่องโทรสับ if (lstChoose != null && lstChoose.Count > 0) { ReportDeliveryExportPDF(lstChoose); } else { ShowMessageBox("กรุณาเลือกรายการ."); return; } } catch (Exception) { } }