public string GetRootNoName(string Code)
{
string Name = "";
string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase;
MaintainItemClassify bco = new MaintainItemClassify(ConnectionDBStr);
if (Code != "")
{
ArrayList ParameterList = new ArrayList();
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "MA.ENABLE", 1, "=", "and");
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "MA.ITEM_LAYER", 0, "=", "and");
SQLHelper.SQLWhere_SubStr(ref ParameterList, DbType.String, "MA.PATTERN_NO", Code, "=", "and", 0, 1);
DataTable dt = bco.QueryItemClassifyByFind_1(ParameterList);
Name = ((dt.Rows.Count > 0) ? dt.Rows[0]["NAME"].ToString() : "查無資料");
}
return Name;
}
public string GetPMAName(string Code,
string RootNo
)
{
string Name = "";
string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase;
MaintainItemClassify bco = new MaintainItemClassify(ConnectionDBStr);
if (Code != "")
{
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(Code);
ParameterList.Add(RootNo);
DataTable dt = bco.QueryPMAForSLP2(ParameterList);
Name = ((dt.Rows.Count > 0) ? dt.Rows[0]["PMA_NAME"].ToString() : "查無資料");
}
return Name;
}
/// <summary>
/// 由新增模式，確認新增
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void InsertButton_Click(object sender, EventArgs e)
{
int res = 0;
int v_ID = 0;
DateTime UpTime = DateTime.Now;
DbTransaction DBT = null;
try
{
#region 檢查[供應商][群分類][大分類][中分類][小分類]
string s_ReturnMsg = string.Empty;
s_ReturnMsg = Check_Condition();
if (s_ReturnMsg != string.Empty)
{ Alert(s_ReturnMsg); return; }
#endregion
#region 畫面取值
//string v_ID = 新增前不給號
string v_ITEM = ((WUI.SLP.SLP_PreItem)FormView1.FindControl("txtITEM")).Text.Trim();
string v_ITEM_NAME = ((TextBox)FormView1.FindControl("txtITEM_NAME")).Text.Trim();
string v_VICE_ITEM_NAME = ((TextBox)FormView1.FindControl("txtVICE_ITEM_NAME")).Text.Trim();
string v_MDC_START_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtMDC_START_DATE")).Text.Trim();
string v_MDC_END_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtMDC_END_DATE")).Text.Trim();
string v_MANUFACTURE = ((WUI.SLP.SLP_VendorBase)FormView1.FindControl("txtMANUFACTURE")).Text.Trim();
string v_ROOT_NO = ((WUI.SLP.SLP_RootNo)FormView1.FindControl("ddlROOT_NO")).Text.Trim();
string v_OUT_OF_PRINT = ((((CheckBox)FormView1.FindControl("txtOUT_OF_PRINT")).Checked) ? "1" : "0");
string v_PMA = ((WUI.SLP.SLP_PMA)FormView1.FindControl("txtPMA")).Text.Trim();
string v_CATEGORY = ((WUI.SLP.SLP_Category)FormView1.FindControl("txtCATEGORY")).Text.Trim();
string v_SORT_OUT = ((WUI.SLP.SLP_SortOut)FormView1.FindControl("txtSORT_OUT")).Text.Trim();
string v_STATEMENTS = ((TextBox)FormView1.FindControl("txtSTATEMENTS")).Text.Trim();
string v_ATTRIBUTE = ((((CheckBox)FormView1.FindControl("txtATTRIBUTE")).Checked) ? "1" : "0");
string v_FIRST_PERIOD = ((TextBox)FormView1.FindControl("txtFIRST_PERIOD")).Text.Trim();
string v_NEW_SW = ((((CheckBox)FormView1.FindControl("chkNEW_SW")).Checked) ? "1" : "0");
string v_PERIOD_STEP = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtPERIOD_STEP")).Text.Trim();
string v_INTERVAL = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtINTERVAL")).Text.Trim();
string v_PUBLISH_TYPE = ((WUI.SLP.CodeFile)FormView1.FindControl("txtPUBLISH_TYPE")).Text.Trim();
string v_UNIT = ((WUI.SLP.EnumBase)FormView1.FindControl("txtUNIT")).Text.Trim();
string v_OPEN_SIZE = ((TextBox)FormView1.FindControl("txtOPEN_SIZE")).Text.Trim();
string v_PAGE_NUM = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtPAGE_NUM")).Text.Trim();
string v_WEIGHT = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtWEIGHT")).Text.Trim();
string v_HEIGHT = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtHEIGHT")).Text.Trim();
string v_LENGTH = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtDEEP")).Text.Trim();
string v_AUTHOR = ((TextBox)FormView1.FindControl("txtAUTHOR")).Text.Trim();
string v_CIP = ((TextBox)FormView1.FindControl("txtCIP")).Text.Trim();
string v_PUBLISH = ((TextBox)FormView1.FindControl("txtPUBLISH")).Text.Trim();
string v_ITEM_PUBLISHER_NO = ((TextBox)FormView1.FindControl("txtITEM_PUBLISHER_NO")).Text.Trim();
string v_ITEM_PUBLISHER_NAME = ((TextBox)FormView1.FindControl("txtITEM_PUBLISHER_NAME")).Text.Trim();
string v_PUBLISHER_TYPE = ((TextBox)FormView1.FindControl("txtPUBLISHER_TYPE")).Text.Trim();
string v_PUBLISH_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtPUBLISH_DATE")).Text.Trim();
//string v_PRE_ITEM_CHECK = ((CheckBox)FormView1.FindControl("chkPRE_ITEM_CHECK")).Text.Trim();
string v_PRE_ITEM_CHECK = "0"; // 未審核(新增時為未審核)
//FormView2
string v_DISTRIBUTE_MODE = ((RadioButtonList)FormView2.FindControl("txtDISTRIBUTE_MODE")).Text.Trim();
string v_QUANTITY = ((WUI.SLP.SLPNumber)FormView2.FindControl("txtQUANTITY")).Text.Trim();
string v_ACCEPT_TOTAL = ((WUI.SLP.SLPNumber)FormView2.FindControl("txtACCEPT_TOTAL")).Text.Trim();
string v_RESEMBLE_GOODS = ((TextBox)FormView2.FindControl("txtRESEMBLE_GOODS")).Text.Trim();
string v_GOODS_MATTER = ((TextBox)FormView2.FindControl("txtGOODS_MATTER")).Text.Trim();
string v_COMMEND_CAUSE = ((TextBox)FormView2.FindControl("txtCOMMEND_CAUSE")).Text.Trim();
string v_PATTERN_NO = string.Format("{0}{1}{2}{3}", v_ROOT_NO, v_PMA, v_CATEGORY, v_SORT_OUT);
string v_SUBSIDY_TYPE = ((RadioButtonList)FormView7.FindControl("rabSUBSIDY_TYPE")).Text.Trim();
string v_PRICE_DISCOUNT = ((WUI.SLP.SLPNumber)FormView7.FindControl("txtPRICE_DISCOUNT")).Text.Trim();
string v_MEMO = ((TextBox)FormView7.FindControl("txtMEMO")).Text.Trim();
string v_MainMEMO = ((TextBox)FormView1.FindControl("txtMEMO")).Text.Trim();
#endregion 畫面取值
System.Text.RegularExpressions.Regex reg1 = new System.Text.RegularExpressions.Regex(@"^[0-9]{6}$");
bool b_reg1 = reg1.IsMatch(((ASP.itm_slp_slp_preitem_ascx)this.FormView1.FindControl("txtITEM")).Text.Trim());
bool b_reg2 = reg1.IsMatch(((TextBox)this.FormView1.FindControl("txtFIRST_PERIOD")).Text.Trim());
if (b_reg1 == false)
{
Alert("品號為六位數字");
return;
}
if (b_reg2 == false)
{
Alert("首期期別為六位數字");
return;
}
if (Convert.ToDateTime(v_MDC_START_DATE).CompareTo(Convert.ToDateTime(v_MDC_END_DATE)) > 0)
{
Alert("DC開始日不可大於DC結束日");
return;
}
if (System.Text.Encoding.Default.GetBytes(v_MainMEMO).Length > 300)
{
Alert("新品主檔頁籤的備註欄位不允許超過300的字元");
return;
}
#region 因為有測試到欄位[首期期別][期別累加期]在儲存時，未檢查必填欄位，所以在後端再做一次檢查
if (v_FIRST_PERIOD == string.Empty)
{
Alert("新品主檔頁籤 請輸入首期期別");
return;
}
if (v_PERIOD_STEP == string.Empty)
{
Alert("新品主檔頁籤 請輸入期別累加期");
return;
}
#endregion
#region 檢查 首期期別是否小於折扣設定的期別迄
DataTable dtPriceS_OLD = (DataTable)Session["VDS_ITM_PRE_PRICEDISCOUNT_S_OLD_" + PageTimeStamp.Value];
DataTable dtPriceS_NEW = (DataTable)Session["VDS_ITM_PRE_PRICEDISCOUNT_S_NEW_" + PageTimeStamp.Value];
DataTable dtPriceSG_OLD = (DataTable)Session["VDS_ITM_PRE_PRICEDISCOUNT_SG_OLD_" + PageTimeStamp.Value];
DataTable dtPriceSG_NEW = (DataTable)Session["VDS_ITM_PRE_PRICEDISCOUNT_SG_NEW_" + PageTimeStamp.Value];
for (int i = 0; i < dtPriceS_NEW.Rows.Count; i++)
{
if (dtPriceS_NEW.Rows[i]["PERIOD_END"].ToString().Trim() != "")
if (string.Compare(v_FIRST_PERIOD, dtPriceS_NEW.Rows[i]["PERIOD_END"].ToString()) > 0)
{
Alert("折扣設定頁籤的[門市折扣]有[期別迄]欄位小於[首期期別]的資料");
return;
}
}
for (int i = 0; i < dtPriceSG_NEW.Rows.Count; i++)
{
if (dtPriceSG_NEW.Rows[i]["PERIOD_END"].ToString().Trim() != "")
if (string.Compare(v_FIRST_PERIOD, dtPriceSG_NEW.Rows[i]["PERIOD_END"].ToString()) > 0)
{
Alert("折扣設定頁籤的[店群折扣]有[期別迄]欄位小於[首期期別]的資料");
return;
}
}
#endregion
if (v_PRICE_DISCOUNT != "")
{
if (int.Parse(v_PRICE_DISCOUNT) > 100)
{
Alert("折扣設定頁籤的 大智通牌價計算不超過100");
return;
}
}
ParameterList.Clear();
ParameterList.Add(DBNull.Value); //N_ID
ParameterList.Add(v_ITEM); //V_ITEM
ParameterList.Add(DBNull.Value); //V_PATTERN_NO
DataTable dtExists = bco.QueryPreItemByFind_1(ParameterList);
if (dtExists.Rows.Count > 0) { Alert("品號已經存在"); return; }
#region 檢查供應商是否正確
TextBox txt_Code = ((ASP.vdm_slp_slp_vendorbase_ascx)this.FormView1.FindControl("txtMANUFACTURE")).TextBox_Code;
PIC.VDS2G.GFM.VDM.MaintainVendorBase BCO_VDM = new PIC.VDS2G.GFM.VDM.MaintainVendorBase(ConntionDB);
ParameterList.Clear();
PIC.VDS2G.GFM.VDM.SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.VENDOR", txt_Code.Text.Trim(), "=", "and");
DataTable dt_Code = BCO_VDM.QueryVendorBaseByFind_1(ParameterList);
if (dt_Code.Rows.Count != 1)
{
Alert("新品主檔頁籤 請輸入正確的供應商");
return;
}
#endregion
MaintainItemClassify bcoClass = new MaintainItemClassify(ConntionDB);
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PATTERN_NO", v_PATTERN_NO, "=", "and");
dtExists = bcoClass.QueryItemClassifyByFind_1(ParameterList);
if (dtExists.Rows.Count == 0) { Alert("PatternNo不存在"); return; }
DataTable dtMAIN_OLD = (DataTable)Session["VDS_ITM_PRE_PERIOD_MAIN_" + PageTimeStamp.Value];
DataTable dtMAIN_NEW = (DataTable)Session["VDS_ITM_PRE_PERIOD_MAIN_NEW_" + PageTimeStamp.Value];
//Call Insert Period_main
if (dtMAIN_NEW.Rows.Count == 0)
{
CHAN_InsertButton_Click(sender, e);
}
else
{
CHAN_EditCommitButton_Click(sender, e);
}
dtMAIN_NEW = (DataTable)Session["VDS_ITM_PRE_PERIOD_MAIN_NEW_" + PageTimeStamp.Value];
if (dtMAIN_NEW.Rows.Count == 0 && dtMAIN_OLD.Rows.Count == 0)
{
Alert("請輸入新品期別明細資料"); return;
}
if (dtMAIN_NEW.Rows[0]["BARCODE"].ToString() == "")
{
Alert("商品條碼不得為空白"); return;
}
#region 檢查門市及店群折扣資料是否在編輯狀態
if (gv_Price_S.EditIndex != -1) { Alert("請先更新或取消門市折扣資料"); return; }
if (gv_Price_SG.EditIndex != -1) { Alert("請先更新或取消店群折扣資料"); return; }
#endregion
#region 條碼檢查是否重覆
Button InsertButton = ((Button)FormViewButton.FindControl("InsertButton"));
HiddenField hdfSaveFlag = ((HiddenField)FormViewButton.FindControl("hdfSaveFlag"));
if (hdfSaveFlag.Value == "0")
{
if (CheckDup_BARCODE(dtMAIN_NEW.Rows[0]["BARCODE"].ToString(), v_ITEM) == true)
{
Page currentPage = (Page)HttpContext.Current.Handler;
string strScriptName = "ConfirmSave";
string strScriptContent = "DupBarcodeSave('" + InsertButton.ClientID + "','" + hdfSaveFlag.ClientID + "');";
ScriptManager.RegisterClientScriptBlock(currentPage, currentPage.GetType(), strScriptName, strScriptContent, true);
return;
}
}
#endregion
//初始化DBT
bco.StartDBT(out DBT);
if (SaveSubsidy(DBT, UpTime) == false)
return;
#region PREITEM
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCODE", v_ITEM); //vCODE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM", v_ITEM); //vITEM
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM_NAME", v_ITEM_NAME); //vITEM_NAME
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vMDC_START_DATE", v_MDC_START_DATE); //vMDC_START_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vMDC_END_DATE", v_MDC_END_DATE); //vMDC_END_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPMA", v_PMA); //vPMA
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCATEGORY", v_CATEGORY); //vCATEGORY
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vSORT_OUT", v_SORT_OUT); //vSORT_OUT
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPATTERN_NO", v_PATTERN_NO); //vPATTERN_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vATTRIBUTE", v_ATTRIBUTE); //vATTRIBUTE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vFIRST_PERIOD", v_FIRST_PERIOD); //vFIRST_PERIOD
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vPERIOD_STEP", v_PERIOD_STEP); //vPERIOD_STEP
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vINTERVAL", v_INTERVAL); //vINTERVAL
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPUBLISH_TYPE", v_PUBLISH_TYPE); //vPUBLISH_TYPE
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vUNIT", v_UNIT); //vUNIT
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vSTATEMENTS", v_STATEMENTS); //vSTATEMENTS
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vDISTRIBUTE_MODE", v_DISTRIBUTE_MODE); //vDISTRIBUTE_MODE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vRESEMBLE_GOODS", v_RESEMBLE_GOODS); //vRESEMBLE_GOODS
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vGOODS_MATTER", v_GOODS_MATTER); //vGOODS_MATTER
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCOMMEND_CAUSE", v_COMMEND_CAUSE); //vCOMMEND_CAUSE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vAUTHOR", v_AUTHOR); //vAUTHOR
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vNEW_SW", v_NEW_SW); //vNEW_SW
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vQUANTITY1", v_QUANTITY); //vQUANTITY1
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vACCEPT_TOTAL", v_ACCEPT_TOTAL); //vACCEPT_TOTAL
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPUBLISH", v_PUBLISH); //vPUBLISH
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vMANUFACTURE", v_MANUFACTURE); //vMANUFACTURE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vROOT_NO", v_ROOT_NO); //vROOT_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPUBLISHER_TYPE", v_PUBLISHER_TYPE); //vPUBLISHER_TYPE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vPUBLISH_DATE", v_PUBLISH_DATE); //vPUBLISH_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVICE_ITEM_NAME", v_VICE_ITEM_NAME); //vVICE_ITEM_NAME
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vOUT_OF_PRINT", v_OUT_OF_PRINT); //vOUT_OF_PRINT
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vOPEN_SIZE", v_OPEN_SIZE); //vOPEN_SIZE
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vPAGE_NUM", v_PAGE_NUM); //vPAGE_NUM
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCIP", v_CIP); //vCIP
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM_PUBLISHER_NO", v_ITEM_PUBLISHER_NO); //vITEM_PUBLISHER_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM_PUBLISHER_NAME", v_ITEM_PUBLISHER_NAME); //vITEM_PUBLISHER_NAME
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vLENGTH", v_LENGTH); //vLENGTH
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vWIDTH", v_WEIGHT); //vWIDTH
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vHIEGHT", v_HEIGHT); //vHIEGHT
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vCREATEDATE", UpTime); //vCREATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCREATEUID", Session["UID"].ToString()); //vCREATEUID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vUPDATEDATE", UpTime); //vUPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vUPDATEUID", Session["UID"].ToString()); //vUPDATEUID
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vMEMO", v_MainMEMO); //v_MainMEMO
v_ID = bco.CreatePreItem(ParameterList, DBT);
#endregion
#region PRE_MAIN
//ADD
if (dtMAIN_NEW.Rows.Count > 0 && dtMAIN_OLD.Rows.Count == 0)
{
DataRow drMAIN_NEW = dtMAIN_NEW.Rows[0];
ParameterList.Clear();
ParameterList.Clear();
ParameterList.Add(v_ITEM + v_FIRST_PERIOD); //0.vCODE
ParameterList.Add(v_ITEM); //1.vITEM
ParameterList.Add(v_FIRST_PERIOD); //2.vPERIOD
ParameterList.Add("0"); //3.vEDIT_NO
ParameterList.Add(drMAIN_NEW["TAX_TYPE"]); //4.vTAX_TYPE
ParameterList.Add(drMAIN_NEW["VENDOR"]); //5.vVENDOR
ParameterList.Add(drMAIN_NEW["COST"]); //6.vCOST
ParameterList.Add(drMAIN_NEW["PRICE"]); //7.vPRICE
ParameterList.Add(drMAIN_NEW["BARCODE"]); //8.vBARCODE
ParameterList.Add(drMAIN_NEW["PUBLISH_TYPE"]); //9.vPUBLISH_TYPE
ParameterList.Add(drMAIN_NEW["RETURN_DATE"]); //10.vRETURN_DATE
ParameterList.Add(drMAIN_NEW["COVER_FILE"]); //11.vCOVER_FILE
ParameterList.Add(drMAIN_NEW["PERIOD_BARCODE"]); //12.vPERIOD_BARCODE
ParameterList.Add(drMAIN_NEW["DIS_BASE"]); //13.vDIS_BASE
ParameterList.Add(drMAIN_NEW["DIS_ACCEPT_DOLLAR"]); //14.vDIS_ACCEPT_DOLLAR
ParameterList.Add(drMAIN_NEW["DIS_RETURN_DOLLAR"]); //15.vDIS_RETURN_DOLLAR
ParameterList.Add(drMAIN_NEW["DIS_RULE"]); //16.vDIS_RULE
ParameterList.Add(drMAIN_NEW["DIS_ACCEPT_RATE"]); //17.vDIS_ACCEPT_RATE
ParameterList.Add(drMAIN_NEW["DIS_RETURN_RATE"]); //18.vDIS_RETURN_RATE
ParameterList.Add(drMAIN_NEW["ACCT_VALIDATE"]); //19.vACCT_VALIDATE
ParameterList.Add(drMAIN_NEW["PERIOD_START_DATE"]); //20.vPERIOD_START_DATE
ParameterList.Add(drMAIN_NEW["PERIOD_END_DATE"]); //21.vPERIOD_END_DATE
ParameterList.Add(drMAIN_NEW["RESEARCH_FREQUENCY"]); //22.vRESEARCH_FREQUENCY
ParameterList.Add(drMAIN_NEW["RESEARCH_INTERVAL"]); //23.vRESEARCH_INTERVAL
ParameterList.Add(drMAIN_NEW["MARKET_RESEARCH"]); //24.vMARKET_RESEARCH
ParameterList.Add(drMAIN_NEW["PRINT_CNTY"]); //25.vPRINT_CNTY
ParameterList.Add(drMAIN_NEW["LANGUAGE"]); //26.vLANGUAGE
ParameterList.Add(drMAIN_NEW["RESEARCH_INTERVAL2"]); //27.vRESEARCH_INTERVAL2
ParameterList.Add(drMAIN_NEW["RESEARCH_INTERVAL3"]); //28.vRESEARCH_INTERVAL3
ParameterList.Add(drMAIN_NEW["EDIT_REASON"]); //29.vEDIT_REASON
ParameterList.Add(drMAIN_NEW["DISCOUNT_RATE"]); //30.vDISCOUNT_RATE
ParameterList.Add(UpTime); //31.vCREATEDATE
ParameterList.Add(Session["UID"].ToString()); //32.vCREATEUID
ParameterList.Add(UpTime); //33.vUPDATEDATE
ParameterList.Add(Session["UID"].ToString()); //34.vUPDATEUID
bcoMain.CreatePrePeriodMain(ParameterList, DBT);
}
//MODIFY
if (dtMAIN_NEW.Rows.Count > 0 && dtMAIN_OLD.Rows.Count > 0)
{
DataRow drMAIN_OLD = dtMAIN_OLD.Rows[0];
DataRow drMAIN_NEW = dtMAIN_NEW.Rows[0];
ParameterList.Clear();
ParameterList.Add(drMAIN_OLD["ID"]); //0.OLD_ID
ParameterList.Add(v_ITEM + v_FIRST_PERIOD); //1.NEW_CODE
ParameterList.Add(v_ITEM); //2.NEW_ITEM
ParameterList.Add(v_FIRST_PERIOD); //3.NEW_PERIOD
ParameterList.Add("0"); //4.NEW_EDIT_NO
ParameterList.Add(drMAIN_NEW["TAX_TYPE"]); //5.NEW_TAX_TYPE
ParameterList.Add(drMAIN_NEW["VENDOR"]); //6.NEW_VENDOR
ParameterList.Add(drMAIN_NEW["COST"]); //7.NEW_COST
ParameterList.Add(drMAIN_NEW["PRICE"]); //8.NEW_PRICE
ParameterList.Add(drMAIN_NEW["BARCODE"]); //9.NEW_BARCODE
ParameterList.Add(drMAIN_NEW["PUBLISH_TYPE"]); //10.NEW_PUBLISH_TYPE
ParameterList.Add(drMAIN_NEW["RETURN_DATE"]); //11.NEW_RETURN_DATE
ParameterList.Add(drMAIN_NEW["COVER_FILE"]); //12.NEW_COVER_FILE
ParameterList.Add(drMAIN_NEW["PERIOD_BARCODE"]); //13.NEW_PERIOD_BARCODE
ParameterList.Add(drMAIN_NEW["DIS_BASE"]); //14.NEW_DIS_BASE
ParameterList.Add(drMAIN_NEW["DIS_ACCEPT_DOLLAR"]); //15.NEW_DIS_ACCEPT_DOLLAR
ParameterList.Add(drMAIN_NEW["DIS_RETURN_DOLLAR"]); //16.NEW_DIS_RETURN_DOLLAR
ParameterList.Add(drMAIN_NEW["DIS_RULE"]); //17.NEW_DIS_RULE
ParameterList.Add(drMAIN_NEW["DIS_ACCEPT_RATE"]); //18.NEW_DIS_ACCEPT_RATE
ParameterList.Add(drMAIN_NEW["DIS_RETURN_RATE"]); //19.NEW_DIS_RETURN_RATE
ParameterList.Add(drMAIN_NEW["ACCT_VALIDATE"]); //20.NEW_ACCT_VALIDATE
ParameterList.Add(drMAIN_NEW["PERIOD_START_DATE"]); //21.NEW_PERIOD_START_DATE
ParameterList.Add(drMAIN_NEW["PERIOD_END_DATE"]); //22.NEW_PERIOD_END_DATE
ParameterList.Add(drMAIN_NEW["RESEARCH_FREQUENCY"]); //23.NEW_RESEARCH_FREQUENCY
ParameterList.Add(drMAIN_NEW["RESEARCH_INTERVAL"]); //24.NEW_RESEARCH_INTERVAL
ParameterList.Add(drMAIN_NEW["MARKET_RESEARCH"]); //25.NEW_MARKET_RESEARCH
ParameterList.Add(drMAIN_NEW["PRINT_CNTY"]); //26.NEW_PRINT_CNTY
ParameterList.Add(drMAIN_NEW["LANGUAGE"]); //27.NEW_LANGUAGE
ParameterList.Add(drMAIN_NEW["RESEARCH_INTERVAL2"]); //28.NEW_RESEARCH_INTERVAL2
ParameterList.Add(drMAIN_NEW["RESEARCH_INTERVAL3"]); //29.NEW_RESEARCH_INTERVAL3
ParameterList.Add(drMAIN_NEW["EDIT_REASON"]); //30.NEW_EDIT_REASON
ParameterList.Add(drMAIN_NEW["DISCOUNT_RATE"]); //31.NEW_DISCOUNT_RATE
ParameterList.Add(UpTime); //32.NEW_UPDATEDATE
ParameterList.Add(Session["UID"].ToString()); //33.NEW_UPDATEUID
bcoMain.UpdatePrePeriodMain(ParameterList, DBT);
}
#endregion
#region PRE_CHAN
DataTable dtCHAN_OLD = (DataTable)Session["VDS_ITM_PRE_PERIOD_CHAN_" + PageTimeStamp.Value];
DataTable dtCHAN_NEW = (DataTable)Session["VDS_ITM_PRE_PERIOD_CHAN_NEW_" + PageTimeStamp.Value];
//ADD
foreach (DataRow drCHAN_NEW in dtCHAN_NEW.Rows)
{
if (dtCHAN_OLD.Select(string.Format("ID={0}", ((drCHAN_NEW["ID"].ToString() == "") ? "0" : drCHAN_NEW["ID"].ToString()))).Length == 0)
{
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCODE", v_ITEM + v_FIRST_PERIOD); //vCODE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vEDIT_NO", "0"); //vEDIT_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM", v_ITEM); //vITEM
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPERIOD", v_FIRST_PERIOD); //vPERIOD
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCHAN_NO", drCHAN_NEW["CHAN_NO"].ToString()); //vCHAN_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM_MAP", drCHAN_NEW["ITEM_MAP"].ToString()); //vITEM_MAP
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vEFFECTIVE_DATE", drCHAN_NEW["EFFECTIVE_DATE"].ToString()); //vEFFECTIVE_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vCHAN_END_DATE", drCHAN_NEW["CHAN_END_DATE"].ToString()); //vCHAN_END_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vFREQUENCY_TYPE", drCHAN_NEW["FREQUENCY_TYPE"].ToString()); //vFREQUENCY_TYPE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vTRUN_OUT", drCHAN_NEW["TRUN_OUT"].ToString()); //vTRUN_OUT
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vSTATE", drCHAN_NEW["STATE"].ToString()); //vSTATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vPLAN_RETURN_DATE", drCHAN_NEW["PLAN_RETURN_DATE"].ToString()); //vPLAN_RETURN_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vNEXT_PLAN_RETURN_DATE", drCHAN_NEW["NEXT_PLAN_RETURN_DATE"].ToString()); //vNEXT_PLAN_RETURN_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vNOTICE_RETURN_DATE", drCHAN_NEW["NOTICE_RETURN_DATE"].ToString()); //vNOTICE_RETURN_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vBACKWARD_DATE", drCHAN_NEW["BACKWARD_DATE"].ToString()); //vBACKWARD_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vCHAN_ISS_DATE", drCHAN_NEW["CHAN_ISS_DATE"].ToString()); //vCHAN_ISS_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCHAN_DIS_NO", drCHAN_NEW["CHAN_DIS_NO"].ToString()); //vCHAN_DIS_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vRETURN_TYPE", drCHAN_NEW["RETURN_TYPE"].ToString()); //vRETURN_TYPE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vRTN_DDL", drCHAN_NEW["RTN_DDL"].ToString()); //vRTN_DDL
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vDISPLAY_DAY", drCHAN_NEW["DISPLAY_DAY"].ToString()); //vDISPLAY_DAY
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vCREATEDATE", UpTime); //vCREATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCREATEUID", Session["UID"].ToString()); //vCREATEUID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vUPDATEDATE", UpTime); //vUPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vUPDATEUID", Session["UID"].ToString()); //vUPDATEUID
bcoChan.CreatePrePeriodChan(ParameterList, DBT);
}
}
//MODIFY
foreach (DataRow drCHAN_NEW in dtCHAN_NEW.Rows)
{
DataRow[] drsOLD = dtCHAN_OLD.Select(string.Format("ID={0}", ((drCHAN_NEW["ID"].ToString() == "") ? "0" : drCHAN_NEW["ID"].ToString())));
if (drsOLD.Length > 0)
{
DataRow drOLD = drsOLD[0];
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", drOLD["ID"].ToString()); //OLD_ID
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CODE", drOLD["CODE"].ToString()); //OLD_CODE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_EDIT_NO", drOLD["EDIT_NO"].ToString()); //OLD_EDIT_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_ITEM", drOLD["ITEM"].ToString()); //OLD_ITEM
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_PERIOD", drOLD["PERIOD"].ToString()); //OLD_PERIOD
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CHAN_NO", drOLD["CHAN_NO"].ToString()); //OLD_CHAN_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_ITEM_MAP", drOLD["ITEM_MAP"].ToString()); //OLD_ITEM_MAP
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_EFFECTIVE_DATE", drOLD["EFFECTIVE_DATE"].ToString()); //OLD_EFFECTIVE_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_CHAN_END_DATE", drOLD["CHAN_END_DATE"].ToString()); //OLD_CHAN_END_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_FREQUENCY_TYPE", drOLD["FREQUENCY_TYPE"].ToString()); //OLD_FREQUENCY_TYPE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_TRUN_OUT", drOLD["TRUN_OUT"].ToString()); //OLD_TRUN_OUT
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_STATE", drOLD["STATE"].ToString()); //OLD_STATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_PLAN_RETURN_DATE", drOLD["PLAN_RETURN_DATE"].ToString()); //OLD_PLAN_RETURN_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_NEXT_PLAN_RETURN_DATE", drOLD["NEXT_PLAN_RETURN_DATE"].ToString()); //OLD_NEXT_PLAN_RETURN_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_NOTICE_RETURN_DATE", drOLD["NOTICE_RETURN_DATE"].ToString()); //OLD_NOTICE_RETURN_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_BACKWARD_DATE", drOLD["BACKWARD_DATE"].ToString()); //OLD_BACKWARD_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_CHAN_ISS_DATE", drOLD["CHAN_ISS_DATE"].ToString()); //OLD_CHAN_ISS_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CHAN_DIS_NO", drOLD["CHAN_DIS_NO"].ToString()); //OLD_CHAN_DIS_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_RETURN_TYPE", drOLD["RETURN_TYPE"].ToString()); //OLD_RETURN_TYPE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_RTN_DDL", drOLD["RTN_DDL"].ToString()); //OLD_RTN_DDL
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_DISPLAY_DAY", drOLD["DISPLAY_DAY"].ToString()); //OLD_DISPLAY_DAY
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_CREATEDATE", drOLD["CREATEDATE"].ToString()); //OLD_CREATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CREATEUID", drOLD["CREATEUID"].ToString()); //OLD_CREATEUID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_UPDATEDATE", drOLD["UPDATEDATE"].ToString()); //OLD_UPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_UPDATEUID", drOLD["UPDATEUID"].ToString()); //OLD_UPDATEUID
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ENABLE", drOLD["ENABLE"].ToString()); //OLD_ENABLE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_CODE", v_ITEM + v_FIRST_PERIOD); //NEW_CODE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_EDIT_NO", "0"); //NEW_EDIT_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_ITEM", v_ITEM); //NEW_ITEM
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PERIOD", v_FIRST_PERIOD); //NEW_PERIOD
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_CHAN_NO", drCHAN_NEW["CHAN_NO"].ToString()); //NEW_CHAN_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_ITEM_MAP", drCHAN_NEW["ITEM_MAP"].ToString()); //NEW_ITEM_MAP
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_EFFECTIVE_DATE", drCHAN_NEW["EFFECTIVE_DATE"].ToString()); //NEW_EFFECTIVE_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_CHAN_END_DATE", drCHAN_NEW["CHAN_END_DATE"].ToString()); //NEW_CHAN_END_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_FREQUENCY_TYPE", drCHAN_NEW["FREQUENCY_TYPE"].ToString()); //NEW_FREQUENCY_TYPE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_TRUN_OUT", drCHAN_NEW["TRUN_OUT"].ToString()); //NEW_TRUN_OUT
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_STATE", drCHAN_NEW["STATE"].ToString()); //NEW_STATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_PLAN_RETURN_DATE", drCHAN_NEW["PLAN_RETURN_DATE"].ToString()); //NEW_PLAN_RETURN_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_NEXT_PLAN_RETURN_DATE", drCHAN_NEW["NEXT_PLAN_RETURN_DATE"].ToString()); //NEW_NEXT_PLAN_RETURN_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_NOTICE_RETURN_DATE", drCHAN_NEW["NOTICE_RETURN_DATE"].ToString()); //NEW_NOTICE_RETURN_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_BACKWARD_DATE", drCHAN_NEW["BACKWARD_DATE"].ToString()); //NEW_BACKWARD_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_CHAN_ISS_DATE", drCHAN_NEW["CHAN_ISS_DATE"].ToString()); //NEW_CHAN_ISS_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_CHAN_DIS_NO", drCHAN_NEW["CHAN_DIS_NO"].ToString()); //NEW_CHAN_DIS_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_RETURN_TYPE", drCHAN_NEW["RETURN_TYPE"].ToString()); //NEW_RETURN_TYPE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_RTN_DDL", drCHAN_NEW["RTN_DDL"].ToString()); //NEW_RTN_DDL
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_DISPLAY_DAY", drCHAN_NEW["DISPLAY_DAY"].ToString()); //NEW_DISPLAY_DAY
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", UpTime); //NEW_UPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", Session["UID"].ToString()); //NEW_UPDATEUID
bcoChan.UpdatePrePeriodChan(ParameterList, DBT);
}
}
//DELETE
foreach (DataRow drOLD in dtCHAN_OLD.Rows)
{
if (dtCHAN_NEW.Select(string.Format("ID={0}", ((drOLD["ID"].ToString() == "") ? "0" : drOLD["ID"].ToString()))).Length == 0)
{
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", drOLD["ID"].ToString()); //OLD_ID
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CODE", drOLD["CODE"].ToString()); //OLD_CODE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_EDIT_NO", drOLD["EDIT_NO"].ToString()); //OLD_EDIT_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_ITEM", drOLD["ITEM"].ToString()); //OLD_ITEM
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_PERIOD", drOLD["PERIOD"].ToString()); //OLD_PERIOD
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CHAN_NO", drOLD["CHAN_NO"].ToString()); //OLD_CHAN_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_ITEM_MAP", drOLD["ITEM_MAP"].ToString()); //OLD_ITEM_MAP
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_EFFECTIVE_DATE", drOLD["EFFECTIVE_DATE"].ToString()); //OLD_EFFECTIVE_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_CHAN_END_DATE", drOLD["CHAN_END_DATE"].ToString()); //OLD_CHAN_END_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_FREQUENCY_TYPE", drOLD["FREQUENCY_TYPE"].ToString()); //OLD_FREQUENCY_TYPE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_TRUN_OUT", drOLD["TRUN_OUT"].ToString()); //OLD_TRUN_OUT
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_STATE", drOLD["STATE"].ToString()); //OLD_STATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_PLAN_RETURN_DATE", drOLD["PLAN_RETURN_DATE"].ToString()); //OLD_PLAN_RETURN_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_NEXT_PLAN_RETURN_DATE", drOLD["NEXT_PLAN_RETURN_DATE"].ToString()); //OLD_NEXT_PLAN_RETURN_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_NOTICE_RETURN_DATE", drOLD["NOTICE_RETURN_DATE"].ToString()); //OLD_NOTICE_RETURN_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_BACKWARD_DATE", drOLD["BACKWARD_DATE"].ToString()); //OLD_BACKWARD_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_CHAN_ISS_DATE", drOLD["CHAN_ISS_DATE"].ToString()); //OLD_CHAN_ISS_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CHAN_DIS_NO", drOLD["CHAN_DIS_NO"].ToString()); //OLD_CHAN_DIS_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_RETURN_TYPE", drOLD["RETURN_TYPE"].ToString()); //OLD_RETURN_TYPE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_RTN_DDL", drOLD["RTN_DDL"].ToString()); //OLD_RTN_DDL
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_DISPLAY_DAY", drOLD["DISPLAY_DAY"].ToString()); //OLD_DISPLAY_DAY
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_CREATEDATE", drOLD["CREATEDATE"].ToString()); //OLD_CREATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CREATEUID", drOLD["CREATEUID"].ToString()); //OLD_CREATEUID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_UPDATEDATE", drOLD["UPDATEDATE"].ToString()); //OLD_UPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_UPDATEUID", drOLD["UPDATEUID"].ToString()); //OLD_UPDATEUID
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ENABLE", drOLD["ENABLE"].ToString()); //OLD_ENABLE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", UpTime); //NEW_UPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", Session["UID"].ToString()); //NEW_UPDATEUID
bcoChan.DeletePrePeriodChan(ParameterList, DBT);
}
}
#endregion
#region PRE_PRICE_STORE
//ADD
foreach (DataRow drPriceS_NEW in dtPriceS_NEW.Rows)
{
if (dtPriceS_OLD.Select(string.Format("ID={0}", ((drPriceS_NEW["ID"].ToString() == "") ? "0" : drPriceS_NEW["ID"].ToString()))).Length == 0)
{
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCODE", v_ITEM + drPriceS_NEW["STORE"].ToString() + v_FIRST_PERIOD + DateTime.Parse(drPriceS_NEW["EFF_START"].ToString()).ToString("yyyyMMdd"));
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vSTORE", drPriceS_NEW["STORE"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM", v_ITEM);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPERIOD", v_FIRST_PERIOD);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPERIOD_END", drPriceS_NEW["PERIOD_END"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vPRICE_DISCOUNT", drPriceS_NEW["PRICE_DISCOUNT"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vVENDOR_SUBSIDY_PERCENT", drPriceS_NEW["VENDOR_SUBSIDY_PERCENT"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vFIX_PRICE_DISCOUNT", drPriceS_NEW["FIX_PRICE_DISCOUNT"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vCOST_PERCENT", dtMAIN_NEW.Rows[0]["DISCOUNT_RATE"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vEFF_START", drPriceS_NEW["EFF_START"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vEFF_END", drPriceS_NEW["EFF_END"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vMEMO", drPriceS_NEW["MEMO"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vCREATEDATE", UpTime); //vCREATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCREATEUID", Session["UID"].ToString()); //vCREATEUID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vUPDATEDATE", UpTime); //vUPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vUPDATEUID", Session["UID"].ToString()); //vUPDATEUID
bcoPrice.CreatePrePrice_S(ParameterList, DBT);
}
}
//MODIFY
foreach (DataRow drPriceS_NEW in dtPriceS_NEW.Rows)
{
DataRow[] drsOLD = dtPriceS_OLD.Select(string.Format("ID={0}", ((drPriceS_NEW["ID"].ToString() == "") ? "0" : drPriceS_NEW["ID"].ToString())));
if (drsOLD.Length > 0)
{
DataRow drOLD = drsOLD[0];
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vID", drPriceS_NEW["ID"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCODE", v_ITEM + drPriceS_NEW["STORE"].ToString() + v_FIRST_PERIOD + DateTime.Parse(drPriceS_NEW["EFF_START"].ToString()).ToString("yyyyMMdd"));
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vSTORE", drPriceS_NEW["STORE"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM", v_ITEM);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPERIOD", v_FIRST_PERIOD);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPERIOD_END", drPriceS_NEW["PERIOD_END"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vPRICE_DISCOUNT", drPriceS_NEW["PRICE_DISCOUNT"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vVENDOR_SUBSIDY_PERCENT", drPriceS_NEW["VENDOR_SUBSIDY_PERCENT"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vFIX_PRICE_DISCOUNT", drPriceS_NEW["FIX_PRICE_DISCOUNT"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vCOST_PERCENT", dtMAIN_NEW.Rows[0]["DISCOUNT_RATE"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vEFF_START", drPriceS_NEW["EFF_START"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vEFF_END", drPriceS_NEW["EFF_END"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vMEMO", drPriceS_NEW["MEMO"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vUPDATEDATE", UpTime); //vUPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vUPDATEUID", Session["UID"].ToString()); //vUPDATEUID
bcoPrice.UpdatePrePrice_S(ParameterList, DBT);
}
}
//DELETE
foreach (DataRow drOLD in dtPriceS_OLD.Rows)
{
if (dtPriceS_NEW.Select(string.Format("ID={0}", ((drOLD["ID"].ToString() == "") ? "0" : drOLD["ID"].ToString()))).Length == 0)
{
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", drOLD["ID"].ToString()); //OLD_ID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", UpTime); //NEW_UPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", Session["UID"].ToString()); //NEW_UPDATEUID
bcoPrice.DeletePrePrice_S(ParameterList, DBT);
}
}
#endregion
#region PRE_PRICE_STOREGROUP
//ADD
foreach (DataRow drPriceSG_NEW in dtPriceSG_NEW.Rows)
{
if (dtPriceSG_OLD.Select(string.Format("ID={0}", ((drPriceSG_NEW["ID"].ToString() == "") ? "0" : drPriceSG_NEW["ID"].ToString()))).Length == 0)
{
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCODE", v_ITEM + drPriceSG_NEW["GROUP_NO"].ToString() + v_FIRST_PERIOD + DateTime.Parse(drPriceSG_NEW["EFF_START"].ToString()).ToString("yyyyMMdd"));
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vGROUP_NO", drPriceSG_NEW["GROUP_NO"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM", v_ITEM);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPERIOD", v_FIRST_PERIOD);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPERIOD_END", drPriceSG_NEW["PERIOD_END"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vPRICE_DISCOUNT", drPriceSG_NEW["PRICE_DISCOUNT"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vFIX_PRICE_DISCOUNT", drPriceSG_NEW["FIX_PRICE_DISCOUNT"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vEFF_START", drPriceSG_NEW["EFF_START"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vEFF_END", drPriceSG_NEW["EFF_END"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vMEMO", drPriceSG_NEW["MEMO"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vCREATEDATE", UpTime); //vCREATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCREATEUID", Session["UID"].ToString()); //vCREATEUID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vUPDATEDATE", UpTime); //vUPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vUPDATEUID", Session["UID"].ToString()); //vUPDATEUID
bcoPrice.CreatePrePrice_SG(ParameterList, DBT);
}
}
//MODIFY
foreach (DataRow drPriceSG_NEW in dtPriceSG_NEW.Rows)
{
DataRow[] drsOLD = dtPriceSG_OLD.Select(string.Format("ID={0}", ((drPriceSG_NEW["ID"].ToString() == "") ? "0" : drPriceSG_NEW["ID"].ToString())));
if (drsOLD.Length > 0)
{
DataRow drOLD = drsOLD[0];
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vID", v_ITEM + drPriceSG_NEW["GROUP_NO"].ToString() + v_FIRST_PERIOD + DateTime.Parse(drPriceSG_NEW["EFF_START"].ToString()).ToString("yyyyMMdd"));
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCODE", drPriceSG_NEW["CODE"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vGROUP_NO", drPriceSG_NEW["GROUP_NO"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM", v_ITEM);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPERIOD", v_FIRST_PERIOD);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPERIOD_END", drPriceSG_NEW["PERIOD_END"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vPRICE_DISCOUNT", drPriceSG_NEW["PRICE_DISCOUNT"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vFIX_PRICE_DISCOUNT", drPriceSG_NEW["FIX_PRICE_DISCOUNT"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vEFF_START", drPriceSG_NEW["EFF_START"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vEFF_END", drPriceSG_NEW["EFF_END"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vMEMO", drPriceSG_NEW["MEMO"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vUPDATEDATE", UpTime); //vUPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vUPDATEUID", Session["UID"].ToString()); //vUPDATEUID
bcoPrice.UpdatePrePrice_SG(ParameterList, DBT);
}
}
//DELETE
foreach (DataRow drOLD in dtPriceSG_OLD.Rows)
{
if (dtPriceSG_NEW.Select(string.Format("ID={0}", ((drOLD["ID"].ToString() == "") ? "0" : drOLD["ID"].ToString()))).Length == 0)
{
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", drOLD["ID"].ToString()); //OLD_ID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", UpTime); //NEW_UPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", Session["UID"].ToString()); //NEW_UPDATEUID
bcoPrice.DeletePrePrice_SG(ParameterList, DBT);
}
}
#endregion
#region PRE_PRICE_MEMO
ParameterList.Clear();
DataTable dtMemo_old = (DataTable)Session["VDS_ITM_PRE_MEMO_" + PageTimeStamp.Value];
//ADD
if (dtMemo_old.Rows.Count == 0)
{
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM", v_ITEM); //vITEM
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vPRICE_DISCOUNT", v_PRICE_DISCOUNT); //vMDC_START_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vSUBSIDY_TYPE", v_SUBSIDY_TYPE); //vMDC_END_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vMEMO", v_MEMO); //vPMA
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vCREATEDATE", UpTime); //vCREATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCREATEUID", Session["UID"].ToString()); //vCREATEUID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vUPDATEDATE", UpTime); //vUPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vUPDATEUID", Session["UID"].ToString()); //vUPDATEUID
bcoPrice.CreatePrePrice_Memo(ParameterList, DBT);
}
//MODIFY
if (dtMemo_old.Rows.Count > 0)
{
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM", v_ITEM); //vITEM
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vPRICE_DISCOUNT", v_PRICE_DISCOUNT); //vMDC_START_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vSUBSIDY_TYPE", v_SUBSIDY_TYPE); //vMDC_END_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vMEMO", v_MEMO); //vPMA
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vUPDATEDATE", UpTime); //vUPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vUPDATEUID", Session["UID"].ToString()); //vUPDATEUID
bcoPrice.UpdatePrePrice_Memo(ParameterList, DBT);
}
#endregion
//完成交易
bco.CommitDBT(DBT);
ArrayList arr = new ArrayList();
if ((ArrayList)Session[Request.QueryString["arl_Key"]] != null)
arr = (ArrayList)Session[Request.QueryString["arl_Key"]];
arr.Add(v_ID.ToString());
string arl_Key = "";
if ((ArrayList)Session[Request.QueryString["arl_Key"]] != null)
{
arl_Key = Request.QueryString["arl_Key"];
Session[Request.QueryString["arl_Key"]] = arr;
}
else //從查詢頁直接按新增過來時沒有arl_Key參數，所以在這裏重做一個arl_Key參數
{
arl_Key = "arl_Key" + PageTimeStamp.Value;
Session[arl_Key] = arr;
}
Script("alert('新增完成');location.href='ITM182.aspx?Code=ITM18&isToolBar=N&SessionName=" + Request.QueryString["SessionName"] + "&arl_Key=" + arl_Key + "&ID=" + v_ID.ToString() + "'");
}
catch (Exception ex)
{
if (DBT != null)
DBT.Rollback();
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM_NO", ((WUI.SLP.SLP_PreItem)FormView1.FindControl("txtITEM")).Text.Trim());
bco.DeletePreItem_1(ParameterList, null);
lblInsertError.Text = ex.Message;
}
finally { }
}//end InsertButton_Click
private void GetItemNameByItem(string strItem)
{
#region
try
{
s_ITEM_NAME = "";
s_ROOT_NO = "";
s_PMA = "";
s_PATTERN = "";
s_PMA_NAME = "";
ITMModel.MaintainSKU BCO = new ITMModel.MaintainSKU(ConnectionDB);
ITMModel.MaintainItemClassify BCO2 = new ITMModel.MaintainItemClassify(ConnectionDB);
ArrayList ParameterList1 = new ArrayList();
ParameterList1.Clear();
ParameterList1.Add(strItem);
DataTable dtTemp = BCO.QuerySKUByCode(ParameterList1);
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
DateTime d_MdcStartDate, d_MdcEndDate, d_StAcceptDate;
d_MdcEndDate = DateTime.Parse("9999/12/31");
d_MdcStartDate = (DateTime)dtTemp.Rows[0]["MDC_START_DATE"];
d_StAcceptDate = DateTime.Parse(SLP_SLPDate2_StAcceptDate.Text);
if (dtTemp.Rows[0]["MDC_END_DATE"].ToString() != "")
{
d_MdcEndDate = (DateTime)dtTemp.Rows[0]["MDC_END_DATE"];
}
// 2009-10-10 加上商品主檔 MDC日期有效日期判斷
if (d_StAcceptDate >= d_MdcStartDate &&
d_StAcceptDate <= d_MdcEndDate)
{
s_ITEM_NAME = dtTemp.Rows[0]["ITEM_NAME"].ToString();
s_ROOT_NO = dtTemp.Rows[0]["ROOT_NO"].ToString();
s_PMA = dtTemp.Rows[0]["PMA"].ToString();
s_PATTERN = dtTemp.Rows[0]["PATTERN_NO"].ToString();
ParameterList1.Clear();
ParameterList1.Add(s_PMA);
ParameterList1.Add(s_ROOT_NO);
DataTable dt2 = BCO2.QueryPMAForSLP(ParameterList1);
if (dt2 != null && dt2.Rows.Count > 0)
{
s_PMA_NAME = dt2.Rows[0]["PMA_NAME"].ToString().Trim();
}
}
}
//else
//{
// s_ITEM_NAME = "";
// s_ROOT_NO = "";
// s_PMA = "";
// s_PATTERN = "";
// s_PMA_NAME = "";
//}
}
catch (Exception ex)
{
throw ex;
}
#endregion
}
public static string CheckUnique(string v_CODE)
{
string[] strValue = v_CODE.Split('|');
string Result = "";
MaintainItemClassify bcoCheck = new MaintainItemClassify(ConntionDB);
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PATTERN_NO", strValue[0], "=", "and");
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PATTERN_NO", strValue[1], "<>", "and");
DataTable dtExists = bcoCheck.QueryItemClassifyByFind_1(ParameterList);
if (dtExists.Rows.Count > 0)
{
return "Pattern代碼已經存在";
}
return Result;
}
protected void btn_Confirm_Click(object sender, EventArgs e)
{
#region
try
{
if (GetStringLen(txt_Memo.Text.Trim()) > 200)
{
hiddenFocusCtrlID.Value = txt_Memo.ClientID;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ClientScript", "alert('備註限制100中文字');", true);
}
else
{
#region
DateTime dtProcessing = DateTime.Now;
string strUID = Session["UID"].ToString();
string strChan = SLP_StoreChain3.Text.Trim();
string strStore = SLP_Store3.Text.Trim();
string strPattern = SLP_Pattern3.Text.Trim();
string strChanName = "";
string strStoreName = "";
string strPatternName = "";
ArrayList ParameterList = new ArrayList();//20091112
int iRowIndex = 0;
ALOModel.MaintainStoreRank BCO = new ALOModel.MaintainStoreRank(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(strChan);
ParameterList.Add(strStore);
ParameterList.Add(strPattern);
ParameterList.Add(dtProcessing);
ParameterList.Add(strUID);
ParameterList.Add(dtProcessing);
ParameterList.Add(strUID);
ParameterList.Add(null);
ParameterList.Add(strRankCode2);
ParameterList.Add(SLP_SLPNumber1.Text.Trim());
ParameterList.Add(txt_RankLevel.Text.Trim());
ParameterList.Add(txt_Memo.Text.Trim());
ParameterList.Add(s_PROCNO);
BCO.ADD_STORERANK_AFTERQUERY(ParameterList, null);
//todo gridview binding
#region
//chan_name
ParameterList.Clear();
ParameterList.Add(strChan);
STMModel.MaintainStoreChain BCO_STM1 = new STMModel.MaintainStoreChain(ConnectionDB);
DataTable dt_stm1 = BCO_STM1.QueryStoreChainByCode(ParameterList);
strChanName = ((dt_stm1 != null && dt_stm1.Rows.Count > 0) ? dt_stm1.Rows[0]["NAME"].ToString() : "查無資料");
//store_name
ParameterList.Clear();
ParameterList.Add(strStore);
ParameterList.Add(strChan);
ParameterList.Add(null);
STMModel.MaintainStoreUnique BCO_STM2 = new STMModel.MaintainStoreUnique(ConnectionDB);
DataTable dt_stm2 = BCO_STM2.QueryForSLP2(ParameterList);
strStoreName = ((dt_stm2 != null && dt_stm2.Rows.Count > 0) ? dt_stm2.Rows[0]["STORE_NAME"].ToString() : "查無資料");
//pattern_name
ParameterList.Clear();
ParameterList.Add(strPattern);
ParameterList.Add(null);
ParameterList.Add(null);
ParameterList.Add(null);
ParameterList.Add(null);
ITMModel.MaintainItemClassify BCO_ITM1 = new ITMModel.MaintainItemClassify(ConnectionDB);
DataTable dt_itm1 = BCO_ITM1.QueryPatternForSLP(ParameterList);
strPatternName = ((dt_itm1 != null && dt_itm1.Rows.Count > 0) ? dt_itm1.Rows[0]["PATTERN_NAME"].ToString() : "查無資料");
#endregion
#region Insert New Row
string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
DataTable dt1 = (DataTable)Session[SessionIDName];
DataView dv = dt1.DefaultView;
if (ViewState["SortingCondition"] != null)
{
dv.Sort = ViewState["SortingCondition"].ToString();
}
DataTable dt2 = dv.ToTable();
//判斷是否已存在目前DataTable中
if (CheckDataIsExistedInCurrentDataTable(strChan, strStore, strPattern, dt2, out iRowIndex))
{
#region 如存在則刪除畫面上舊資料
dt2.Rows.RemoveAt(iRowIndex);
#endregion
}
#region 新增一筆
DataRow dr = dt2.NewRow();
dr["PATTERN_NO"] = strPattern;
dr["PATTERN_NAME"] = strPatternName;
dr["CHAN_NO"] = strChan;
dr["CHAN_NAME"] = strChanName;
dr["STORE"] = strStore;
dr["STORE_NAME"] = strStoreName;
dr["RANK_CODE"] = ((DropDownList)SLP_Rank2.FindControl("D1")).SelectedItem.Value;
dr["RANK_NAME"] = ((DropDownList)SLP_Rank2.FindControl("D1")).SelectedItem.Text;
dr["RANK_VALUE"] = SLP_SLPNumber1.Text.Trim();
dr["RANK_LEVEL"] = txt_RankLevel.Text.Trim();
dr["MEMO"] = txt_Memo.Text.Trim();
//2010/09/20 added
//dr["c_start_date"] = SLP_SLPDate1.Text.Trim();//暫不顯示
//dr["c_end_date"] = SLP_SLPDate2.Text.Trim();//暫不顯示
dr["update_date"] = DateTime.Now.ToString("yyyy/MM/dd");
dr["user_name"] = ((DataTable)Session["UserInfo"]).Rows[0]["Name"].ToString();
dt2.Rows.InsertAt(dr, 0);
#endregion
Session[SessionIDName] = dt2;
GridView1.DataSource = dt2;
GridView1.DataBind();
#endregion
PanelG3.Visible = false;
hiddenFocusCtrlID.Value = "";
ResultMsgLabel.Text = "新增成功";
#endregion
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
}//end CancelButton_Click
/// <summary>
/// 編輯模式，按下更新確認鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EditCommitButton_Click(object sender, EventArgs e)
{
#region 檢查[供應商][群分類][大分類][中分類][小分類]
string s_ReturnMsg = string.Empty;
s_ReturnMsg = Check_Condition();
if (s_ReturnMsg != string.Empty)
{ Alert(s_ReturnMsg); return; }
#endregion
string v_EDIT_NO = "";
if (ViewState["EDIT_NO"].ToString().Trim() == "")
{
//ViewState["EDIT_NO"] = string.Format("{0}001", DateTime.Today.ToString("yyyyMMdd"));
//v_EDIT_NO = string.Format("{0}001", DateTime.Today.ToString("yyyyMMdd"));
ViewState["EDIT_NO"] = "0";
v_EDIT_NO = "0";
}
else
{
v_EDIT_NO = ViewState["EDIT_NO"].ToString();
}
int res = 0;
try
{
#region 取得畫面元件的值
//FormView1
string v_ID = ((TextBox)FormView1.FindControl("TextBoxID")).Text.Trim();
string v_ITEM = ((TextBox)FormView1.FindControl("txtITEM")).Text.Trim();
string v_ITEM_NAME = ((TextBox)FormView1.FindControl("txtITEM_NAME")).Text.Trim();
string v_VICE_ITEM_NAME = ((TextBox)FormView1.FindControl("txtVICE_ITEM_NAME")).Text.Trim();
string v_MDC_START_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtMDC_START_DATE")).Text.Trim();
string v_MDC_END_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtMDC_END_DATE")).Text.Trim();
string v_MANUFACTURE = ((WUI.SLP.SLP_VendorBase)FormView1.FindControl("txtMANUFACTURE")).Text.Trim();
//值要重給,不然可能無法抓到正確的名稱
((WUI.SLP.SLP_VendorBase)FormView1.FindControl("txtMANUFACTURE")).Text = v_MANUFACTURE;
string v_MANUFACTURE_TEXT = ((WUI.SLP.SLP_VendorBase)FormView1.FindControl("txtMANUFACTURE")).TextBox_Name.Text.Trim();
if (v_MANUFACTURE_TEXT == "查無資料")
{
Alert("請輸入正確的供應商資料");
return;
}
//v_EDIT_NO = ((TextBox)FormView1.FindControl("txtEDIT_NO")).Text.Trim();
string v_EDIT_REASON = ((TextBox)FormView1.FindControl("txtEDIT_REASON")).Text.Trim();
string v_ROOT_NO = ((WUI.SLP.SLP_RootNo)FormView1.FindControl("ddlROOT_NO")).Text.Trim();
CheckBox cbOUT_OF_PRINT = (CheckBox)((WUI.SLP.SLP_Boolean)FormView1.FindControl("txtOUT_OF_PRINT")).FindControl("C1");
string v_OUT_OF_PRINT = ((cbOUT_OF_PRINT.Checked) ? "1" : "0");
//string v_PMA = ((WUI.SLP.CodeFile)FormView1.FindControl("txtPMA")).Text.Trim();
string v_PMA = ((WUI.SLP.SLP_PMA)FormView1.FindControl("txtPMA")).Text.Trim();
//string v_CATEGORY = ((WUI.SLP.CodeFile)FormView1.FindControl("txtCATEGORY")).Text.Trim();
string v_CATEGORY = ((WUI.SLP.SLP_Category)FormView1.FindControl("txtCATEGORY")).Text.Trim();
//string v_SORT_OUT = ((WUI.SLP.CodeFile)FormView1.FindControl("txtSORT_OUT")).Text.Trim();
string v_SORT_OUT = ((WUI.SLP.SLP_SortOut)FormView1.FindControl("txtSORT_OUT")).Text.Trim();
string v_STATEMENTS = ((TextBox)FormView1.FindControl("txtSTATEMENTS")).Text.Trim();
CheckBox cbATTRIBUTE = (CheckBox)((WUI.SLP.SLP_Boolean)FormView1.FindControl("txtATTRIBUTE")).FindControl("C1");
string v_ATTRIBUTE = ((cbATTRIBUTE.Checked) ? "1" : "0");
string v_FIRST_PERIOD = ((TextBox)FormView1.FindControl("txtFIRST_PERIOD")).Text.Trim();
CheckBox cbNEW_SW = (CheckBox)((WUI.SLP.SLP_Boolean)FormView1.FindControl("ddlNEW_SW")).FindControl("C1");
string v_NEW_SW = ((cbNEW_SW.Checked) ? "1" : "0");
string v_PERIOD_STEP = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtPERIOD_STEP")).Text.Trim();
string v_INTERVAL = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtINTERVAL")).Text.Trim();
string v_PUBLISH_TYPE = ((WUI.SLP.CodeFile)FormView1.FindControl("txtPUBLISH_TYPE")).Text.Trim();
string v_UNIT = ((WUI.SLP.EnumBase)FormView1.FindControl("txtUNIT")).Text.Trim();
string v_OPEN_SIZE = ((TextBox)FormView1.FindControl("txtOPEN_SIZE")).Text.Trim();
string v_PAGE_NUM = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtPAGE_NUM")).Text.Trim();
string v_WEIGHT = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtWEIGHT")).Text.Trim();
string v_HEIGHT = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtHEIGHT")).Text.Trim();
string v_LENGTH = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtDEEP")).Text.Trim();
string v_AUTHOR = ((TextBox)FormView1.FindControl("txtAUTHOR")).Text.Trim();
string v_CIP = ((TextBox)FormView1.FindControl("txtCIP")).Text.Trim();
string v_PUBLISH = ((TextBox)FormView1.FindControl("txtPUBLISH")).Text.Trim();
string v_ITEM_PUBLISHER_NO = ((TextBox)FormView1.FindControl("txtITEM_PUBLISHER_NO")).Text.Trim();
string v_ITEM_PUBLISHER_NAME = ((TextBox)FormView1.FindControl("txtITEM_PUBLISHER_NAME")).Text.Trim();
string v_PUBLISHER_TYPE = ((TextBox)FormView1.FindControl("txtPUBLISHER_TYPE")).Text.Trim();
string v_PUBLISH_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtPUBLISH_DATE")).Text.Trim();
//FormView2
string v_DISTRIBUTE_MODE = ((RadioButtonList)FormView2.FindControl("txtDISTRIBUTE_MODE")).Text.Trim();
string v_QUANTITY = ((WUI.SLP.SLPNumber)FormView2.FindControl("txtQUANTITY")).Text.Trim();
string v_ACCEPT_TOTAL = ((WUI.SLP.SLPNumber)FormView2.FindControl("txtACCEPT_TOTAL")).Text.Trim();
string v_RESEMBLE_GOODS = ((TextBox)FormView2.FindControl("txtRESEMBLE_GOODS")).Text.Trim();
string v_GOODS_MATTER = ((TextBox)FormView2.FindControl("txtGOODS_MATTER")).Text.Trim();
string v_COMMEND_CAUSE = ((TextBox)FormView2.FindControl("txtCOMMEND_CAUSE")).Text.Trim();
string v_PATTERN_NO = string.Format("{0}{1}{2}{3}", v_ROOT_NO, v_PMA, v_CATEGORY, v_SORT_OUT);
#endregion 取得畫面元件的值
#region 欄位大小檢查
DateTime dtOut;
if (DateTime.TryParse(v_MDC_START_DATE, out dtOut) == false) { lblMsg.Text = "DC開始日格式錯誤"; return; }
if (DateTime.TryParse(v_MDC_END_DATE, out dtOut) == false) { lblMsg.Text = "DC結束日格式錯誤"; return; }
if (DateTime.Compare(Convert.ToDateTime(v_MDC_START_DATE), Convert.ToDateTime(v_MDC_END_DATE)) > 0)
{
Alert("DC結束日必需大於DC開始日");
return;
}
if (!LengthVaild(v_ITEM_NAME, 30)) { lblMsg.Text = "「品名」長度過長，請重新輸入"; setFieldFocus(((TextBox)FormView1.FindControl("txtITEM_NAME")).ClientID); return; }
if (!LengthVaild(v_VICE_ITEM_NAME, 20)) { lblMsg.Text = "「副主題」長度過長，請重新輸入"; setFieldFocus(((TextBox)FormView1.FindControl("txtVICE_ITEM_NAME")).ClientID); return; }
if (!LengthVaild(v_EDIT_REASON, 50)) { lblMsg.Text = "「異動原因」長度過長，請重新輸入"; setFieldFocus(((TextBox)FormView1.FindControl("txtEDIT_REASON")).ClientID); return; }
if (!LengthVaild(v_STATEMENTS, 30)) { lblMsg.Text = "「敘述」長度過長，請重新輸入"; setFieldFocus(((TextBox)FormView1.FindControl("txtSTATEMENTS")).ClientID); return; }
if (!LengthVaild(v_FIRST_PERIOD, 6)) { lblMsg.Text = "「首期期別」長度過長，請重新輸入"; setFieldFocus(((TextBox)FormView1.FindControl("txtFIRST_PERIOD")).ClientID); return; }
if (!LengthVaild(v_OPEN_SIZE, 10)) { lblMsg.Text = "「開本」長度過長，請重新輸入"; setFieldFocus(((TextBox)FormView1.FindControl("txtOPEN_SIZE")).ClientID); return; }
if (!LengthVaild(v_AUTHOR, 20)) { lblMsg.Text = "「作者」長度過長，請重新輸入"; setFieldFocus(((TextBox)FormView1.FindControl("txtAUTHOR")).ClientID); return; }
if (!LengthVaild(v_CIP, 8)) { lblMsg.Text = "「中央圖書分類碼(CIP)」長度過長，請重新輸入"; setFieldFocus(((TextBox)FormView1.FindControl("txtCIP")).ClientID); return; }
if (!LengthVaild(v_PUBLISH, 10)) { lblMsg.Text = "「VCMS出版社」長度過長，請重新輸入"; setFieldFocus(((TextBox)FormView1.FindControl("txtPUBLISH")).ClientID); return; }
if (!LengthVaild(v_ITEM_PUBLISHER_NO, 10)) { lblMsg.Text = "「商品出版社-代號」長度過長，請重新輸入"; setFieldFocus(((TextBox)FormView1.FindControl("txtITEM_PUBLISHER_NO")).ClientID); return; }
if (!LengthVaild(v_ITEM_PUBLISHER_NAME, 20)) { lblMsg.Text = "「商品出版社-名稱」長度過長，請重新輸入"; setFieldFocus(((TextBox)FormView1.FindControl("txtITEM_PUBLISHER_NAME")).ClientID); return; }
if (!LengthVaild(v_PUBLISHER_TYPE, 2)) { lblMsg.Text = "「出版社書系」長度過長，請重新輸入"; setFieldFocus(((TextBox)FormView1.FindControl("txtPUBLISHER_TYPE")).ClientID); return; }
if (!LengthVaild(v_RESEMBLE_GOODS, 30)) { lblMsg.Text = "商品指定參照頁的「類似商品」長度過長，請重新輸入"; return; }
if (!LengthVaild(v_GOODS_MATTER, 30)) { lblMsg.Text = "商品指定參照頁的「商品說明」長度過長，請重新輸入"; return; }
if (!LengthVaild(v_COMMEND_CAUSE, 30)) { lblMsg.Text = "商品指定參照頁的「推薦理由」長度過長，請重新輸入"; return; }
ParameterList.Clear();
MaintainItemClassify bcoItemClassify = new MaintainItemClassify(ConntionDB);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PATTERN_NO", v_PATTERN_NO, "=", "and");
DataTable dtExists = bcoItemClassify.QueryItemClassifyByFind_1(ParameterList);
if (dtExists.Rows.Count == 0)
{
Alert("此商品Pattern No不存在Pattern主檔，請務必至Pattern No主檔維護作業維護Pattern名稱");
return;
}
//首期期別檢查
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.ITEM", v_ITEM, "=", "and");
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PERIOD", v_FIRST_PERIOD, "=", "and");
DataTable dtFirstPeriod = bcoMain.QuerySKUPeriodByFind_1(ParameterList);
if (dtFirstPeriod.Rows.Count == 0)
{
Alert("所輸入的首期期別資料不存在");
return;
}
#endregion
ParameterList.Clear();
//Old Data
DataTable dt = bco.ConvertXMLToDataTable(MasterOLDData.InnerHtml);
DataRow dr = dt.Rows[0];
#region 新舊值比對
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.ID", dr["ID"].ToString(), "=", "and");
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.ENABLE", 1, "=", "and");
DataTable dtOld = bco.QuerySKUByFind_1(ParameterList);
if (dtOld.Rows.Count == 0)
{ Alert("資料已被刪除，更新失敗"); return; }
else
{
DataRow drOld = dtOld.Rows[0];
if (dr["UpdateUid"].ToString() != drOld["UpdateUid"].ToString() ||
dr["UpdateDate"].ToString() != drOld["UpdateDate"].ToString())
{
Alert("更新失敗，此資料已被其他使用者異動，請重新查詢再進行編輯"); return;
}
}
#endregion
ParameterList.Clear();
#region OLDDATA
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", dr["ID"].ToString()); //OLD_ID
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_UPDATEDATE", dr["UPDATEDATE"].ToString()); //OLD_UPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_UPDATEUID", dr["UPDATEUID"].ToString()); //OLD_UPDATEUID
#endregion OLDDATA
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_CODE", v_ITEM); //NEW_CODE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_ITEM", v_ITEM); //NEW_ITEM
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_EDIT_NO", v_EDIT_NO); //NEW_EDIT_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_ITEM_NAME", v_ITEM_NAME); //NEW_ITEM_NAME
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_MDC_START_DATE", v_MDC_START_DATE); //NEW_MDC_START_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_MDC_END_DATE", v_MDC_END_DATE); //NEW_MDC_END_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PMA", v_PMA); //NEW_PMA
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_CATEGORY", v_CATEGORY); //NEW_CATEGORY
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_SORT_OUT", v_SORT_OUT); //NEW_SORT_OUT
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PATTERN_NO", v_PATTERN_NO); //NEW_PATTERN_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_ATTRIBUTE", v_ATTRIBUTE); //NEW_ATTRIBUTE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_FIRST_PERIOD", v_FIRST_PERIOD); //NEW_FIRST_PERIOD
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_PERIOD_STEP", v_PERIOD_STEP); //NEW_PERIOD_STEP
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_INTERVAL", v_INTERVAL); //NEW_INTERVAL
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PUBLISH_TYPE", v_PUBLISH_TYPE); //NEW_PUBLISH_TYPE
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_UNIT", v_UNIT); //NEW_UNIT
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_STATEMENTS", v_STATEMENTS); //NEW_STATEMENTS
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_DISTRIBUTE_MODE", v_DISTRIBUTE_MODE); //NEW_DISTRIBUTE_MODE
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_QUANTITY", v_QUANTITY); //NEW_QUANTITY
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_RESEMBLE_GOODS", v_RESEMBLE_GOODS); //NEW_RESEMBLE_GOODS
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_GOODS_MATTER", v_GOODS_MATTER); //NEW_GOODS_MATTER
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_COMMEND_CAUSE", v_COMMEND_CAUSE); //NEW_COMMEND_CAUSE
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_POS_DAY", null); //NEW_POS_DAY
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_AUTHOR", v_AUTHOR); //NEW_AUTHOR
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_SERIES", null); //NEW_SERIES
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_QTY_SMALL", null); //NEW_QTY_SMALL
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_QTY_GREAT", null); //NEW_QTY_GREAT
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_POS_SW", null); //NEW_POS_SW
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_POS_RATE", null); //NEW_POS_RATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_NEW_SW", v_NEW_SW); //NEW_NEW_SW
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_QUANTITY1", null); //NEW_QUANTITY1
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_DISTRIBUTE_COMM", null); //NEW_DISTRIBUTE_COMM
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_ACCEPT_TOTAL", v_ACCEPT_TOTAL); //NEW_ACCEPT_TOTAL
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PUBLISH", v_PUBLISH); //NEW_PUBLISH
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_MANUFACTURE", v_MANUFACTURE); //NEW_MANUFACTURE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_ROOT_NO", v_ROOT_NO); //NEW_ROOT_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PUBLISHER_TYPE", v_PUBLISHER_TYPE); //NEW_PUBLISHER_TYPE
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_PUBLISH_DATE", v_PUBLISH_DATE); //NEW_PUBLISH_DATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_VICE_ITEM_NAME", v_VICE_ITEM_NAME); //NEW_VICE_ITEM_NAME
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_OUT_OF_PRINT", v_OUT_OF_PRINT); //NEW_OUT_OF_PRINT
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_OPEN_SIZE", v_OPEN_SIZE); //NEW_OPEN_SIZE
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_PAGE_NUM", v_PAGE_NUM); //NEW_PAGE_NUM
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_CIP", v_CIP); //NEW_CIP
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_EDIT_REASON", v_EDIT_REASON); //NEW_EDIT_REASON
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_ITEM_PUBLISHER_NO", v_ITEM_PUBLISHER_NO); //NEW_ITEM_PUBLISHER_NO
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_ITEM_PUBLISHER_NAME", v_ITEM_PUBLISHER_NAME); //NEW_ITEM_PUBLISHER_NAME
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_LENGTH", v_LENGTH); //NEW_LENGTH
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_WIDTH", v_WEIGHT); //NEW_WIDTH
SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_HIEGHT", v_HEIGHT); //NEW_HIEGHT
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", DateTime.Now); //NEW_UPDATEDATE
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", "sys"); //NEW_UPDATEUID
bco.UpdateSKU(ParameterList, null);
//Response.Write("<script>alert('修改完成');location.replace('ITM012.aspx?ID=" + dr["ID"].ToString() + "');</script>");
//AlertGoTo("修改完成", "ITM012.aspx", dr["ID"].ToString());
Response.Redirect(string.Format("ITM012.aspx?Code=ITM01&isToolBar=N&isUpdate=Y&ID={0}&arl_Key={1}&SessionName={2}');", dr["ID"].ToString(), Request.QueryString["arl_Key"], Request.QueryString["SessionName"]));
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
finally { }
}//end EditCommitButton_Click
//複製新增功能
private void CopyAdd()
{
int res = 0;
int v_ID = 0;
try
{
#region 畫面取值
//string v_ID = 新增前不給號
string v_ITEM = txtBox_ITEM.Text.Trim();
string v_ITEM_NAME = ((TextBox)FormView1.FindControl("txtITEM_NAME")).Text.Trim();
string v_VICE_ITEM_NAME = ((TextBox)FormView1.FindControl("txtVICE_ITEM_NAME")).Text.Trim();
string v_MDC_START_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtMDC_START_DATE")).Text.Trim();
string v_MDC_END_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtMDC_END_DATE")).Text.Trim();
string v_MANUFACTURE = ((WUI.SLP.SLP_VendorBase)FormView1.FindControl("txtMANUFACTURE")).Text.Trim();
//string v_EDIT_NO = string.Format("{0}001", DateTime.Today.ToString("yyyyMMdd"));
string v_EDIT_NO = "0";
string v_EDIT_REASON = ((TextBox)FormView1.FindControl("txtEDIT_REASON")).Text.Trim();
//string v_ROOT_NO = ((DropDownList)FormView1.FindControl("ddlROOT_NO")).Text.Trim();
string v_ROOT_NO = ((WUI.SLP.SLP_RootNo)FormView1.FindControl("ddlROOT_NO")).Text.Trim();
CheckBox cbOUT_OF_PRINT = (CheckBox)((WUI.SLP.SLP_Boolean)FormView1.FindControl("txtOUT_OF_PRINT")).FindControl("C1");
string v_OUT_OF_PRINT = ((cbOUT_OF_PRINT.Checked) ? "1" : "0");
//string v_PMA = ((WUI.SLP.CodeFile)FormView1.FindControl("txtPMA")).Text.Trim();
string v_PMA = ((WUI.SLP.SLP_PMA)FormView1.FindControl("txtPMA")).Text.Trim();
//string v_CATEGORY = ((WUI.SLP.CodeFile)FormView1.FindControl("txtCATEGORY")).Text.Trim();
string v_CATEGORY = ((WUI.SLP.SLP_Category)FormView1.FindControl("txtCATEGORY")).Text.Trim();
//string v_SORT_OUT = ((WUI.SLP.CodeFile)FormView1.FindControl("txtSORT_OUT")).Text.Trim();
string v_SORT_OUT = ((WUI.SLP.SLP_SortOut)FormView1.FindControl("txtSORT_OUT")).Text.Trim();
string v_STATEMENTS = ((TextBox)FormView1.FindControl("txtSTATEMENTS")).Text.Trim();
CheckBox cbATTRIBUTE = (CheckBox)((WUI.SLP.SLP_Boolean)FormView1.FindControl("txtATTRIBUTE")).FindControl("C1");
string v_ATTRIBUTE = ((cbATTRIBUTE.Checked) ? "1" : "0");
string v_FIRST_PERIOD = ((TextBox)FormView1.FindControl("txtFIRST_PERIOD")).Text.Trim();
CheckBox cbNEW_SW = (CheckBox)((WUI.SLP.SLP_Boolean)FormView1.FindControl("ddlNEW_SW")).FindControl("C1");
string v_NEW_SW = ((cbNEW_SW.Checked) ? "1" : "0");
string v_PERIOD_STEP = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtPERIOD_STEP")).Text.Trim();
string v_INTERVAL = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtINTERVAL")).Text.Trim();
string v_PUBLISH_TYPE = ((WUI.SLP.CodeFile)FormView1.FindControl("txtPUBLISH_TYPE")).Text.Trim();
string v_UNIT = ((WUI.SLP.EnumBase)FormView1.FindControl("txtUNIT")).Text.Trim();
string v_OPEN_SIZE = ((TextBox)FormView1.FindControl("txtOPEN_SIZE")).Text.Trim();
string v_PAGE_NUM = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtPAGE_NUM")).Text.Trim();
string v_WEIGHT = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtWEIGHT")).Text.Trim();
string v_HEIGHT = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtHEIGHT")).Text.Trim();
string v_LENGTH = ((WUI.SLP.SLPNumber)FormView1.FindControl("txtDEEP")).Text.Trim();
string v_AUTHOR = ((TextBox)FormView1.FindControl("txtAUTHOR")).Text.Trim();
string v_CIP = ((TextBox)FormView1.FindControl("txtCIP")).Text.Trim();
string v_PUBLISH = ((TextBox)FormView1.FindControl("txtPUBLISH")).Text.Trim();
string v_ITEM_PUBLISHER_NO = ((TextBox)FormView1.FindControl("txtITEM_PUBLISHER_NO")).Text.Trim();
string v_ITEM_PUBLISHER_NAME = ((TextBox)FormView1.FindControl("txtITEM_PUBLISHER_NAME")).Text.Trim();
string v_PUBLISHER_TYPE = ((TextBox)FormView1.FindControl("txtPUBLISHER_TYPE")).Text.Trim();
string v_PUBLISH_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtPUBLISH_DATE")).Text.Trim();
//FormView2
string v_DISTRIBUTE_MODE = ((RadioButtonList)FormView2.FindControl("txtDISTRIBUTE_MODE")).Text.Trim();
string v_QUANTITY = ((WUI.SLP.SLPNumber)FormView2.FindControl("txtQUANTITY")).Text.Trim();
string v_ACCEPT_TOTAL = ((WUI.SLP.SLPNumber)FormView2.FindControl("txtACCEPT_TOTAL")).Text.Trim();
string v_RESEMBLE_GOODS = ((TextBox)FormView2.FindControl("txtRESEMBLE_GOODS")).Text.Trim();
string v_GOODS_MATTER = ((TextBox)FormView2.FindControl("txtGOODS_MATTER")).Text.Trim();
string v_COMMEND_CAUSE = ((TextBox)FormView2.FindControl("txtCOMMEND_CAUSE")).Text.Trim();
string v_PATTERN_NO = string.Format("{0}{1}{2}{3}", v_ROOT_NO, v_PMA, v_CATEGORY, v_SORT_OUT);
#endregion 畫面取值
#region 欄位大小檢查
DateTime dtOut;
if (DateTime.TryParse(v_MDC_START_DATE, out dtOut) == false) { Alert("DC開始日格式錯誤"); return; }
if (DateTime.TryParse(v_MDC_END_DATE, out dtOut) == false) { Alert("DC結束日格式錯誤"); return; }
if (DateTime.Compare(Convert.ToDateTime(v_MDC_START_DATE), Convert.ToDateTime(v_MDC_END_DATE)) > 0)
{
Alert("DC結束日必需大於DC開始日");
return;
}
if (!LengthVaild(v_ITEM, 30)) { Alert("品號資料長度過長，請重新輸入"); return; }
if (!LengthVaild(v_VICE_ITEM_NAME, 20)) { Alert("副主題資料長度過長，請重新輸入"); return; }
if (!LengthVaild(v_EDIT_REASON, 50)) { Alert("異動原因資料長度過長，請重新輸入"); return; }
if (!LengthVaild(v_STATEMENTS, 30)) { Alert("敘述資料長度過長，請重新輸入"); return; }
if (!LengthVaild(v_AUTHOR, 20)) { Alert("作者資料長度過長，請重新輸入"); return; }
ParameterList.Clear();
MaintainItemClassify bcoItemClassify = new MaintainItemClassify(ConntionDB);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PATTERN_NO", v_PATTERN_NO, "=", "and");
DataTable dtExists = bcoItemClassify.QueryItemClassifyByFind_1(ParameterList);
if (dtExists.Rows.Count == 0)
{
Alert("此商品Pattern No不存在Pattern主檔，請務必至Pattern No主檔維護作業維護Pattern名稱");
return;
}
#endregion
ParameterList.Clear();
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCODE", v_ITEM);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM", v_ITEM);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vEDIT_NO", v_EDIT_NO);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM_NAME", v_ITEM_NAME);
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vMDC_START_DATE", v_MDC_START_DATE);
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vMDC_END_DATE", v_MDC_END_DATE);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPMA", v_PMA);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCATEGORY", v_CATEGORY);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vSORT_OUT", v_SORT_OUT);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPATTERN_NO", string.Format("{0}{1}{2}{3}", v_ROOT_NO, v_PMA, v_CATEGORY, v_SORT_OUT));
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vATTRIBUTE", v_ATTRIBUTE);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vFIRST_PERIOD", v_FIRST_PERIOD);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vPERIOD_STEP", v_PERIOD_STEP);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vINTERVAL", v_INTERVAL);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPUBLISH_TYPE", v_PUBLISH_TYPE);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vUNIT", v_UNIT);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vSTATEMENTS", v_STATEMENTS);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vDISTRIBUTE_MODE", v_DISTRIBUTE_MODE);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vQUANTITY", v_QUANTITY);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vRESEMBLE_GOODS", v_RESEMBLE_GOODS);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vGOODS_MATTER", v_GOODS_MATTER);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCOMMEND_CAUSE", v_COMMEND_CAUSE);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vPOS_DAY", null);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vAUTHOR", v_AUTHOR);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vSERIES", null);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vQTY_SMALL", null);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vQTY_GREAT", null);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPOS_SW", null);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vPOS_RATE", null);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vNEW_SW", v_NEW_SW);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vQUANTITY1", null);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vDISTRIBUTE_COMM", null);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vACCEPT_TOTAL", v_ACCEPT_TOTAL);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPUBLISH", v_PUBLISH);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vMANUFACTURE", v_MANUFACTURE);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vROOT_NO", v_ROOT_NO);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPUBLISHER_TYPE", v_PUBLISHER_TYPE);
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vPUBLISH_DATE", v_PUBLISH_DATE);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVICE_ITEM_NAME", v_VICE_ITEM_NAME);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vOUT_OF_PRINT", v_OUT_OF_PRINT);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vOPEN_SIZE", v_OPEN_SIZE);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vPAGE_NUM", v_PAGE_NUM);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCIP", v_CIP);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vEDIT_REASON", v_EDIT_REASON);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM_PUBLISHER_NO", v_ITEM_PUBLISHER_NO);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vITEM_PUBLISHER_NAME", v_ITEM_PUBLISHER_NAME);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vLENGTH", v_LENGTH);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vWIDTH", v_WEIGHT);
SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vHIEGHT", v_HEIGHT);
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vCREATEDATE", DateTime.Now);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCREATEUID", Session["UID"].ToString());
SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vUPDATEDATE", DateTime.Now);
SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vUPDATEUID", Session["UID"].ToString());
v_ID = bco.CreateSKU(ParameterList, null);
//Response.Write("<script>alert('新增完成');location.replace('ITM012.aspx?ID=" + v_ID + "');</script>");
ArrayList arr = new ArrayList();
if ((ArrayList)Session[Request.QueryString["arl_Key"]] != null)
arr = (ArrayList)Session[Request.QueryString["arl_Key"]];
arr.Add(v_ID.ToString());
string arl_Key = "";
if ((ArrayList)Session[Request.QueryString["arl_Key"]] != null)
{
arl_Key = Request.QueryString["arl_Key"];
Session[Request.QueryString["arl_Key"]] = arr;
}
else //從查詢頁直接按新增過來時沒有arl_Key參數，所以在這裏重做一個arl_Key參數
{
arl_Key = "arl_Key" + PageTimeStamp.Value;
Session[arl_Key] = arr;
}
string PageName = "ITM012.aspx";
Page currentPage = (Page)HttpContext.Current.Handler;
string script = string.Format("alert('{0}');location.replace('{1}?Code={2}&isToolBar=N&ID={3}&arl_Key={4}&SessionName={5}');", "新增完成", PageName, PageName.Substring(0, 5), v_ID.ToString(), arl_Key, Request.QueryString["SessionName"]);
ScriptManager.RegisterClientScriptBlock(currentPage, currentPage.GetType(), "CompleteAdd", script, true);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
