public string GiftItemName(string Code,
string ITEM,
string PERIOD
)
{
string Name = "";
string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase;
MaintainGift bcoGift = new MaintainGift(ConnectionDBStr);
if (Code != "")
{
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(Code);
ParameterList.Add(ITEM);
ParameterList.Add(PERIOD);
DataTable dt = bcoGift.QueryUnionItemForSLP(ParameterList);
Name = ((dt.Rows.Count > 0) ? dt.Rows[0]["VIRTUAL_NAME"].ToString() : "查無資料");
}
return Name;
}
private string GetVIRTUAL_NAME(string strVIRTUAL_CODE)
{
ParameterList.Clear();
ParameterList.Add(strVIRTUAL_CODE);
ParameterList.Add("");
ParameterList.Add("");
PIC.VDS2G.BSM.MKT.MaintainGift bcoGift = new PIC.VDS2G.BSM.MKT.MaintainGift(ConntionDB);
DataTable dt = bcoGift.QueryUnionItemForSLP(ParameterList);
string strName = ((dt.Rows.Count > 0) ? dt.Rows[0]["VIRTUAL_NAME"].ToString() : "查無資料");
return strName;
}