//''' <summary>
//''' 取得指定類別的類別名稱組(以逗號分開)忽略啟用
//''' </summary>
//''' <param name="TopCdeS">TYP(前置三碼)</param>
//''' <param name="TypTidStr">T001,T002,T003(可複選)</param>
//''' <returns></returns>
//''' <remarks></remarks>
public String getTypSubA(String TopCdeS, String TypTidStr)
{
IZCls.WebFormBase WebFormBase = new IZCls.WebFormBase();
IZCls.DataAccess DataAccess = new IZCls.DataAccess();
TypTidStr = DataAccess.ClsSqlChr(TypTidStr);
String TypTidSql = WebFormBase.DotToSqlStr(TypTidStr);
IzDataSource IzDataSource = new IzDataSource();
IzDataSource.SelectString = "select tbTypSub from tbTyp where left(tbTypCde,3)=@TopCdeS and tbTypTid in (" + TypTidSql + ")";
IzDataSource.ParametersClear();
IzDataSource.ParametersAdd("TopCdeS", TopCdeS);
System.Data.DataTable tb = IzDataSource.SelectDataTable();
String StrTmp = "";
for (int i = 0; i < tb.Rows.Count; i++)
{
if (StrTmp == "")
{
StrTmp = tb.Rows[i]["tbTypSub"].ToString();
}
else
{
StrTmp += "," + tb.Rows[i]["tbTypSub"].ToString();
}
}
tb.Dispose();
IzDataSource.Dispose();
return(StrTmp);
}
