/// <summary>
/// CGR05報表
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable VGR01_0(ArrayList ParameterList,
string ReportOutputFormat,
ref ReportList.ExcelOtherType EOT
)
{
VGRModel.MaintainReturnData bco = new VGRModel.MaintainReturnData(ConntionDB);
DataTable Dt = bco.GetPrintRpt01Detl(ParameterList);
if (Dt.Rows.Count == 0)
{
throw new Exception("查無資料");
}
else
{
//取得筆數資料，筆數未滿10的倍數，塞假資料補成10的倍數(因為套表是10筆1張)
int j = Dt.Rows.Count % 10;
if (j != 0)
{
for (int i = 0; i < 10 - j; i++)
{
DataRow drNew = Dt.NewRow();
drNew["Item"] = "XXXXXXXXXX"; //只要ITEM是XXXXXXXXXX就抑制顯示
drNew["Item_Name"] = "";
drNew["Period"] = "";
drNew["Return_Qty"] = 0;
drNew["Price"] = 0;
drNew["Cost"] = 0;
Dt.Rows.Add(drNew);
}
}
return Dt;
}
}
//新增明細
protected void btnAdd_Click(object sender, EventArgs e)
{
ErrorMsgLabel.Text = "";
string SessionIDName = "VGR01_DTL_" + PageTimeStamp.Value;
//宣告殘餘數量
int Remain_Qty = 0;
//調整數量
int Adjust_Qty = 0;
#region 檢查輸入值
string strErr = "";
string SugLocate = "";
string strTaxType = "";
if (SLP_Item.Text == string.Empty)
{
strErr = "請輸入品號 ";
//this.ErrorMsgLabel.Text = strErr;
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VGR012", "alert('" + strErr + "');", true);
return;
}
if (SLP_Period.Text == string.Empty)
{
strErr = "請輸入期間 ";
//this.ErrorMsgLabel.Text = strErr;
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VGR012", "alert('" + strErr + "');", true);
return;
}
if (SLP_ReturnQty.Text == string.Empty)
{
strErr = "請輸入退貨數量 ";
//this.ErrorMsgLabel.Text = strErr;
//ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "隨便寫", "document.getElementById('" + this.SLP_ReturnQty.FindControl("TextBoxCode").ClientID + "').focus();", true);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VGR012", "alert('" + strErr + "');", true);
return;
}
//else
//{
// if (int.Parse(SLP_ReturnQty.Text) < 1)
// {
// strErr = "[退貨數量]欄必須為正整數 ";
// this.ErrorMsgLabel.Text = strErr;
// SLP_ReturnQty.Text = "";
// return;
// }
//}
if (txtOnHDQty.Text == "")
{
txtOnHDQty.Text = "0";
}
#endregion
#region 判斷新增的資料
DataTable Dt = null;
DataSet Ds = new DataSet();
if (MasterOLDData.InnerHtml != "")
{
System.IO.StringReader sr = new System.IO.StringReader(MasterOLDData.InnerHtml);
Ds.ReadXml(sr);
}
try
{
IVMModel.MaintainRemoveDataDetail dboIVM = new IVMModel.MaintainRemoveDataDetail(ConntionDB);
VGRModel.MaintainReturnData BCOVGR = new VGRModel.MaintainReturnData(ConntionDB);
//變更DATATABLE 資料內容
for (int i = 0; i < GridView1.Rows.Count; i++)
{
Label lblItem = (Label)GridView1.Rows[i].FindControl("lblItem");
Label lblPeriod = (Label)GridView1.Rows[i].FindControl("lblPeriod");
Label lblOnhdQty = (Label)GridView1.Rows[i].FindControl("lblOnhdQty");
Label lblRemainQty = (Label)GridView1.Rows[i].FindControl("lblRemainQty");
TextBox txtReturnQty = (TextBox)GridView1.Rows[i].FindControl("txtReturnQty");
for (int x = 0; x < Ds.Tables[0].Rows.Count; x++)
{
string Item = Ds.Tables[0].Rows[x]["item"].ToString();
string Period = Ds.Tables[0].Rows[x]["period"].ToString();
if (lblItem.Text == Item && lblPeriod.Text == Period)
{
if (int.Parse(txtReturnQty.Text) + int.Parse(lblOnhdQty.Text) >= 0)
{
Ds.Tables[0].Rows[x]["return_qty"] = txtReturnQty.Text;
Ds.Tables[0].Rows[x]["remain_qty"] = (int.Parse(lblOnhdQty.Text) - int.Parse(txtReturnQty.Text)).ToString();
if(int.Parse(lblOnhdQty.Text) - int.Parse(txtReturnQty.Text) > 0)
{
Ds.Tables[0].Rows[x]["adjust_qty"] = "0";
}
else
{
Ds.Tables[0].Rows[x]["adjust_qty"] = ((int.Parse(lblOnhdQty.Text) - int.Parse(txtReturnQty.Text)) * -1).ToString();
}
break;
}
else
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "隨便寫", "document.getElementById('" + txtReturnQty.ClientID + "').focus();", true);
return;
}
}
}
}
if (Ds.Tables.Count == 0)
{
//從DB讀取一空table回來
ParameterList.Clear();
Dt = BCOVGR.QueryReturnDetlEmpty();
}
else
{
Dt = Ds.Tables[0];
}
//如果不是使用BARCODE輸入，取得商品資料
if(txtBarCode.Text == "")
{
string Vendor = "";
int Onhd_Qty = 0;
int Price = 0;
Double Cost = 0;
string TaxType = "";
VGRModel.MaintainReturnData BCO = new VGRModel.MaintainReturnData(ConntionDB);
bool HaveData = BCO.GetItemData(SLP_Item.Text, SLP_Period.Text, hid_LocateSection.Value.ToString(), out Vendor, out Onhd_Qty, out Price, out Cost, out TaxType);
hid_Vendor_Temp.Value = Vendor.ToString();
hid_Price.Value = Price.ToString();
hid_Cost.Value = Cost.ToString();
hid_Tax_Type.Value = TaxType.ToString() ;
if (HaveData == true)
txtOnHDQty.Text = Onhd_Qty.ToString();
else
txtOnHDQty.Text = "0";
}
//檢查是否有重複的品項、期別、儲位
bool haveData = false;
ArrayList TaxList = new ArrayList();
TaxList = TaxTypeList;
for (int i = 0; i <= Dt.Rows.Count - 1; i++)
{
if ((Dt.Rows[i]["item"].ToString() == SLP_Item.Text) &&
(Dt.Rows[i]["period"].ToString() == SLP_Period.Text))
{
Remain_Qty = int.Parse(this.txtOnHDQty.Text) - int.Parse(SLP_ReturnQty.Text);
if (Remain_Qty < 0)
{
Adjust_Qty = Remain_Qty * -1;
}
else
{
Adjust_Qty = 0;
}
haveData = true;
Dt.Rows[i]["return_qty"] =int.Parse(SLP_ReturnQty.Text);
Dt.Rows[i]["old_return_qty"] = int.Parse(SLP_ReturnQty.Text);
Dt.Rows[i]["adjust_qty"] = Adjust_Qty;
Dt.Rows[i]["remain_qty"] = Remain_Qty;
Dt.Rows[i]["isChange"] = "N";
}
}
strTaxType = hid_Tax_Type.Value;
bool InList = false;
//紀錄TaxType類型
for (int j = 0; j < TaxList.Count; j++)
{
if (strTaxType == TaxList[j].ToString())
{
InList = true;
}
}
if (InList == false)
{
TaxList.Add(strTaxType);
}
TaxTypeList = TaxList;
if(haveData == false)
{
if ((SLP_Vendor.Text != string.Empty && this.hid_CurrentVendor.Value == "")||(SLP_Vendor.Text == string.Empty && this.hid_CurrentVendor.Value == "") || (this.hid_CurrentVendor.Value == this.hid_Vendor_Temp.Value && this.hid_CurrentVendor.Value == this.SLP_Vendor.Text))
{
tempID = 0;
DataView tempDT = new DataView();
tempDT.Table = Dt.Copy();
tempDT.Sort = "ID ASC";
if (Dt.Rows.Count != 0)
{
tempID = Convert.ToInt32(tempDT[Dt.Rows.Count - 1]["ID"].ToString());
}
DataRow dRow = Dt.NewRow();
//ID和CODE暫自訂, 真正寫入CO時會重取
int v_ID = tempID + 1;
int v_CODE = tempID + 1;
Remain_Qty = int.Parse(this.txtOnHDQty.Text) - int.Parse(SLP_ReturnQty.Text);
if (Remain_Qty < 0)
{
Adjust_Qty = Remain_Qty * -1;
}
else
{
Adjust_Qty = 0;
}
dRow["item"] = SLP_Item.Text;
dRow["period"] = SLP_Period.Text;
if (SLP_Item.Name != "")
{
dRow["item_name"] = SLP_Item.Name;
}
else
{
string ItemName = dboIVM.GetItemName(SLP_Item.Text);
dRow["item_name"] = ItemName;
}
dRow["price"] = hid_Price.Value;
dRow["onhd_qty"] = txtOnHDQty.Text;
dRow["return_qty"] = SLP_ReturnQty.Text;
dRow["old_return_qty"] = SLP_ReturnQty.Text;
dRow["remain_qty"] = Remain_Qty;
dRow["adjust_qty"] = Adjust_Qty;
dRow["cost"] = hid_Cost.Value;
dRow["tax_type"] = hid_Tax_Type.Value;
dRow["ID"] = v_ID;
dRow["isChange"] = "N";
Dt.Rows.Add(dRow);
if (this.SLP_Vendor.Text == string.Empty)
{
SLP_Vendor.Text = hid_Vendor_Temp.Value;
}
if (this.hid_CurrentVendor.Value == "")
{
this.hid_CurrentVendor.Value = SLP_Vendor.Text;
}
}
else
{
strErr = "不為此供應商品項 ";
txtBarCode.Text = "";
this.hid_Vendor_Temp.Value = "";
//this.ErrorMsgLabel.Text = strErr;
//ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "隨便寫", "document.getElementById('" + this.txtBarCode.ClientID + "').focus();", true);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VGR012", "alert('" + strErr + "');", true);
return;
}
}
#region 使用XML放置到前端資料
MasterOLDData.InnerHtml = Dt.DataSet.GetXml();
#endregion
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
GridView1.DataBind();
CalcuTotalRemove(Dt);
//改由db計算
//CalcuTotalTax(Dt);
this.SLP_Item.Text = string.Empty;
this.SLP_Period.Text = string.Empty;
this.txtOnHDQty.Text = string.Empty;
this.SLP_ReturnQty.Text = string.Empty;
//this.hid_Tax_Total_Amt.Value = string.Empty;
//this.hid_UnTax_Total_Amt.Value = string.Empty;
//this.hid_Tax_ReMain_Amt.Value = string.Empty;
//this.hid_UnTax_ReMain_Amt.Value = string.Empty;
//this.hid_Tax_Amt.Value = string.Empty;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
TextBox txtReturnQty = (TextBox)GridView1.Rows[i].FindControl("txtReturnQty");
Label lblReturnQty = (Label)GridView1.Rows[i].FindControl("lblReturnQty");
txtReturnQty.Visible = true;
lblReturnQty.Visible = false;
}
if (this.hid_Page_Status.Value == "INSERT")
{
GridView1.Columns[8].Visible = false;
GridView1.Columns[9].Visible = false;
}
else if (this.hid_Page_Status.Value == "UPDATE")
{
GridView1.Columns[8].Visible = false;
GridView1.Columns[9].Visible = false;
GridView1.Columns[11].Visible = false;
}
txtBarCode.Text = "";
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "隨便寫", "document.getElementById('" + this.txtBarCode.ClientID + "').focus();", true);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
private void bindMain()
{
try
{
if (this.hid_Page_Status.Value == "VIEW")//Model：檢視
{
VGRModel.MaintainReturnData BCOVGR = new VGRModel.MaintainReturnData(ConntionDB);
//將報表列印所需要的報表欄位參數加入HiddenField
DataTable dtHidField = BCOVGR.GetPrintRpt01Main(Request.QueryString["ID"].ToString());
if (dtHidField.Rows.Count > 0)
{
this.hidContract.Value=dtHidField.Rows[0]["Business_Contact"].ToString();
this.hidFax.Value = dtHidField.Rows[0]["Business_Fax"].ToString();
this.hidReturnDate.Value = dtHidField.Rows[0]["Return_Date"].ToString();
this.hid_Tax_Total_Amt.Value = dtHidField.Rows[0]["Tax_Total_Amt"].ToString();
this.hid_UnTax_Total_Amt.Value = dtHidField.Rows[0]["UnTax_Total_Amt"].ToString();
this.hid_Tax_Amt.Value = dtHidField.Rows[0]["Tax_Amt"].ToString();
}
DataTable dtResult = BCOVGR.QueryMainByID(Request.QueryString["ID"].ToString());
if (dtResult.Rows.Count == 1)
{
this.txtRemoveNo.Text = dtResult.Rows[0]["return_no"].ToString();
this.txtAdjNo.Text = dtResult.Rows[0]["adjust_no"].ToString();
this.txtSum.Text = dtResult.Rows[0]["sum_qty"].ToString();
this.SLP_Date.Text = dtResult.Rows[0]["return_date"].ToString();
this.SLP_Vendor.Text = dtResult.Rows[0]["vendor"].ToString();
this.lblCretaeDate.Text = dtResult.Rows[0]["createdate"].ToString();
this.SLP_CUser.Text = dtResult.Rows[0]["createuid"].ToString();
this.lblMaintainDate.Text = dtResult.Rows[0]["UpdateDate"].ToString();
this.SLP_MUser.Text = dtResult.Rows[0]["updateuid"].ToString();
this.hid_UpdateTime.Value = dtResult.Rows[0]["UpdateTime"].ToString();
VGRModel.GetSysData BCOSysData = new VGRModel.GetSysData(ConntionDB);
string Apl_Date = BCOSysData.GetBUSDate();
if (Apl_Date == string.Empty)
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VGR01", "alert('未取得檢核日期 ');", true);
return;
}
string VAMClosed = BCOSysData.CheckVAMClosedYN(Apl_Date);
this.btnEdit.Enabled = VAMClosed == "N";
this.btnSave.Enabled = false;
this.btnCancel.Enabled = false;
}
else
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VGR01", "alert('無資料可供查詢 ');", true);
return;
}
}
else if (this.hid_Page_Status.Value == "UPDATE")//Model：編輯(更新)
{
//取得TARGET LOCATE SECTION
ParameterList.Clear();
ParameterList.Add("B");
VGRModel.MaintainReturnData BCOVGR = new VGRModel.MaintainReturnData(ConntionDB);
string strReturnLocateNo = "";
string strReturnLocateSection = "";
BCOVGR.QueryTargetLocate(ParameterList, out strReturnLocateNo, out strReturnLocateSection);
ReturnLocateNo = strReturnLocateNo;
ReturnLocateSection = strReturnLocateSection;
hid_LocateSection.Value = ReturnLocateSection;
if (ReturnLocateSection == string.Empty)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "alert('廠退作業尚未設定對應儲格'); window.location.href = 'VGR011.aspx';", true);
}
DataTable dtResult = BCOVGR.QueryMainByID(Request.QueryString["ID"].ToString());
if (dtResult.Rows.Count == 1)
{
this.txtRemoveNo.Text = dtResult.Rows[0]["return_no"].ToString();
this.txtAdjNo.Text = dtResult.Rows[0]["adjust_no"].ToString();
this.txtSum.Text = dtResult.Rows[0]["sum_qty"].ToString();
this.SLP_Date.Text = dtResult.Rows[0]["return_date"].ToString();
this.SLP_Vendor.Text = dtResult.Rows[0]["vendor"].ToString();
this.lblCretaeDate.Text = dtResult.Rows[0]["createdate"].ToString();
this.SLP_CUser.Text = dtResult.Rows[0]["createuid"].ToString();
this.lblMaintainDate.Text = dtResult.Rows[0]["UpdateDate"].ToString();
this.SLP_MUser.Text = dtResult.Rows[0]["updateuid"].ToString();
this.hid_UpdateTime.Value = dtResult.Rows[0]["UpdateTime"].ToString();
this.btnEdit.Visible = false;
this.btnAddDetail.Enabled = false;
}
}
else if (this.hid_Page_Status.Value == "INSERT")//Model：新增
{
//取得TARGET LOCATE SECTION
ParameterList.Clear();
ParameterList.Add("B");
VGRModel.MaintainReturnData BCOVGR = new VGRModel.MaintainReturnData(ConntionDB);
string strReturnLocateNo = "";
string strReturnLocateSection = "";
BCOVGR.QueryTargetLocate(ParameterList, out strReturnLocateNo, out strReturnLocateSection);
ReturnLocateNo = strReturnLocateNo;
ReturnLocateSection = strReturnLocateSection;
hid_LocateSection.Value = ReturnLocateSection;
if (ReturnLocateSection == string.Empty)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "alert('廠退作業尚未設定對應儲格'); window.location.href = 'VGR011.aspx';", true);
}
this.SLP_Date.Text = strToday;
this.SLP_CDate.Text = strToday;
this.SLP_CUser.Text = Session["UID"].ToString();
this.SLP_MDate.Text = strToday;
this.SLP_MUser.Text = Session["UID"].ToString();
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
private void bindDetl()
{
try
{
string SessionIDName = "VGR01_DTL_" + PageTimeStamp.Value;
if (this.hid_Page_Status.Value == "VIEW")//Model：檢視
{
VGRModel.MaintainReturnData BCOVGR = new VGRModel.MaintainReturnData(ConntionDB);
DataTable dtResult = BCOVGR.QueryDetlByID(Request.QueryString["ID"].ToString());
#region 使用XML放置到前端資料
MasterOLDData.InnerHtml = dtResult.DataSet.GetXml();
#endregion
if (dtResult.Rows.Count > 0)
{
Session[SessionIDName] = dtResult;
GridView1.DataSource = dtResult;
GridView1.DataBind();
CalcuTotalRemove(dtResult);
}
}
if (this.hid_Page_Status.Value == "UPDATE")//Model：編輯
{
VGRModel.MaintainReturnData BCOVGR = new VGRModel.MaintainReturnData(ConntionDB);
DataTable dtResult = BCOVGR.QueryDetlByID(Request.QueryString["ID"].ToString());
#region 使用XML放置到前端資料
MasterOLDData.InnerHtml = dtResult.DataSet.GetXml();
#endregion
if (dtResult.Rows.Count > 0)
{
Session[SessionIDName] = dtResult;
GridView1.DataSource = dtResult;
GridView1.DataBind();
CalcuTotalRemove(dtResult);
}
ArrayList TaxList = new ArrayList();
TaxList = TaxTypeList;
for(int i = 0;i<dtResult.Rows.Count;i++)
{
bool haveTaxRate = false;
for (int j = 0; j < TaxList.Count; j++)
{
if (dtResult.Rows[i]["Tax_type"].ToString()==TaxList[j].ToString())
{
haveTaxRate = true;
}
}
if (haveTaxRate == false)
TaxList.Add(dtResult.Rows[i]["Tax_type"].ToString());
}
TaxTypeList = TaxList;
}
GridView1.Columns[8].Visible = false;
GridView1.Columns[9].Visible = false;
if(this.hid_Page_Status.Value != "INSERT")
GridView1.Columns[11].Visible = false;
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
public static string GetItemInfo(string Item,string Period, string LocateSection)
{
bool HaveData = false;
string vendor = string.Empty;
int OnHd_Qty = 0;
int Price = 0;
double Cost = 0;
string TaxType = string.Empty;
VGRModel.MaintainReturnData BCO = new VGRModel.MaintainReturnData(ConntionDB);
HaveData = BCO.GetItemData(Item, Period, LocateSection, out vendor, out OnHd_Qty, out Price, out Cost, out TaxType);
if (HaveData == true)
return vendor + "," + OnHd_Qty.ToString() + "," + Price + "," + Cost.ToString() + "," + TaxType;
else
return vendor + "," + "0" + "," + Price + "," + Cost.ToString() + "," + TaxType;
}
public static string GetReturnCount(string Vendor, string Today)
{
string ReturnCount = "";
VGRModel.MaintainReturnData BCO = new VGRModel.MaintainReturnData(ConntionDB);
ReturnCount = BCO.GetVendorReturnCount(Vendor, Today);
return ReturnCount;
}
/// <summary>
/// 利用 CrystalReport 列印 Excel 報表
/// </summary>
/// <param name="s_FileName">Excel報表的檔名</param>
/// <param name="s_rptFilePath">rpt檔的路徑</param>
/// <param name="dt_Source">要列印的資料</param>
/// /// <param name="reportFormatType">檔案型態</param>
private void LoadCrystalReport(string s_FileName, string s_rptFilePath, string reportFormatType)
{
try
{
VGRModel.MaintainReturnData BCOVGR = new VGRModel.MaintainReturnData(ConntionDB);
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(s_rptFilePath);
//report.Load(Server.MapPath("./REPORT/VGR01/VGR01R01.rptt"));
ArrayList DBParameterList = new ArrayList();
DBParameterList.Add(hiddenID.Value);
DataTable dtResult = BCOVGR.GetPrintRpt01Detl(DBParameterList);
int j = dtResult.Rows.Count % 10;
if (j != 0)
{
for (int i = 0; i < 10 - j ; i++)
{
DataRow drNew = dtResult.NewRow();
drNew["Item"] = "XXXXXXXXXX";
drNew["Item_Name"] = "";
drNew["Period"] = "";
drNew["Return_Qty"]=0;
drNew["Price"]=0;
drNew["Cost"] = 0;
dtResult.Rows.Add(drNew);
}
}
report.SetDataSource(dtResult);
DataTable dtMainData = BCOVGR.GetPrintRpt01Main(Request.QueryString["ID"].ToString());
if (dtMainData.Rows.Count > 0)
{
report.SetParameterValue("paraBusiness_Contact1", dtMainData.Rows[0]["Business_Contact"].ToString());
report.SetParameterValue("paraBusiness_Fax", dtMainData.Rows[0]["Business_Fax"].ToString());
report.SetParameterValue("paraReturn_Date", dtMainData.Rows[0]["Return_Date"].ToString());
report.SetParameterValue("paraVendor_Name", dtMainData.Rows[0]["Vendor_Name"].ToString());
report.SetParameterValue("paraVendor", dtMainData.Rows[0]["Vendor"].ToString());
report.SetParameterValue("paraReturn_No", dtMainData.Rows[0]["Return_No"].ToString());
report.SetParameterValue("paraTax_Total_Amt", dtMainData.Rows[0]["Tax_Total_Amt"].ToString());
report.SetParameterValue("paraUnTax_Total_Amt", dtMainData.Rows[0]["UnTax_Total_Amt"].ToString());
report.SetParameterValue("paraTax_Amt", dtMainData.Rows[0]["Tax_Amt"].ToString());
//ParameterFields par1 = new ParameterFields();
//AddParameter("paraBusiness_Contact1", dtMainData.Rows[0]["Business_Contact1"].ToString(), par1);
//ParameterFields par2 = new ParameterFields();
//AddParameter("paraBusiness_Fax", dtMainData.Rows[0]["Business_Fax"].ToString(), par2);
//ParameterFields par3 = new ParameterFields();
//AddParameter("paraReturn_Date", dtMainData.Rows[0]["Return_Date"].ToString(), par3);
//ParameterFields par4 = new ParameterFields();
//AddParameter("paraVendor_Name", dtMainData.Rows[0]["Vendor_Name"].ToString(), par4);
//ParameterFields par5 = new ParameterFields();
//AddParameter("paraVendor", dtMainData.Rows[0]["Vendor"].ToString(), par5);
//ParameterFields par6 = new ParameterFields();
//AddParameter("paraReturn_No", dtMainData.Rows[0]["Return_No"].ToString(), par6);
//ParameterFields par7 = new ParameterFields();
//AddParameter("paraTax_Total_Amt", dtMainData.Rows[0]["Tax_Total_Amt"].ToString(), par7);
//ParameterFields par8 = new ParameterFields();
//AddParameter("paraUnTax_Total_Amt", dtMainData.Rows[0]["UnTax_Total_Amt"].ToString(), par8);
//ParameterFields par9 = new ParameterFields();
//AddParameter("paraTax_Amt", dtMainData.Rows[0]["Tax_Amt"].ToString(), par9);
}
else
{
string strErr = "查無資料";
this.ErrorMsgLabel.Text = strErr;
return;
}
switch (reportFormatType)
{
case "EXCEL":
System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel);
byte[] bytesXLS = new byte[streamXLS.Length];
streamXLS.Read(bytesXLS, 0, bytesXLS.Length);
streamXLS.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/vnd.ms-excel";
Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length);
Response.Flush();
Response.Close();
break;
case "PDF":
System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byte[] bytesPDF = new byte[streamPDF.Length];
streamPDF.Read(bytesPDF, 0, bytesPDF.Length);
streamPDF.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/pdf";
Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length);
Response.Flush();
Response.Close();
break;
default:
break;
}
report.Close();
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
public static string GetBarCodeData(string txtBarCodeText, string LocateSection)
{
bool HaveData = false;
string item = string.Empty;
string period = string.Empty;
string vendor = string.Empty;
int OnHd_Qty = 0;
int Price = 0;
double Cost = 0;
string TaxType = string.Empty;
VGRModel.MaintainReturnData BCO = new VGRModel.MaintainReturnData(ConntionDB);
HaveData = BCO.GetBarCodeData(txtBarCodeText, LocateSection, out item, out period, out vendor, out OnHd_Qty, out Price, out Cost, out TaxType);
if (HaveData == true)
return item + "," + period + "," + vendor + "," + OnHd_Qty.ToString() + "," + Price + "," + Cost.ToString() + "," + TaxType;
else
return "";
}
private void SaveForm()
{
ErrorMsgLabel.Text = "";
//變數宣告
string UserID = Session["UID"].ToString();
string strNow = DateTime.Now.ToString("yyyyMMddHHmmss");
string IsAdj = "";
string MainID = "";
string AdjustNo = "";
string ReturnNo = "";
string strErr = "";
#region 檢查輸入完整性
if (SLP_Vendor.Text == string.Empty)
{
strErr = "請輸入供應商 ";
this.ErrorMsgLabel.Text = strErr;
return;
}
DataSet Ds = new DataSet();
if (MasterOLDData.InnerHtml != "")
{
System.IO.StringReader sr = new System.IO.StringReader(MasterOLDData.InnerHtml);
Ds.ReadXml(sr);
if (Ds.Tables.Count == 0)
{
ErrorMsgLabel.Text = "尚未輸入廠商退貨明細資料或退貨數量皆為零";
return;
}
}
else
{
ErrorMsgLabel.Text = "尚未輸入廠商退貨明細資料或退貨數量皆為零";
return;
}
#endregion
#region 廠退單建立
//重新調整退貨單輸入數量回傳是否需要建立調整單
try
{
//更新GridView上的廠退單資料
//變更DATATABLE 資料內容
for (int i = 0; i < GridView1.Rows.Count; i++)
{
Label lblItem = (Label)GridView1.Rows[i].FindControl("lblItem");
Label lblPeriod = (Label)GridView1.Rows[i].FindControl("lblPeriod");
Label lblOnhdQty = (Label)GridView1.Rows[i].FindControl("lblOnhdQty");
TextBox txtReturnQty = (TextBox)GridView1.Rows[i].FindControl("txtReturnQty");
for (int x = 0; x < Ds.Tables[0].Rows.Count; x++)
{
string Item = Ds.Tables[0].Rows[x]["item"].ToString();
string Period = Ds.Tables[0].Rows[x]["period"].ToString();
if (lblItem.Text == Item && lblPeriod.Text == Period)
{
if (int.Parse(txtReturnQty.Text) + int.Parse(lblOnhdQty.Text) >= 0)
{
Ds.Tables[0].Rows[x]["return_qty"] = txtReturnQty.Text;
}
else
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "隨便寫", "document.getElementById('" + txtReturnQty.ClientID + "').focus();", true);
return;
}
break;
}
}
}
//剔除退貨數量是0的資料
for (int i = Ds.Tables[0].Rows.Count; i > 0; i--)
{
if (Ds.Tables[0].Rows[i - 1]["return_qty"].ToString() == "0")
{
Ds.Tables[0].Rows.Remove(Ds.Tables[0].Rows[i - 1]);
}
}
if (Ds.Tables.Count == 0 || Ds.Tables[0].Rows.Count == 0)
{
ErrorMsgLabel.Text = "尚未輸入廠商退貨明細資料或退貨數量皆為零";
return;
}
Ds.Tables[0].Columns.Remove("old_return_qty");
VGRModel.MaintainReturnData BCOVGR = new VGRModel.MaintainReturnData(ConntionDB);
DataTable dtDetail = BCOVGR.CheckAdjustQty(ReturnLocateSection, Ds.Tables[0],out IsAdj);
//改由db計算
//CalcuTotalTax(Ds.Tables[0]);
ParameterList.Clear();
ParameterList.Add(UserID);
ParameterList.Add(strNow);
ParameterList.Add(IsAdj);
ParameterList.Add(ReturnLocateSection);
ParameterList.Add(SLP_Vendor.Text);
ParameterList.Add("S4");
ParameterList.Add("E5");
ParameterList.Add(0);
ParameterList.Add(0);
ParameterList.Add(0);
ParameterList.Add(0);
ParameterList.Add(0);
dtDetail.Columns.Remove("item_name");
dtDetail.Columns.Remove("remain_qty");
dtDetail.Columns.Remove("id");
BCOVGR.CreateReturnData(ParameterList, dtDetail, null, out ReturnNo, out MainID, out AdjustNo);
ArrayList IDList = new ArrayList();
IDList.Add(MainID);
Session["VGR01QueryID"] = IDList;
Response.Redirect(string.Format("VGR012.aspx?ID={0}&Code=VGR01&PageMode=1", MainID));
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
private void ShowReport()
{
try
{
VGRModel.MaintainReturnData BCOVGR = new VGRModel.MaintainReturnData(ConntionDB);
ReportDocument report = new ReportDocument();
report.Load(Server.MapPath("./REPORT/VGR01/VGR01R01.rpt"));
ArrayList DBParameterList = new ArrayList();
DBParameterList.Add(Request.QueryString["ID"].ToString());
DataTable dtResult = BCOVGR.GetPrintRpt01Detl(DBParameterList);
report.SetDataSource(dtResult);
DataTable dtMainData = BCOVGR.GetPrintRpt01Main(Request.QueryString["ID"].ToString());
if (dtMainData.Rows.Count > 0)
{
ParameterFields par1 = new ParameterFields();
AddParameter("paraBusiness_Contact1", dtMainData.Rows[0]["Business_Contact"].ToString(),par1);
ParameterFields par2 = new ParameterFields();
AddParameter("paraBusiness_Fax", dtMainData.Rows[0]["Business_Fax"].ToString(), par2);
ParameterFields par3 = new ParameterFields();
AddParameter("paraReturn_Date", dtMainData.Rows[0]["Return_Date"].ToString(), par3);
ParameterFields par4 = new ParameterFields();
AddParameter("paraVendor_Name", dtMainData.Rows[0]["Vendor_Name"].ToString(), par4);
ParameterFields par5 = new ParameterFields();
AddParameter("paraVendor", dtMainData.Rows[0]["Vendor"].ToString(), par5);
ParameterFields par6 = new ParameterFields();
AddParameter("paraReturn_No", dtMainData.Rows[0]["Return_No"].ToString(), par6);
ParameterFields par7 = new ParameterFields();
AddParameter("paraTax_Total_Amt", dtMainData.Rows[0]["Tax_Total_Amt"].ToString(), par7);
ParameterFields par8 = new ParameterFields();
AddParameter("paraUnTax_Total_Amt", dtMainData.Rows[0]["UnTax_Total_Amt"].ToString(), par8);
ParameterFields par9 = new ParameterFields();
AddParameter("paraTax_Amt", dtMainData.Rows[0]["Tax_Amt"].ToString(), par9);
//this.CryView.ReportSource = null;
//this.CryView.ParameterFieldInfo.Add(par1[0]);
//this.CryView.ParameterFieldInfo.Add(par2[0]);
//this.CryView.ParameterFieldInfo.Add(par3[0]);
//this.CryView.ParameterFieldInfo.Add(par4[0]);
//this.CryView.ParameterFieldInfo.Add(par5[0]);
//this.CryView.ParameterFieldInfo.Add(par6[0]);
//this.CryView.ParameterFieldInfo.Add(par7[0]);
//this.CryView.ParameterFieldInfo.Add(par8[0]);
//this.CryView.ParameterFieldInfo.Add(par9[0]);
//this.CryView.ReportSource = report;
}
else
{
string strErr = "尚未更新資料，請先更新資料";
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VGR012", "alert('" + strErr + "');", true);
return;
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
private void UpdateForm()
{
string MainID = Request.QueryString["ID"].ToString();
ErrorMsgLabel.Text = "";
string UserID = Session["UID"].ToString();
string strNow = DateTime.Now.ToString("yyyyMMddHHmmss");
string ReturnNO = this.txtRemoveNo.Text;
string strErr = "";
DataSet Ds = new DataSet();
if (MasterOLDData.InnerHtml != "")
{
System.IO.StringReader sr = new System.IO.StringReader(MasterOLDData.InnerHtml);
Ds.ReadXml(sr);
}
try
{
VGRModel.MaintainReturnData BCOVGR = new VGRModel.MaintainReturnData(ConntionDB);
//更新GridView資料
for (int i = 0; i < GridView1.Rows.Count; i++)
{
Label lblItem = (Label)GridView1.Rows[i].FindControl("lblItem");
Label lblPeriod = (Label)GridView1.Rows[i].FindControl("lblPeriod");
Label lblOnhdQty = (Label)GridView1.Rows[i].FindControl("lblOnhdQty");
Label lblRemainQty = (Label)GridView1.Rows[i].FindControl("lblRemainQty");
TextBox txtReturnQty = (TextBox)GridView1.Rows[i].FindControl("txtReturnQty");
HtmlInputHidden hidRQty = (HtmlInputHidden)GridView1.Rows[i].FindControl("hidRQty");
HtmlInputHidden hidRQty2 = (HtmlInputHidden)GridView1.Rows[i].FindControl("hidRQty2");
for (int x = 0; x < Ds.Tables[0].Rows.Count; x++)
{
string Item = Ds.Tables[0].Rows[x]["item"].ToString();
string Period = Ds.Tables[0].Rows[x]["period"].ToString();
if (lblItem.Text == Item && lblPeriod.Text == Period)
{
if (int.Parse(txtReturnQty.Text) + int.Parse(lblOnhdQty.Text) >= 0)
{
Ds.Tables[0].Rows[x]["return_qty"] = txtReturnQty.Text;
Ds.Tables[0].Rows[x]["remain_qty"] = (int.Parse(lblOnhdQty.Text) - int.Parse(txtReturnQty.Text)).ToString();
if (txtReturnQty.Text != hidRQty2.Value)
{
Ds.Tables[0].Rows[x]["isChange"] = "Y";
isChange = "Y";
}
break;
}
else
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "隨便寫", "document.getElementById('" + txtReturnQty.ClientID + "').focus();", true);
return;
}
}
}
}
if (isChange != "Y")
{
strErr = "尚未更新資料，請先更新資料";
this.ErrorMsgLabel.Text = strErr;
return;
}
#region 檢查輸入完整性
if (SLP_Vendor.Text == string.Empty)
{
strErr = "請輸入供應商 ";
this.ErrorMsgLabel.Text = strErr;
return;
}
Ds.Tables[0].Columns.Remove("old_return_qty");
//調整數量所造成的稅方面的影響
//改由DB負責
//CalcuTotalTax(Ds.Tables[0]);
ParameterList.Clear();
ParameterList.Add(UserID);
ParameterList.Add(strNow);
ParameterList.Add(ReturnNO);
ParameterList.Add(0);
ParameterList.Add(0);
ParameterList.Add(0);
ParameterList.Add(0);
ParameterList.Add(0);
ParameterList.Add(MainID);
ParameterList.Add(this.hid_UpdateTime.Value);
DataTable dtUpdate = Ds.Tables[0].Clone();
for (int j = 0; j < Ds.Tables[0].Rows.Count; j++)
{
DataRow dr = dtUpdate.NewRow();
if (Ds.Tables[0].Rows[j]["isChange"].ToString() == "Y")
{
for (int k = 0; k < Ds.Tables[0].Rows[j].ItemArray.Length; k++)
{
dr[k] = Ds.Tables[0].Rows[j][k];
}
dtUpdate.Rows.Add(dr);
}
}
dtUpdate.Columns.Remove("item_name");
dtUpdate.Columns.Remove("remain_qty");
dtUpdate.Columns.Remove("isChange");
bool UpdateSuccess = BCOVGR.UpdateReturnData(ParameterList, dtUpdate, null);
if (UpdateSuccess != true)
{
throw new Exception("更新失敗!");
}
ArrayList IDList = new ArrayList();
IDList.Add(MainID);
Session["VGR01QueryID"] = IDList;
Response.Redirect(string.Format("VGR012.aspx?ID={0}&Code=VGR01&PageMode=1", MainID));
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
protected void btnReturnPick_Click(object sender, EventArgs e)
{
if ((bool)Session["btnClose"] != true)
{
Session["btnClose"] = null;
if (Session["dtVGRItemSelected"] != null)
{
Session["dtVGRItemSelected"] = null;
}
return;
}
string SessionIDName = "VGR01_DTL_" + PageTimeStamp.Value;
ErrorMsgLabel.Text = "";
string strErr = "";
string strTaxType = "";
DataTable dtPicker;
if (Session["dtVGRItemSelected"] != null)
{
dtPicker = (DataTable)Session["dtVGRItemSelected"];
}
else
{
strErr = "未選擇商品資訊 ";
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "VGR012", "alert('" + strErr + "');", true);
return;
}
#region 判斷新增的資料
DataTable Dt = null;
DataSet Ds = new DataSet();
if (MasterOLDData.InnerHtml != "")
{
System.IO.StringReader sr = new System.IO.StringReader(MasterOLDData.InnerHtml);
Ds.ReadXml(sr);
}
try
{
if (Ds.Tables.Count == 0)
{
//從DB讀取一空table回來
VGRModel.MaintainReturnData BCOVGR = new VGRModel.MaintainReturnData(ConntionDB);
ParameterList.Clear();
Dt = BCOVGR.QueryReturnDetlEmpty();
}
else
{
//變更DATATABLE 資料內容
for (int i = 0; i < GridView1.Rows.Count; i++)
{
Label lblItem = (Label)GridView1.Rows[i].FindControl("lblItem");
Label lblPeriod = (Label)GridView1.Rows[i].FindControl("lblPeriod");
Label lblOnhdQty = (Label)GridView1.Rows[i].FindControl("lblOnhdQty");
TextBox txtReturnQty = (TextBox)GridView1.Rows[i].FindControl("txtReturnQty");
for (int x = 0; x < Ds.Tables[0].Rows.Count; x++)
{
string Item = Ds.Tables[0].Rows[x]["item"].ToString();
string Period = Ds.Tables[0].Rows[x]["period"].ToString();
if (lblItem.Text == Item && lblPeriod.Text == Period)
{
if (int.Parse(txtReturnQty.Text) + int.Parse(lblOnhdQty.Text) >= 0)
{
Ds.Tables[0].Rows[x]["return_qty"] = txtReturnQty.Text;
Ds.Tables[0].Rows[x]["remain_qty"] = (int.Parse(lblOnhdQty.Text) - int.Parse(txtReturnQty.Text)).ToString();
if (int.Parse(lblOnhdQty.Text) - int.Parse(txtReturnQty.Text) > 0)
{
Ds.Tables[0].Rows[x]["adjust_qty"] = "0";
}
else
{
Ds.Tables[0].Rows[x]["adjust_qty"] = ((int.Parse(lblOnhdQty.Text) - int.Parse(txtReturnQty.Text)) * -1).ToString();
}
break;
}
else
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "隨便寫", "document.getElementById('" + txtReturnQty.ClientID + "').focus();", true);
return;
}
}
}
}
Dt = Ds.Tables[0];
}
for (int RowNum = 0; RowNum < dtPicker.Rows.Count; RowNum++)
{
//檢查是否有重複的品項、期別、儲位
bool haveData = false;
ArrayList TaxList = new ArrayList();
TaxList = TaxTypeList;
for (int i = 0; i <= Dt.Rows.Count - 1; i++)
{
if (Dt.Rows[i]["item"].ToString() == dtPicker.Rows[RowNum]["item"].ToString() &&
(Dt.Rows[i]["period"].ToString() == dtPicker.Rows[RowNum]["period"].ToString()))
{
haveData = true;
Dt.Rows[i]["item_name"] = dtPicker.Rows[RowNum]["item_name"].ToString();
Dt.Rows[i]["price"] = int.Parse(dtPicker.Rows[RowNum]["price"].ToString());
Dt.Rows[i]["onhd_qty"] = int.Parse(dtPicker.Rows[RowNum]["onhd_qty"].ToString());
Dt.Rows[i]["return_qty"] = int.Parse(dtPicker.Rows[RowNum]["return_qty"].ToString());
Dt.Rows[i]["old_return_qty"] = int.Parse(dtPicker.Rows[RowNum]["return_qty"].ToString());
Dt.Rows[i]["adjust_qty"] = int.Parse(dtPicker.Rows[RowNum]["adjust_qty"].ToString());
Dt.Rows[i]["remain_qty"] = int.Parse(dtPicker.Rows[RowNum]["remain_qty"].ToString());
Dt.Rows[i]["cost"] = double.Parse(dtPicker.Rows[RowNum]["cost"].ToString());
Dt.Rows[i]["tax_type"] = dtPicker.Rows[RowNum]["tax_type"].ToString();
Dt.Rows[i]["isChange"] = "N";
}
}
if (haveData != true)
{
strTaxType = dtPicker.Rows[RowNum]["tax_type"].ToString();
bool InList = false;
//紀錄TaxType類型
for (int j = 0; j < TaxList.Count; j++)
{
if (strTaxType == TaxList[j].ToString())
{
InList = true;
}
}
if (InList == false)
{
TaxList.Add(strTaxType);
}
TaxTypeList = TaxList;
tempID = 0;
DataView tempDT = new DataView();
tempDT.Table = Dt.Copy();
tempDT.Sort = "ID ASC";
if (Dt.Rows.Count != 0)
{
tempID = Convert.ToInt32(tempDT[Dt.Rows.Count - 1]["ID"].ToString());
}
DataRow dRow = Dt.NewRow();
//ID和CODE暫自訂, 真正寫入CO時會重取
int v_ID = tempID + 1;
int v_CODE = tempID + 1;
dRow["item"] = dtPicker.Rows[RowNum]["item"].ToString();
dRow["period"] = dtPicker.Rows[RowNum]["period"].ToString();
dRow["item_name"] = dtPicker.Rows[RowNum]["item_name"].ToString();
dRow["price"] = int.Parse(dtPicker.Rows[RowNum]["price"].ToString());
dRow["onhd_qty"] = int.Parse(dtPicker.Rows[RowNum]["onhd_qty"].ToString());
dRow["return_qty"] = int.Parse(dtPicker.Rows[RowNum]["return_qty"].ToString());
dRow["old_return_qty"] = int.Parse(dtPicker.Rows[RowNum]["return_qty"].ToString());
dRow["remain_qty"] = int.Parse(dtPicker.Rows[RowNum]["remain_qty"].ToString());
dRow["adjust_qty"] = int.Parse(dtPicker.Rows[RowNum]["adjust_qty"].ToString());
dRow["cost"] = double.Parse(dtPicker.Rows[RowNum]["cost"].ToString());
dRow["tax_type"] = dtPicker.Rows[RowNum]["tax_type"].ToString();
dRow["isChange"] = "N";
dRow["ID"] = v_ID;
Dt.Rows.Add(dRow);
}
}
#region 使用XML放置到前端資料
MasterOLDData.InnerHtml = Dt.DataSet.GetXml();
hid_CurrentVendor.Value = SLP_Vendor.Text;
#endregion
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
GridView1.DataBind();
GridView1.Columns[8].Visible = false;
GridView1.Columns[9].Visible = false;
CalcuTotalRemove(Dt);
//改由db計算
//CalcuTotalTax(Dt);
for (int i = 0; i < GridView1.Rows.Count; i++)
{
TextBox txtReturnQty = (TextBox)GridView1.Rows[i].FindControl("txtReturnQty");
Label lblReturnQty = (Label)GridView1.Rows[i].FindControl("lblReturnQty");
txtReturnQty.Visible = true;
lblReturnQty.Visible = false;
}
Session["dtVGRItemSelected"] = null;
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
private void SelectAll()
{
//新程式
string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
ErrorMsgLabel.Text = "";
try
{
VGRModel.MaintainReturnData BCOIVM = new VGRModel.MaintainReturnData(ConnectionDB);
dtClassAndItemSelected = BCOIVM.GetStockByVendor(Vendor, SLP_RootNo.Text, LocateSection);
Session[SessionIDName] = dtClassAndItemSelected;
GridView1.DataSource = dtClassAndItemSelected;
GridView1.PageSize = 20;
//GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
GridView1.SelectedIndex = -1;
if (dtClassAndItemSelected == null || (dtClassAndItemSelected != null && dtClassAndItemSelected.Rows.Count <= 0))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('查無資料');", true);
return;
}
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox chk_Sgl = (CheckBox)GridView1.Rows[i].FindControl("chk_Sgl");
chk_Sgl.Checked = true;
}
CheckBox chbAll = (CheckBox)GridView1.HeaderRow.FindControl("chbAll");
chbAll.Checked = true;
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.ToString();
}
}
private void dataBind()
{
ErrorMsgLabel.Text = "";
string SessionIDName = "VGR011_" + PageTimeStamp.Value;
VGRModel.MaintainReturnData BCOVGR = new VGRModel.MaintainReturnData(ConntionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Add(txtReturnNo.Text);
ParameterList.Add(SLP_Date.Text);
ParameterList.Add(SLP_Vendor.Text);
ParameterList.Add(SLP_Item.Text);
ParameterList.Add(SLP_Period.Text);
ParameterList.Add(int.Parse(TextBoxRowCountLimit.Text));
DataTable Dt = BCOVGR.QueryMainByFind(ParameterList);
if (Dt.Rows.Count == 0)
{
this.ErrorMsgLabel.Text = "查無資料";
}
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
ArrayList IDList = new ArrayList();
for (int i = 0; i < Dt.Rows.Count; i++)
{
IDList.Add(Dt.Rows[i]["ID"].ToString());
}
Session["VGR01QueryID"] = IDList;
//設定分頁大小
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
//
GridView1.PageIndex = 0;
GridView1.DataBind();
}
public bool GetBarCodeData(string FullBarCode, string LocateSection, out string Item, out string Period, out int OnHd_Qty, out Double Cost)
{
try
{
bool HaveDate = false;
Item = string.Empty;
Period = string.Empty;
string Vendor = "";
OnHd_Qty = 0;
int Price = 0;
Cost = 0;
string TaxType = "";
DBOVGR.MaintainReturnData CheckBarCode = new DBOVGR.MaintainReturnData(strConn);
HaveDate = CheckBarCode.GetBarCodeData(FullBarCode, LocateSection, out Item, out Period, out Vendor, out OnHd_Qty, out Price, out Cost, out TaxType);
if (Item != string.Empty && Period != string.Empty)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw ex;
}
}