public string CheckVAMClosedYN(string Apl_Date)
{
try
{
DBO.MaintainChanReturnData db = new MaintainChanReturnData(ref USEDB);
return db.CheckVAMClosedYN(Apl_Date);
}
catch (Exception ex)
{
throw ex;
}
}
public string GetBUSDate()
{
try
{
DBO.MaintainChanReturnData db = new MaintainChanReturnData(ref USEDB);
return db.GetBUSDate();
}
catch (Exception ex)
{
throw ex;
}
}
private DataTable queryData()
{
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
ParameterList.Clear();
//if (Request.QueryString["ID"] != null)
//{
// ParameterList.Add(Request.QueryString["ID"].ToString());
//}
//else
//{
// ParameterList.Add(CraeteMainID);
//}
ParameterList.Add(Session["UID"].ToString());
DataTable Dt = BCO.GetImpErrData(ParameterList);
return Dt;
}
/// <summary>
/// databind 繫結查詢資料到GridView1
/// </summary>
private void databind()
{
//抓取本頁初次登記的時間
string SessionIDName = "VGR021_" + PageTimeStamp.Value;
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
DataTable Dt;
ParameterList.Add(this.txtBatchNo.Text);
ParameterList.Add(this.SLP_SLPDate1.Text);
ParameterList.Add(this.SLP_SLPDate2.Text);
ParameterList.Add(this.SLP_StoreChain1.Text);
ParameterList.Add(this.SLP_Store1.Text);
ParameterList.Add(this.txtChanSourceNo.Text);
if (this.rdoStatus.SelectedValue == " ")
ParameterList.Add(null);
else
ParameterList.Add(this.rdoStatus.SelectedValue);
ParameterList.Add(this.SLP_SKU1.Text);
ParameterList.Add(this.SLP_ItemPeriod1.Text);
ParameterList.Add(int.Parse(this.TextBoxRowCountLimit.Text));
Dt = BCO.QueryMainByLike(ParameterList);
if (Dt.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR021.aspx", "alert(' 查無資料 ');", true);
}
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
ArrayList IDList = new ArrayList();
ArrayList Batch_NoList = new ArrayList();
ArrayList Chan_NoList = new ArrayList();
ArrayList Sign_DateList = new ArrayList();
ArrayList P_DATEList = new ArrayList();
ArrayList StoreList = new ArrayList();
ArrayList Chan_Source_NoList = new ArrayList();
ArrayList STATUS_EXPLAINList = new ArrayList();
ArrayList UPDATEDATEList = new ArrayList();
ArrayList UPDATEUIDList = new ArrayList();
for (int i = 0; i < Dt.Rows.Count; i++)
{
IDList.Add(Dt.Rows[i]["ID"].ToString());
Batch_NoList.Add(Dt.Rows[i]["Batch_No"].ToString());
Chan_NoList.Add(Dt.Rows[i]["Chan_No"].ToString());
Sign_DateList.Add(Dt.Rows[i]["Sign_Date"].ToString());
P_DATEList.Add(Dt.Rows[i]["P_DATE"].ToString());
StoreList.Add(Dt.Rows[i]["Store"].ToString());
Chan_Source_NoList.Add(Dt.Rows[i]["Chan_Source_No"].ToString());
STATUS_EXPLAINList.Add(Dt.Rows[i]["Status"].ToString());
UPDATEDATEList.Add(DateTime.Parse(Dt.Rows[i]["UPDATEDATE"].ToString()).ToString("yyyyMMddHHmmssfffff"));
UPDATEUIDList.Add(Dt.Rows[i]["UPDATEUID"].ToString());
}
Session["VGR02QueryID"] = IDList;
Session["VGR02QueryBatch_No"] = Batch_NoList;
Session["VGR02QueryChan_No"] = Chan_NoList;
Session["VGR02QuerySign_Date"] = Sign_DateList;
Session["VGR02QueryP_DATE"] = P_DATEList;
Session["VGR02QueryStore"] = StoreList;
Session["VGR02QueryChan_Source_No"] = Chan_Source_NoList;
Session["VGR02QuerySTATUS_EXPLAIN"] = STATUS_EXPLAINList;
Session["VGR02QueryUPDATEDATE"] = UPDATEDATEList;
Session["VGR02QueryUPDATEUID"] = UPDATEUIDList;
//設定分頁大小
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
//
GridView1.PageIndex = 0;
GridView1.DataBind();
}
private void databind_Dtl()
{
try
{
string SessionIDName = "VGR02_DTL_" + PageTimeStamp.Value;
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
ParameterList.Clear();
if (Request.QueryString["ID"] != null)
{
ParameterList.Add(int.Parse(Request.QueryString["ID"].ToString()));
}
else if (Session["PID"] != null && Session["PID"].ToString() != "")
{
ParameterList.Add(int.Parse(Session["PID"].ToString()));
}
else
{
ParameterList.Add(int.Parse("999999"));
}
DataTable Dt = BCO.QueryByID(ParameterList);
iDetlRowsCount = Dt.Rows.Count;
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
OldDt = Dt;
dtForBrowse = Dt;
GridView1.PageIndex = 0;
GridView1.DataBind();
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
public static string QueryChanReturn(string strP_DATE, string strStore)
{
string strResult = string.Empty;
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
ParameterList.Clear();
ParameterList.Add(strP_DATE);
ParameterList.Add(strStore);
DataTable dt = BCO.QueryChanReturnToday(ParameterList);
if (dt.Rows.Count != 0)
{
strResult = "今日已有此門市之通路退貨單,確定新增?";
}
else
{
strResult = "";
}
return strResult;
}
private bool QueryChanReturnToday(string strP_DATE, string strStore)
{
bool Result = false;
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
ParameterList.Clear();
ParameterList.Add(strP_DATE);
ParameterList.Add(strStore);
DataTable dt = BCO.QueryChanReturnToday(ParameterList);
if (dt.Rows.Count != 0)
{
Result = true;
}
else
{
Result = false;
}
return Result;
}
public void doInsert()
{
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
string strBatchNo = "";
int iPID = 0;
ParameterList.Clear();
ParameterList.Add(DateTime.Parse(SLP_SLPDate1.Text));
ParameterList.Add(DateTime.Parse(SLP_SLPDate2.Text));
ParameterList.Add(SLP_StoreChain1.Text);
ParameterList.Add(SLP_Store1.Text);
ParameterList.Add(txtChanSourceNo.Text);
ParameterList.Add("25");
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
for (int i = 0; i < GridView1.Rows.Count; i++)
{
string strItem = ((Label)this.GridView1.Rows[i].FindControl("lblItem")).Text;
string strPeriod = ((Label)this.GridView1.Rows[i].FindControl("lblPeriod")).Text;
foreach (DataRow dr in dtForBrowse.Rows)
{
if (dr.RowState != DataRowState.Deleted)
{
if (dr["ITEM"].ToString() == strItem && dr["PERIOD"].ToString() == strPeriod)
{
if (((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text.Trim() != "")
{
dr["BACKWARD_QTY"] = ((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text;
}
else
{
dr["BACKWARD_QTY"] = 0;
((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text = "0";
}
}
}
}
}
BCO.CreateChanReturnData(ParameterList, dtForBrowse, DBT, Session["UID"].ToString(), DateTime.Parse(PageTimeStamp.Value), out strBatchNo, out iPID);
this.txtBatchNo.Text = strBatchNo;
Session["BatchNo"] = strBatchNo;
Session["PageMode"] = "2";
#region 記錄Session
ArrayList IDList = new ArrayList();
ArrayList Batch_NoList = new ArrayList();
ArrayList Chan_NoList = new ArrayList();
ArrayList Sign_DateList = new ArrayList();
ArrayList P_DATEList = new ArrayList();
ArrayList StoreList = new ArrayList();
ArrayList Chan_Source_NoList = new ArrayList();
ArrayList STATUS_EXPLAINList = new ArrayList();
ArrayList UPDATEDATEList = new ArrayList();
ArrayList UPDATEUIDList = new ArrayList();
IDList.Add(iPID.ToString());
Batch_NoList.Add(strBatchNo);
Chan_NoList.Add(SLP_StoreChain1.Text);
Sign_DateList.Add(DateTime.Parse(SLP_SLPDate1.Text).ToString());
P_DATEList.Add(DateTime.Parse(SLP_SLPDate2.Text).ToString());
StoreList.Add(SLP_Store1.Text);
Chan_Source_NoList.Add(txtChanSourceNo.Text);
STATUS_EXPLAINList.Add("25");
UPDATEDATEList.Add(DateTime.Parse(PageTimeStamp.Value).ToString("yyyyMMddHHmmssfffff"));
UPDATEUIDList.Add(Session["UID"].ToString());
Session["VGR02QueryID"] = IDList;
Session["VGR02QueryBatch_No"] = Batch_NoList;
Session["VGR02QueryChan_No"] = Chan_NoList;
Session["VGR02QuerySign_Date"] = Sign_DateList;
Session["VGR02QueryP_DATE"] = P_DATEList;
Session["VGR02QueryStore"] = StoreList;
Session["VGR02QueryChan_Source_No"] = Chan_Source_NoList;
Session["VGR02QuerySTATUS_EXPLAIN"] = STATUS_EXPLAINList;
Session["VGR02QueryUPDATEDATE"] = UPDATEDATEList;
Session["VGR02QueryUPDATEUID"] = UPDATEUIDList;
#endregion
Response.Redirect(string.Format("VGR022.aspx?ID=" + iPID + "&PageMode=1&Batch_No=" + strBatchNo + "&Chan_No=" + SLP_StoreChain1.Text + "&Sign_Date=" + SLP_SLPDate1.Text + "&P_DATE=" + SLP_SLPDate2.Text + "&Store=" + SLP_Store1.Text + "&Chan_Source_No=" + txtChanSourceNo.Text + "&STATUS_EXPLAIN=" + "25&UPDATEUID=" + Session["UID"].ToString() + "&UPDATEDATE=" + DateTime.Parse(PageTimeStamp.Value).ToString("yyyyMMddHHmmssfffff")));
}
public DataTable QueryMainByFind(ArrayList ParameterList)
{
try
{
DBO.MaintainChanReturnData db = new MaintainChanReturnData(ref USEDB);
return db.QueryMainByFind(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
}//Page_Load
protected void btn_ConfirmRank_Click(object sender, EventArgs e)
{
//lblCount.Text = FileUpload1.PostedFile.FileName;
//lblQty.Text = FileUpload1.TemplateSourceDirectory;
if (this.FileUpload1.HasFile)
{
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR023.aspx", "alert(' " + FileUpload1.AppRelativeTemplateSourceDirectory + " ');", true);
try
{
string[] bResult;
string[] bResult1;
if (FileUpload1.HasFile)
{
//if (System.IO.Path.GetFileName(FileUpload1.FileName).IndexOf(ddlGroupDDD.SelectedItem.Text) == -1)
//{
// ErrorMsgLabel.Text = "輸入之檔名非此店群統稱";
// return;
//}
string tempDir = Server.MapPath("..\\") + System.Configuration.ConfigurationManager.AppSettings["UploadPath"] + "VGR\\";
string backupDir = Server.MapPath("..\\") + System.Configuration.ConfigurationManager.AppSettings["BackPath"] + "VGR\\";
string strfileExtension = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();//副檔名
string strfileWithoutExtension = System.IO.Path.GetFileNameWithoutExtension(FileUpload1.FileName).ToLower();//檔名
string strFileName = strfileWithoutExtension + DateTime.Now.ToString("yyyyMMddHHmmss") + strfileExtension;
//FileUpload1.SaveAs(tempDir + strFileName);
string user = Session["UID"].ToString();
MaintainChanReturnData bco = new MaintainChanReturnData(ConntionDB);
//CAMCommon bco1 = new CAMCommon();
//DbTransaction transaction = bco.GetTransaction();
try
{
try
{
using (StreamReader sr = new StreamReader(FileUpload1.FileContent, System.Text.Encoding.GetEncoding(950)))
{
string s = null;
bco.DoDelImportFile();
while ((s = sr.ReadLine()) != null)
{
if (s.Trim() != "")
bco.DoImportFile(s);
//ParameterList.Clear();
//ParameterList.Add(DateTime.Parse(Request.QueryString["BackWardDate"].ToString()));
////ParameterList.Add(Request.QueryString["ChanNo"].ToString());
////ParameterList.Add(Request.QueryString["Store"].ToString());
//ParameterList.Add(Session["StoreChain"].ToString());
//ParameterList.Add(Session["Store"].ToString());
//ParameterList.Add(Request.QueryString["IsCheck"].ToString());
//ParameterList.Add(Session["UID"].ToString());
//if (s.Length > 52 && s.Substring(36, 10).Trim() != "" && s.Substring(46, 6).Trim() != "")
//{
// ParameterList.Add(s.Substring(36,10));
// ParameterList.Add(s.Substring(46, 6));
//}
////bResult = bco.DoImportCheck(ParameterList);
//DataTable dtResult = bco.DoImportCheck(ParameterList);
//if (dtResult.Rows.Count > 0)
//{
// lblCount.Text = dtResult.Rows[0][0].ToString();
// lblQty.Text = dtResult.Rows[0][1].ToString();
// lblErrQty.Text = dtResult.Rows[0][2].ToString();
//}
}
sr.Close();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' " + ex.Message + " ');", true);
}
#region 轉入系統
////轉入
ParameterList.Clear();
ParameterList.Add(DateTime.Parse(Request.QueryString["BackWardDate"].ToString()));
//ParameterList.Add(Request.QueryString["ChanNo"].ToString());
//ParameterList.Add(Request.QueryString["Store"].ToString());
ParameterList.Add(Session["StoreChain"].ToString());
ParameterList.Add(Session["Store"].ToString());
ParameterList.Add(Request.QueryString["IsCheck"].ToString());
ParameterList.Add(Session["UID"].ToString());
//bResult = bco.DoImportCheck(ParameterList);
DataTable dtResult = bco.DoImportCheck(ParameterList);
if (dtResult.Rows.Count > 0)
{
lblCount.Text = dtResult.Rows[0][0].ToString();
lblQty.Text = dtResult.Rows[0][1].ToString();
lblErrQty.Text = dtResult.Rows[0][2].ToString();
}
dtForBrowse = bco.GetImpData(Session["UID"].ToString());
gv_Result.DataSource = dtForBrowse;
gv_Result.DataBind();
#endregion
//System.IO.File.Move(tempDir + strFileName, backupDir + strFileName);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' " + "載入失敗，請檢查檔案格式：" + ex.Message + " ');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' 請輸入檔案路徑 ');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' " + ex.Message + " ');", true);
}
finally { }
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' 請先選擇檔案 ');", true);
}
}
//更新鈕
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (this.SLP_SKU1.Text.Trim() == "" || this.SLP_ItemPeriod1.Text.Trim() == "" || this.SLP_AdjustQty.Text.Trim() == "")
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 新增明細輸入不完全! ');", true);
pnlAdd.Visible = true;
}
else
{
if (SLP_AdjustQty.Text.Trim() == "0")
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert('退貨數量請輸入0以外的正整數! ');", true);
pnlAdd.Visible = true;
}
else
{
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
ParameterList.Clear();
ParameterList.Add(this.txtBarCode.Text);
ParameterList.Add(this.SLP_StoreChain1.Text);
ParameterList.Add(this.SLP_Store1.Text);
ParameterList.Add(DateTime.Parse(this.SLP_SLPDate1.Text));
ParameterList.Add(SLP_SKU1.Text);
ParameterList.Add(SLP_ItemPeriod1.Text);
string strItem; string strPeriod; decimal iPrice; DateTime DChanEndDate; string strMSG; string strRESULT;
BCO.GetItemByBarCode(ParameterList, out strItem, out strPeriod, out iPrice, out DChanEndDate, out strMSG, out strRESULT);
if (strItem != string.Empty)
{
//this.SLP_SKU1.Text = strItem;
//this.SLP_ItemPeriod1.Text = strPeriod;
this.h_ChanPrice.Value = iPrice.ToString();
if (DChanEndDate.ToString("yyyy/MM/dd") != "1900/01/01")
this.h_ChanEndDate.Value = DChanEndDate.ToString("yyyy/MM/dd");
//this.SLP_AdjustQty.Text = "1";
//pnlAdd.Visible = true;
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 無此牌價資料! ');", true);
pnlAdd.Visible = true;
return;
}
if (strMSG != string.Empty)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' " + strMSG + " ');", true);
pnlAdd.Visible = true;
return;
}
try
{
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
string strITEM = ((Label)this.GridView1.Rows[i].FindControl("lblItem")).Text;
string strPERIOD = ((Label)this.GridView1.Rows[i].FindControl("lblPeriod")).Text;
string strBACKWARD_QTY = ((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text;
if (strITEM == SLP_SKU1.Text && strPERIOD == SLP_ItemPeriod1.Text)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 此商品已存在明細中! ');", true);
pnlAdd.Visible = true;
//TextBox txtSKU = (TextBox)this.SLP_SKU1.FindControl("TextBoxCode");//訂單擷轉日
//ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "隨便寫", "document.getElementById('" + txtSKU.ClientID + "').focus();", true);
return;
}
}
DataRow dRow = dtForBrowse.NewRow();
string strID = "";
if (Request.QueryString["ID"] != null)
{
strID = Request.QueryString["ID"].ToString();
}
else
{
strID = CraeteMainID;
}
dRow["item"] = SLP_SKU1.Text;
dRow["item_name"] = SLP_SKU1.Name;
dRow["period"] = SLP_ItemPeriod1.Text;
dRow["Chan_Price"] = h_ChanPrice.Value;
if (h_ChanEndDate.Value != "")
dRow["Chan_End_Date"] = h_ChanEndDate.Value;
dRow["BackWard_Qty"] = SLP_AdjustQty.Text;
dRow["PID"] = 0;
dRow["UPDATEUID"] = Session["UID"].ToString();
dRow["UPDATEDATE"] = DateTime.Parse(PageTimeStamp.Value);
dRow["CREATEUID"] = Session["UID"].ToString();
dRow["CREATEDATE"] = DateTime.Parse(PageTimeStamp.Value);
dtForBrowse.Rows.Add(dRow);
GridView1.DataSource = dtForBrowse;
GridView1.DataBind();
//dtForBrowse = OldDt;
ClearAddDetail();
SetClinetFocus(txtBarCode.ClientID);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
}
}
//刪除鈕
protected void btnDel_Click(object sender, EventArgs e)
{
try
{
if (ckbStatus.Checked)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 此表單已結轉不可刪除! ');", true);
}
else
{
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
BCO.doDelete(this.txtBatchNo.Text, DBT);
Response.Redirect(string.Format("VGR021.aspx?Code=VGR02"));
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
//儲存鈕
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
#region 在儲存前把畫面上的退貨數量再UPDATE回dtForBrowse一次
for (int i = 0; i < GridView1.Rows.Count; i++)
{
string strItem = ((Label)this.GridView1.Rows[i].FindControl("lblItem")).Text;
string strPeriod = ((Label)this.GridView1.Rows[i].FindControl("lblPeriod")).Text;
string strBackWardQty = ((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text.Trim();
DataRow dr_d = dtForBrowse.Select("ITEM = '" + strItem + "' and PERIOD = '" + strPeriod + "'")[0];
if (strBackWardQty != "")
{
if (strBackWardQty != "0")
{
if (strBackWardQty != dr_d["BACKWARD_QTY"].ToString())
{
dr_d["BACKWARD_QTY"] = strBackWardQty;
}
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert('退貨數量請輸入0以外的正整數! ');", true);
SetClinetFocus(((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).ClientID);
return;
}
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert('退貨數量請輸入0以外的正整數! ');", true);
SetClinetFocus(((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).ClientID);
return;
}
//foreach (DataRow dr in dtForBrowse.Rows)
//{
// if (dr.RowState != DataRowState.Deleted)
// {
// if (dr["ITEM"].ToString() == strItem && dr["PERIOD"].ToString() == strPeriod)
// {
// if (((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text.Trim() != "")
// {
// if (((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text.Trim() != "0")
// {
// if (((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text.Trim() != dr["BACKWARD_QTY"].ToString())
// {
// dr["BACKWARD_QTY"] = ((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text;
// }
// }
// else
// {
// ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert('退貨數量請輸入0以外的正整數! ');", true);
// SetClinetFocus(((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).ClientID);
// return;
// }
// }
// else
// {
// ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert('退貨數量請輸入0以外的正整數! ');", true);
// SetClinetFocus(((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).ClientID);
// return;
// //dr["BACKWARD_QTY"] = 0;
// //((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text = "0";
// }
// }
// }
//}
}
#endregion
if (CheckHaveDetailData())
{
ErrorMsgLabel.Text = "";
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
switch (Request["PageMode"])//編輯
{
case "2":
ParameterList.Clear();
ParameterList.Add(txtBatchNo.Text);
ParameterList.Add(txtChanSourceNo.Text);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
ParameterList.Add(GetUpdateUID());
ParameterList.Add(DateTime.ParseExact(GetUpdateDate(), "yyyyMMddHHmmssfffff", null));
BCO.DoUpdate(ParameterList, DBT);
UpdateViewState(Session["UID"].ToString(), DateTime.Parse(PageTimeStamp.Value).ToString("yyyyMMddHHmmssfffff"));
DataTable Dt_D = dtForBrowse.GetChanges(DataRowState.Deleted);
DataTable Dt_M = dtForBrowse.GetChanges(DataRowState.Modified);
DataTable Dt_A = dtForBrowse.GetChanges(DataRowState.Added);
string strID = string.Empty;
if (Dt_D != null)
{
if (Request.QueryString["ID"] != null)
{
strID = Request.QueryString["ID"].ToString();
}
else if (Session["PID"] != null && Session["PID"].ToString() != "")
{
strID = Session["PID"].ToString();
}
for (int x = 0; x < Dt_D.Rows.Count; x++)
{
ParameterList.Clear();
ParameterList.Add(int.Parse(strID));
ParameterList.Add(Dt_D.Rows[x]["ITEM", DataRowVersion.Original].ToString());
ParameterList.Add(Dt_D.Rows[x]["PERIOD", DataRowVersion.Original].ToString());
BCO.doDeleteDtl(ParameterList, DBT);
}
Dt_D.Clear();
}
if (Dt_M != null)
{
for (int y = 0; y < Dt_M.Rows.Count; y++)
{
ParameterList.Clear();
ParameterList.Add(int.Parse(Dt_M.Rows[y]["PID", DataRowVersion.Original].ToString()));
ParameterList.Add(Dt_M.Rows[y]["ITEM", DataRowVersion.Original].ToString());
ParameterList.Add(Dt_M.Rows[y]["PERIOD", DataRowVersion.Original].ToString());
ParameterList.Add(int.Parse(Dt_M.Rows[y]["BACKWARD_QTY", DataRowVersion.Current].ToString()));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
ParameterList.Add(Dt_M.Rows[y]["UPDATEUID"].ToString());
ParameterList.Add(DateTime.Parse(Dt_M.Rows[y]["UPDATEDATE", DataRowVersion.Original].ToString()));
BCO.UpdChanReturnData(ParameterList, DBT);
}
Dt_M.Clear();
}
if (Dt_A != null)
{
DateTime dtTemp;
for (int z = 0; z < Dt_A.Rows.Count; z++)
{
ParameterList.Clear();
ParameterList.Add(int.Parse(Request.QueryString["ID"].ToString()));
ParameterList.Add(Dt_A.Rows[z]["ITEM", DataRowVersion.Current].ToString());
ParameterList.Add(Dt_A.Rows[z]["PERIOD", DataRowVersion.Current].ToString());
ParameterList.Add(Decimal.Parse(Dt_A.Rows[z]["CHAN_PRICE", DataRowVersion.Current].ToString()));
if (DateTime.TryParse(Dt_A.Rows[z]["CHAN_END_DATE"].ToString(), out dtTemp))
{
ParameterList.Add(DateTime.Parse(Dt_A.Rows[z]["CHAN_END_DATE", DataRowVersion.Current].ToString()));
}
else
{
ParameterList.Add(DBNull.Value);
}
ParameterList.Add(int.Parse(Dt_A.Rows[z]["BACKWARD_QTY", DataRowVersion.Current].ToString()));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
BCO.DoInsertDetl(ParameterList, DBT);
}
Dt_A.Clear();
}
#region 舊程式碼
//for (int i = 0; i < GridView1.Rows.Count; i++)
//{
// ParameterList.Clear();
// bool bl = true;
// string strPID = ((Label)this.GridView1.Rows[i].FindControl("Label1")).Text;
// string strITEM = ((Label)this.GridView1.Rows[i].FindControl("lblItem")).Text;
// string strPERIOD = ((Label)this.GridView1.Rows[i].FindControl("lblPeriod")).Text;
// string strCREATEUID = ((Label)this.GridView1.Rows[i].FindControl("Label4")).Text;
// string strUPDATEUID = ((Label)this.GridView1.Rows[i].FindControl("Label2")).Text;
// string strUPDATEDATE = ((Label)this.GridView1.Rows[i].FindControl("Label3")).Text;
// string strCREATEDATE = ((Label)this.GridView1.Rows[i].FindControl("Label5")).Text;
// string strBACKWARD_QTY = ((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text;
// string strCHAN_PRICE = ((Label)this.GridView1.Rows[i].FindControl("lblChanPrice")).Text;
// string strChanEndDate = ((Label)this.GridView1.Rows[i].FindControl("lblChanEndDate")).Text;
// foreach (DataRow dr in OldDt.Rows)
// {
// bl = true;
// if (dr["ITEM"].ToString() == strITEM && dr["PERIOD"].ToString() == strPERIOD && dr["BACKWARD_QTY"].ToString() != strBACKWARD_QTY)
// {
// ParameterList.Add(int.Parse(strPID));
// ParameterList.Add(strITEM);
// ParameterList.Add(strPERIOD);
// ParameterList.Add(int.Parse(strBACKWARD_QTY));
// ParameterList.Add(Session["UID"].ToString());
// ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
// ParameterList.Add(dr["UPDATEUID"].ToString());
// ParameterList.Add(DateTime.Parse(dr["UPDATEDATE"].ToString()));
// BCO.UpdChanReturnData(ParameterList, DBT);
// bl = false;
// break;
// }
// else if (dr["ITEM"].ToString() == strITEM && dr["PERIOD"].ToString() == strPERIOD)
// {
// bl = false;
// break;
// }
// }
// if (bl)
// {
// string strBatchNo = "";
// int iPID = 0;
// ParameterList.Clear();
// ParameterList.Add(int.Parse(Request.QueryString["ID"].ToString()));
// ParameterList.Add(strITEM);
// ParameterList.Add(strPERIOD);
// ParameterList.Add(Decimal.Parse(strCHAN_PRICE));
// ParameterList.Add(DateTime.Parse(strChanEndDate));
// ParameterList.Add(int.Parse(strBACKWARD_QTY));
// ParameterList.Add(Session["UID"].ToString());
// ParameterList.Add(Session["UID"].ToString());
// ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
// ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
// BCO.DoInsertDetl(ParameterList, DBT);
// }
//}
#endregion
if (this.Request["ID"] != null)
Response.Redirect(string.Format("VGR022.aspx?ID=" + this.Request["ID"].ToString() + "&PageMode=1&Batch_No=" + this.Request["Batch_No"].ToString() + "&Chan_No=" + this.Request["Chan_No"].ToString() + "&Sign_Date=" + this.Request["Sign_Date"].ToString() + "&P_DATE=" + this.Request["P_DATE"].ToString() + "&Store=" + this.Request["Store"].ToString() + "&Chan_Source_No=" + txtChanSourceNo.Text + "&STATUS_EXPLAIN=" + this.Request["STATUS_EXPLAIN"].ToString() + "&UPDATEUID=" + Session["UID"].ToString() + "&UPDATEDATE=" + DateTime.Parse(PageTimeStamp.Value).ToString("yyyyMMddHHmmssfffff")));
else
Response.Redirect(string.Format("VGR022.aspx?ID=" + Session["PID"].ToString() + "&PageMode=1&Batch_No=" + txtBatchNo.Text + "&Chan_No=" + SLP_StoreChain1.Text + "&Sign_Date=" + SLP_SLPDate1.Text + "&P_DATE=" + SLP_SLPDate1.Text + "&Store=" + SLP_Store1.Text + "&Chan_Source_No=" + txtChanSourceNo.Text + "&STATUS_EXPLAIN=" + "25&UPDATEUID=" + Session["UID"].ToString() + "&UPDATEDATE=" + DateTime.Parse(PageTimeStamp.Value).ToString("yyyyMMddHHmmssfffff")));
break;
case "3"://新增
if (QueryChanReturnToday(SLP_SLPDate2.Text, SLP_Store1.Text) == false)
{
doInsert();
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "if(confirm('今日已有此門市之通路退貨單,確定新增?')){__doPostBack('doSave','');}", true);
}
break;
default:
break;
}
}
else
{
throw new Exception("請先輸入明細資料");
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
public DataTable QueryReturnDetlEmpty()
{
try
{
DBO.MaintainChanReturnData db = new MaintainChanReturnData(ref USEDB);
return db.QueryReturnEmpty();
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable QueryDetlByID(string MainID)
{
try
{
DBO.MaintainChanReturnData db = new MaintainChanReturnData(ref USEDB);
return db.QueryDetlByID(MainID);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnDel_Click(object sender, EventArgs e)
{
LinkButton lbt = sender as LinkButton;
rowid_mst = Convert.ToInt16(lbt.Attributes["rowid_mst"].ToString()) - (int.Parse(TextBoxPagesize.Text) * GridView1.PageIndex);
if (GridView1.Rows[rowid_mst].Cells[0].Text != "未結轉")
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR021.aspx", "alert(' 已結轉表單不可刪除! ');", true);
}
else
{
//抓取本頁初次登記的時間
string SessionIDName = "VGR021_" + PageTimeStamp.Value;
DataTable Dt = (DataTable)Session[SessionIDName];
//int result;
//string strID = GridView1.Rows[rowid_mst].Cells[1].Text;
string strID = ((Label)GridView1.Rows[rowid_mst].FindControl("Label9")).Text;
//VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
//ParameterList.Clear();
//ParameterList.Add(strID);
////ParameterList.Add();
////ParameterList.Add();
////ParameterList.Add();
////ParameterList.Add();
////db.AddInParameter(cmd, "V_OLD_BATCH_NO", DbType.String, ParameterList[0]);
////db.AddInParameter(cmd, "V_OLD_CREATEUID", DbType.String, ParameterList[1]);
////db.AddInParameter(cmd, "D_OLD_CREATEDATE", DbType.Date, ParameterList[2]);
////db.AddInParameter(cmd, "V_OLD_UPDATEUID", DbType.String, ParameterList[3]);
////db.AddInParameter(cmd, "D_OLD_UPDATEDATE", DbType.Date, ParameterList[4]);
//ArrayList ParameterList2 = new ArrayList();
////ParameterList2.Add();
//BCO.doDelete(ParameterList, ParameterList2, DBT);
//=============================================================================================
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
string strBatchNo = GridView1.Rows[rowid_mst].Cells[1].Text;
BCO.doDelete(strBatchNo, DBT);
databind();
//=============================================================================================
//DataRow dr = Dt.Select("ID = " + strID)[0];
//dr.Delete();
//GridView1.DataSource = Dt;
//GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
//if (lblErrQty.Text.Trim() != "0")
//{
// ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' 檔案有異常資料 ');", true);
// return;
//}
if (lblQty.Text.Trim() == "")
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' 請先預覽欲轉入檔案 ');", true);
return;
}
if (lblQty.Text.Trim() == "0")//正常筆數等於0
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' 無正常資料可轉入 ');", true);
return;
}
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
string strBatchNo = "";
int iPID = 0;
//================================================================================================
switch (Request["PageMode"])
{
case "2":
for (int i = 0; i < gv_Result.Rows.Count; i++)
{
ParameterList.Clear();
bool bl = true;
//string strPID = ((Label)this.GridView1.Rows[i].FindControl("Label1")).Text;
string strITEM = ((Label)this.gv_Result.Rows[i].FindControl("Label1")).Text;
string strPERIOD = ((Label)this.gv_Result.Rows[i].FindControl("Label3")).Text;
string strCREATEUID = Session["UID"].ToString();
string strUPDATEUID = Session["UID"].ToString();
//string strUPDATEDATE = ((Label)this.GridView1.Rows[i].FindControl("")).Text;
//string strCREATEDATE = ((Label)this.GridView1.Rows[i].FindControl("")).Text;
string strBACKWARD_QTY = ((Label)this.gv_Result.Rows[i].FindControl("Label6")).Text;
string strCHAN_PRICE = ((Label)this.gv_Result.Rows[i].FindControl("Label4")).Text;
string strChanEndDate = ((Label)this.gv_Result.Rows[i].FindControl("Label5")).Text;
ParameterList.Clear();
if (Request.QueryString["ID"] != null)
{
ParameterList.Add(int.Parse(Request.QueryString["ID"].ToString()));
}
else
{
ParameterList.Add(int.Parse("999999"));
}
DataTable OldDt = BCO.QueryByID(ParameterList);
foreach (DataRow dr in OldDt.Rows)
{
bl = true;
if (dr["ITEM"].ToString() == strITEM && dr["PERIOD"].ToString() == strPERIOD && dr["BACKWARD_QTY"].ToString() != strBACKWARD_QTY)
{
ParameterList.Clear();
ParameterList.Add(int.Parse(Request.QueryString["ID"].ToString()));
ParameterList.Add(strITEM);
ParameterList.Add(strPERIOD);
//ParameterList.Add(strCREATEUID);
//ParameterList.Add(strUPDATEUID);
//ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
//ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
ParameterList.Add(int.Parse(strBACKWARD_QTY));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
BCO.UpdChanReturnData(ParameterList, DBT);
bl = false;
break;
}
else if (dr["ITEM"].ToString() == strITEM && dr["PERIOD"].ToString() == strPERIOD)
{
bl = false;
break;
}
}
if (bl)
{
//string strBatchNo = "";
//int iPID = 0;
ParameterList.Clear();
ParameterList.Add(int.Parse(Request.QueryString["ID"].ToString()));
ParameterList.Add(strITEM);
ParameterList.Add(strPERIOD);
ParameterList.Add(Decimal.Parse(strCHAN_PRICE));
ParameterList.Add(DateTime.Parse(strChanEndDate));
ParameterList.Add(int.Parse(strBACKWARD_QTY));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
BCO.DoInsertDetl(ParameterList, DBT);
}
}
Session["PageMode"] = "1";
break;
case "3":
//string strBatchNo = "";
//int iPID = 0;
ParameterList.Clear();
ParameterList.Add(DateTime.Parse(Request.QueryString["BackWardDate"].ToString()));
ParameterList.Add(DateTime.Parse(Request.QueryString["P_Date"].ToString()));
//ParameterList.Add(Request.QueryString["ChanNo"].ToString());
//ParameterList.Add(Request.QueryString["Store"].ToString());
//ParameterList.Add(Request.QueryString["ChanSourceNo"].ToString());
ParameterList.Add(Session["StoreChain"].ToString());
ParameterList.Add(Session["Store"].ToString());
ParameterList.Add(Session["ChanSourceNo"].ToString());
ParameterList.Add("25");
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
BCO.CreateChanReturnData(ParameterList, dtForBrowse, DBT, Session["UID"].ToString(), DateTime.Parse(PageTimeStamp.Value), out strBatchNo, out iPID);
//this.txtBatchNo.Text = strBatchNo;
Session["PID"] = iPID.ToString();
Session["BatchNo"] = strBatchNo;
Session["PageMode"] = "2";
Session["STATUS_EXPLAIN"] = "25";
#region
ArrayList IDList = new ArrayList();
ArrayList Batch_NoList = new ArrayList();
ArrayList Chan_NoList = new ArrayList();
ArrayList Sign_DateList = new ArrayList();
ArrayList P_DATEList = new ArrayList();
ArrayList StoreList = new ArrayList();
ArrayList Chan_Source_NoList = new ArrayList();
ArrayList STATUS_EXPLAINList = new ArrayList();
ArrayList UPDATEDATEList = new ArrayList();
ArrayList UPDATEUIDList = new ArrayList();
IDList.Add(iPID.ToString());
Batch_NoList.Add(strBatchNo);
Chan_NoList.Add(Session["StoreChain"].ToString());
Sign_DateList.Add(DateTime.Parse(Request.QueryString["BackWardDate"].ToString()));
P_DATEList.Add(Request.QueryString["P_Date"].ToString());
StoreList.Add(Session["Store"].ToString());
Chan_Source_NoList.Add(Session["ChanSourceNo"].ToString());
STATUS_EXPLAINList.Add("25");
UPDATEDATEList.Add(DateTime.Parse(PageTimeStamp.Value).ToString("yyyyMMddHHmmssfffff"));
UPDATEUIDList.Add(Session["UID"].ToString());
Session["VGR02QueryID"] = IDList;
Session["VGR02QueryBatch_No"] = Batch_NoList;
Session["VGR02QueryChan_No"] = Chan_NoList;
Session["VGR02QuerySign_Date"] = Sign_DateList;
Session["VGR02QueryP_DATE"] = P_DATEList;
Session["VGR02QueryStore"] = StoreList;
Session["VGR02QueryChan_Source_No"] = Chan_Source_NoList;
Session["VGR02QuerySTATUS_EXPLAIN"] = STATUS_EXPLAINList;
Session["VGR02QueryUPDATEDATE"] = UPDATEDATEList;
Session["VGR02QueryUPDATEUID"] = UPDATEUIDList;
#endregion
break;
default:
break;
}
//================================================================================================
Response.Write("<script>window.returnValue= 'test';window.close();</script>");
//Response.Redirect(string.Format("VGR022.aspx?ID=" + iPID.ToString() + "&PageMode=1&Batch_No=" + strBatchNo + "&Chan_No=" + Session["StoreChain"].ToString() + "&Sign_Date=" + Request.QueryString["BackWardDate"].ToString() + "&P_DATE=" + Request.QueryString["P_Date"].ToString() + "&Store=" + Session["Store"].ToString() + "&Chan_Source_No=" + Session["ChanSourceNo"].ToString() + "&STATUS_EXPLAIN=" + "25" + ""));
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
//在輸入完條碼後的ENTER事件
protected void Button2_Click(object sender, EventArgs e)
{
try
{
int i = this.txtBarCode.Text.Trim().Length;
if (this.SLP_StoreChain1.Text.Trim() == "")
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 請先選擇通路! ');", true);
}
else if (this.SLP_Store1.Text.Trim() == "")
{ ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 請先選擇門市! ');", true); }
else if (this.SLP_SLPDate1.Text.Trim().Replace("/", "") == "")
{ ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 請先選擇簽收日! ');", true); }
else if (i != 8 && i != 10 && i != 12 && i != 13 && i != 15 && i != 18)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 條碼刷讀錯誤! ');", true);
//ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "隨便寫", "document.getElementById('" + this.txtBarCode.ClientID + "').focus();", true);
SetClinetFocus(txtBarCode.ClientID);
}
else
{
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
ParameterList.Clear();
ParameterList.Add(this.txtBarCode.Text);
ParameterList.Add(this.SLP_StoreChain1.Text);
ParameterList.Add(this.SLP_Store1.Text);
ParameterList.Add(DateTime.Parse(this.SLP_SLPDate1.Text));
ParameterList.Add(SLP_SKU1.Text);
ParameterList.Add(SLP_ItemPeriod1.Text);
string strItem; string strPeriod; decimal iPrice; DateTime DChanEndDate; string strMSG; string strRESULT;
BCO.GetItemByBarCode(ParameterList, out strItem, out strPeriod, out iPrice, out DChanEndDate, out strMSG, out strRESULT);
//if (strItem != string.Empty)
//{
//this.SLP_SKU1.Text = dt.Rows[0][0].ToString();
//this.SLP_ItemPeriod1.Text = dt.Rows[0][1].ToString();
//this.h_ChanPrice.Value = dt.Rows[0][2].ToString();
//this.h_ChanEndDate.Value = dt.Rows[0][3].ToString();
this.SLP_SKU1.Text = strItem;
this.SLP_ItemPeriod1.Text = strPeriod;
this.h_ChanPrice.Value = iPrice.ToString();
this.h_ChanEndDate.Value = DChanEndDate.ToString("yyyy/MM/dd");
this.SLP_AdjustQty.Text = "1";
pnlAdd.Visible = true;
//}
//else
//{
// ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 無此條碼! ');", true);
//}
if (strMSG != string.Empty)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' " + strMSG + " ');", true);
return;
}
SetClinetFocus(((TextBox)SLP_AdjustQty.FindControl("TextBoxCode")).ClientID);
//SLP_AdjustQty.Focus();
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
protected void txtBarCode_TextChanged(object sender, EventArgs e)
{
int i = this.txtBarCode.Text.Trim().Length;
if (this.SLP_StoreChain1.Text.Trim() == "")
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 請先選擇通路! ');", true);
}
else if (this.SLP_Store1.Text.Trim() == "")
{ ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 請先選擇門市! ');", true); }
else if (this.SLP_SLPDate1.Text.Trim().Replace("/", "") == "")
{ ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 請先選擇簽收日! ');", true); }
else if (i != 8 && i != 10 && i != 12 && i != 13 && i != 15 && i != 18)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' 條碼刷讀錯誤! ');", true);
}
else
{
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
ParameterList.Clear();
ParameterList.Add(this.txtBarCode.Text);
ParameterList.Add(this.SLP_StoreChain1.Text);
ParameterList.Add(this.SLP_Store1.Text);
ParameterList.Add(DateTime.Parse(this.SLP_SLPDate1.Text));
ParameterList.Add(SLP_SKU1.Text);
ParameterList.Add(SLP_ItemPeriod1.Text);
string strItem; string strPeriod; decimal iPrice; DateTime DChanEndDate; string strMSG; string strRESULT;
BCO.GetItemByBarCode(ParameterList, out strItem, out strPeriod, out iPrice, out DChanEndDate, out strMSG, out strRESULT);
this.SLP_SKU1.Text = strItem;
this.SLP_ItemPeriod1.Text = strPeriod;
this.h_ChanPrice.Value = iPrice.ToString();
this.h_ChanEndDate.Value = DChanEndDate.ToString("yyyy/MM/dd");
this.SLP_AdjustQty.Text = "1";
pnlAdd.Visible = true;
if (strMSG != string.Empty)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR022.aspx", "alert(' " + strMSG + " ');", true);
return;
}
}
}
public string GetTaxRate(int TaxType)
{
try
{
DBO.MaintainChanReturnData db = new MaintainChanReturnData(ref USEDB);
return db.GetTaxRate(TaxType);
}
catch (Exception ex)
{
throw ex;
}
}
