public static string checkStoreData(string ROUTE, string EFF_START, string EFF_END, string CHAN_NO, string stordID, string id, string PageTimeStamp) { #region String rtnValue = ""; if (stordID != "") { STMModel.MaintainRouteLine bco = new STMModel.MaintainRouteLine(ConnectionDB); int intDUP = 0; //當id不等於空白,表示已存在資料庫中 if (id != "") { // 查詢PK是否存在且是否為同一筆id ParameterList.Clear(); ParameterList.Add(ROUTE); ParameterList.Add(EFF_START); ParameterList.Add(CHAN_NO); ParameterList.Add(stordID); ParameterList.Add(id); DataTable countsDt = bco.QueryExistDB(ParameterList); if (countsDt.Rows.Count > 0) { rtnValue = CHAN_NO + "|" + stordID + "|" + "transFail"; } } else { //查詢PK是否存在 ParameterList.Clear(); ParameterList.Add(ROUTE); ParameterList.Add(EFF_START); ParameterList.Add(CHAN_NO); ParameterList.Add(stordID); DataTable countsDt = bco.QueryExistPK(ParameterList); if (countsDt.Rows.Count > 0) { DataTable dt = (DataTable)HttpContext.Current.Session["STM23_DTL_" + PageTimeStamp]; foreach (DataRow dr in dt.Rows) { if (dr.RowState != DataRowState.Deleted) { if (dr["CHAN_NO"].ToString() == CHAN_NO && dr["STORE"].ToString() == stordID) { intDUP++; } } } if (intDUP > 0) { rtnValue = CHAN_NO + "|" + stordID + "|" + "transFail"; } } } if (rtnValue == "") { ParameterList.Clear(); ParameterList.Add(CHAN_NO); ParameterList.Add(stordID); // 查詢是否存在VDS_STM_STORE_UNIQUE DataTable countsDt = bco.CheckStore(ParameterList); if (countsDt.Rows.Count == 0) { rtnValue = CHAN_NO + "|" + stordID + "|" + "fail"; } } if (rtnValue == "") { ParameterList.Clear(); ParameterList.Add(ROUTE); ParameterList.Add(CHAN_NO); ParameterList.Add(stordID); ParameterList.Add(EFF_START); ParameterList.Add(EFF_END); //在生效中的路線,應不可存在同樣的門市資料 DataTable DupStoreDt = bco.CheckDupStore(ParameterList); if (DupStoreDt.Rows[0][0].ToString() == "0") { rtnValue = CHAN_NO + "|" + stordID + "|" + "ok"; } else { rtnValue = CHAN_NO + "|" + stordID + "|" + "dupfail"; } } } return rtnValue; #endregion }