public SMZJ.Model.TB_QUOTA_DETAIL_TMP GetModel(int AUTO_NO)
{
StringBuilder builder = new StringBuilder();
builder.Append("select AUTO_NO,PD_QUOTA_CODE,COMPANY_NAME,FILE_NAME,FILE_SYSNAME,COMPANY_CODE,FILE_TYPE from TB_QUOTA_DETAIL_TMP ");
builder.Append(" where AUTO_NO=:AUTO_NO ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_NO", OracleType.Number, 4) };
cmdParms[0].Value = AUTO_NO;
SMZJ.Model.TB_QUOTA_DETAIL_TMP tb_quota_detail_tmp = new SMZJ.Model.TB_QUOTA_DETAIL_TMP();
DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if (set.Tables[0].Rows[0]["AUTO_NO"].ToString() != "")
{
tb_quota_detail_tmp.AUTO_NO = int.Parse(set.Tables[0].Rows[0]["AUTO_NO"].ToString());
}
tb_quota_detail_tmp.PD_QUOTA_CODE = set.Tables[0].Rows[0]["PD_QUOTA_CODE"].ToString();
tb_quota_detail_tmp.COMPANY_NAME = set.Tables[0].Rows[0]["COMPANY_NAME"].ToString();
tb_quota_detail_tmp.FILE_NAME = set.Tables[0].Rows[0]["FILE_NAME"].ToString();
tb_quota_detail_tmp.FILE_SYSNAME = set.Tables[0].Rows[0]["FILE_SYSNAME"].ToString();
tb_quota_detail_tmp.COMPANY_CODE = set.Tables[0].Rows[0]["COMPANY_CODE"].ToString();
tb_quota_detail_tmp.FILE_TYPE = set.Tables[0].Rows[0]["FILE_TYPE"].ToString();
return tb_quota_detail_tmp;
}
public List<SMZJ.Model.TB_QUOTA_DETAIL_TMP> DataTableToList(DataTable dt)
{
List<SMZJ.Model.TB_QUOTA_DETAIL_TMP> list = new List<SMZJ.Model.TB_QUOTA_DETAIL_TMP>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
SMZJ.Model.TB_QUOTA_DETAIL_TMP item = new SMZJ.Model.TB_QUOTA_DETAIL_TMP();
if (dt.Rows[i]["AUTO_NO"].ToString() != "")
{
item.AUTO_NO = int.Parse(dt.Rows[i]["AUTO_NO"].ToString());
}
item.PD_QUOTA_CODE = dt.Rows[i]["PD_QUOTA_CODE"].ToString();
item.COMPANY_NAME = dt.Rows[i]["COMPANY_NAME"].ToString();
item.FILE_NAME = dt.Rows[i]["FILE_NAME"].ToString();
item.FILE_SYSNAME = dt.Rows[i]["FILE_SYSNAME"].ToString();
item.COMPANY_CODE = dt.Rows[i]["COMPANY_CODE"].ToString();
item.FILE_TYPE = dt.Rows[i]["FILE_TYPE"].ToString();
list.Add(item);
}
}
return list;
}