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)
{
}
}
