public string GetSKUVenderName(string Code,
string Manufacture
)
{
string Name = "";
string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase;
OUT01_SKUDBO co_main = new OUT01_SKUDBO(ConnectionDBStr);
if (Code != "")
{
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(Code);
ParameterList.Add(Code);
ParameterList.Add(Manufacture);
DataTable dt = co_main.doQueryVenderSLP(ParameterList);
Name = ((dt.Rows.Count > 0) ? dt.Rows[0]["ITEM_NAME"].ToString() : "查無資料");
}
return Name;
}
public DataTable QueryVenderSLP(ArrayList ParameterList)
{
try
{
DBO.OUT01_SKUDBO dbo = new OUT01_SKUDBO(ref USEDB);
return dbo.doQueryVenderSLP(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}