private bool GetTaxType(string strItem, string strPeriod) { #region bool bResult = false; try { //ITMModel.MaintainSKUPeriod BCO = new ITMModel.MaintainSKUPeriod(ConnectionDB); //ParameterList.Clear(); //ITMModel.SQLHelper.SQLWhere(ref ParameterList, DbType.String, "ITEM", strItem, "=", "and"); //ITMModel.SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.PERIOD", strPeriod, "=", "and"); // DataTable dt = BCO.QuerySKUPeriodByFind_1(ParameterList); DataTable dt = null; if (strItem != "" && strPeriod != "") { ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(strItem); ParameterList.Add(strPeriod); ALOModel.QueryALOCommon BCO = new ALOModel.QueryALOCommon(ConnectionDB); dt = BCO.QueryItemPeriodInfo(ParameterList); } if (dt != null && dt.Rows.Count > 0 && dt.Rows[0]["TAX_TYPE"] != null && dt.Rows[0]["TAX_TYPE"].ToString().Trim() != "") { i_TaxType = Int32.Parse(dt.Rows[0]["TAX_TYPE"].ToString().Trim()); bResult = true; } else { i_TaxType = 0; bResult = false; } } catch (Exception ex) { throw ex; } return bResult; #endregion }
/// <summary> /// 取得商品期別資訊 /// </summary> /// <param name="strItem"></param> /// <param name="strPeriod"></param> /// <returns></returns> private bool GetTaxType(string strItem, string strPeriod) { #region bool bResult = false; try { DataTable dt = null; if (strItem != "" && strPeriod != "") { ArrayList ParameterList = new ArrayList();//20091113 ParameterList.Clear(); ParameterList.Add(strItem); ParameterList.Add(strPeriod); ALOModel.QueryALOCommon BCO = new ALOModel.QueryALOCommon(ConnectionDB); dt = BCO.QueryItemPeriodInfo(ParameterList); } if (dt != null && dt.Rows.Count > 0 && dt.Rows[0]["TAX_TYPE"] != null && dt.Rows[0]["TAX_TYPE"].ToString().Trim() != "") { bResult = true; } else { bResult = false; } } catch (Exception ex) { throw ex; } return bResult; #endregion }
private string CheckByItemAndPeriod(string strItem, string strPeriod) { #region string strReuslt = ""; try { ALOModel.QueryALOCommon BCO_comm = new ALOModel.QueryALOCommon(ConnectionDB); ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(strItem); ParameterList.Add(strPeriod); DataTable dtTemp = BCO_comm.QueryItemPeriodInfo(ParameterList); if (dtTemp.Rows.Count > 0) { strReuslt = dtTemp.Rows[0]["PRICE"].ToString(); } return strReuslt; } catch (Exception ex) { throw ex; } #endregion }
private bool GetPrice(string strItem, string strPeriod) { #region bool bResult = false; try { ALOModel.QueryALOCommon BCO_comm = new ALOModel.QueryALOCommon(ConnectionDB); ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(strItem); ParameterList.Add(strPeriod); DataTable dtTemp = BCO_comm.QueryItemPeriodInfo(ParameterList); if (dtTemp == null || dtTemp.Rows.Count <= 0) { bResult = false; } else { bResult = true; } return bResult; } catch (Exception ex) { throw ex; } #endregion }
private bool GetItemPeriodDisStateByItemPeriod(string strItem, string strPeriod, string strStAcceptDate, out string strErrMsg) { #region bool bResult = true; strErrMsg = ""; try { ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(strItem); ParameterList.Add(strPeriod); ParameterList.Add(strStAcceptDate); ALOModel.QueryALOCommon BCO_comm = new ALOModel.QueryALOCommon(ConnectionDB); DataTable dtTaxType = BCO_comm.QueryItemPeriodInfo(ParameterList); #region 取得稅別 #endregion s_TAX_TYPE = ""; if(dtTaxType!=null && dtTaxType.Rows.Count>0) { s_TAX_TYPE = dtTaxType.Rows[0]["TAX_TYPE"].ToString().Trim(); } ALOModel.MaintainDisRecord BCO = new ALOModel.MaintainDisRecord(ConnectionDB); Hashtable htTemp = BCO.CheckItemPeriodDisState(ParameterList); #region 取得前六期期別 s_B1_PERIOD = ""; s_B2_PERIOD = ""; s_B3_PERIOD = ""; s_B4_PERIOD = ""; s_B5_PERIOD = ""; s_B6_PERIOD = ""; if (htTemp != null && htTemp.Count != 0) { if (htTemp["PERIODEXIST"].ToString().Trim() == "0") { strErrMsg = string.Format("期別{0},不存在於期別主檔", strPeriod); bResult = false; } else if (htTemp["DIS_DATE"] == null || htTemp["DIS_DATE"].ToString().Trim() != "") { strErrMsg = string.Format("該品號期別於該配本日期已配本"); bResult = true; } if (bResult) { s_B1_PERIOD = htTemp["P_B1"].ToString();//前一期別 s_B2_PERIOD = htTemp["P_B2"].ToString();//前二期別 s_B3_PERIOD = htTemp["P_B3"].ToString();//前三期別 s_B4_PERIOD = htTemp["P_B4"].ToString();//前四期別 s_B5_PERIOD = htTemp["P_B5"].ToString();//前五期別 s_B6_PERIOD = htTemp["P_B6"].ToString();//前六期別 DateTime dtIssDate; DateTime.TryParse(htTemp["ISS_DATE"].ToString(), out dtIssDate); s_ISS_DATE = dtIssDate.ToString("yyyy/MM/dd");//發行日 GetItemPeriodStock(strItem, strPeriod); } } else { strErrMsg = string.Format("期別{0},不存在於期別主檔", strPeriod); bResult = false; } #endregion } catch (Exception ex) { bResult = false; throw ex; } return bResult; #endregion }