public static List<FisBomItem> GetFisBomItem(string connectionDB, int dbIndex, string TxnId)
{
List<FisBomItem> retList = new List<FisBomItem>();
string strSQL = @"select TxnId, ItemNo, AltGroup, Component, Qty, Unit,
SAPErrorDescr, Editor, Cdt, Udt
from BOM_Compare_Item
where TxnId=@TxnId
order by ItemNo";
DataTable dt = SQLHelper.ExecuteDataFill(SQLHelper.GetDBConnectionString(connectionDB, dbIndex),
System.Data.CommandType.Text,
strSQL,
SQLHelper.CreateSqlParameter("@TxnId", TxnId));
int i = 1;
foreach (DataRow dr in dt.Rows)
{
FisBomItem item = new FisBomItem();
//item.ID = (int)dr["ID"];
item.TxnId = TxnId;
item.ItemNo = dr["ItemNo"].ToString().Trim();
item.AltGroup = (dr["AltGroup"] == null ? "" : dr["AltGroup"].ToString().Trim());
item.Component = dr["Component"].ToString().Trim();
item.Qty = dr["Qty"].ToString().Trim();
item.Unit = dr["Unit"].ToString().Trim();
item.SAPErrorDescr = dr["SAPErrorDescr"].ToString().Trim();
item.Editor = dr["Editor"].ToString().Trim();
item.Cdt = (DateTime)dr["Cdt"];
item.Udt = (DateTime)dr["Udt"];
retList.Add(item);
i++;
}
return retList;
}
/*
public static List<FisBomList> GetFisBomData(string connectionDB, int dbIndex, string spName, string Model)
{
List<FisBomList> retList = new List<FisBomList>();
string strSQL = @"exec @spName @Model";
DataTable dt = SQLHelper.ExecuteDataFill(SQLHelper.GetDBConnectionString(connectionDB, dbIndex),
System.Data.CommandType.Text,
strSQL,
SQLHelper.CreateSqlParameter("@spName", spName),
SQLHelper.CreateSqlParameter("@Model", 16, Model));
int i = 1;
foreach (DataRow dr in dt.Rows)
{
FisBomList item = new FisBomList();
item.ItemNo = i;
item.AltGroup = (dr["AltGroup"] == null ? "":dr["AltGroup"].ToString().Trim());
item.Component = dr["Component"].ToString().Trim();
item.Qty = (int)dr["Qty"];
item.Unit = dr["Unit"].ToString().Trim();
retList.Add(item);
i++;
}
return retList;
}
*/
public static List<FisBomItem> GetFisBomData(string connectionDB, int dbIndex, string spName, string Model, string TxnId)
{
List<FisBomItem> retList = new List<FisBomItem>();
string strSQL = @"exec @spName @Model";
DataTable dt = SQLHelper.ExecuteDataFill(SQLHelper.GetDBConnectionString(connectionDB, dbIndex),
System.Data.CommandType.Text,
strSQL,
SQLHelper.CreateSqlParameter("@spName", spName),
SQLHelper.CreateSqlParameter("@Model", 16, Model));
int i = 1;
int iQty = 0;
foreach (DataRow dr in dt.Rows)
{
FisBomItem item = new FisBomItem();
item.TxnId = TxnId;
item.ItemNo = i.ToString().PadLeft(4, '0');
item.AltGroup = (dr["AltGroup"] == null ? "" : dr["AltGroup"].ToString().Trim());
item.Component = dr["Component"].ToString().Trim();
iQty = (int)dr["Qty"];
item.Qty = iQty.ToString() + ".000";
item.Unit = dr["Unit"].ToString().Trim();
item.SAPErrorDescr = "";
item.Editor = "FIS";
item.Cdt = DateTime.Now;
item.Udt = DateTime.Now;
retList.Add(item);
i++;
}
return retList;
}