/// <summary>
/// 得到一个对象实体
/// </summary>
public BllShipmentTable GetModel(string slipNumber)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SLIP_NUMBER,ORDER_SLIP_NUMBER,SERIAL_NUMBER,SLIP_DATE,ARRIVAL_DATE,AMOUNT,CURRENCY_CODE,STATUS_FLAG,CREATE_USER,CREATE_DATE_TIME,LAST_UPDATE_TIME,LAST_UPDATE_USER,AMOUNT_INCLUDED_TAX,AMOUNT_WITHOUT_TAX,TAX_RATE,TAX_AMOUNT,COMPANY_CODE ");
strSql.Append(" from BLL_SHIPMENT ");
strSql.Append(" where SLIP_NUMBER=@SLIP_NUMBER ");
SqlParameter[] parameters =
{
new SqlParameter("@SLIP_NUMBER", SqlDbType.VarChar, 50)
};
parameters[0].Value = slipNumber;
BllShipmentTable shipModel = new BllShipmentTable();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
shipModel.SLIP_NUMBER = ds.Tables[0].Rows[0]["SLIP_NUMBER"].ToString();
shipModel.ORDER_SLIP_NUMBER = ds.Tables[0].Rows[0]["ORDER_SLIP_NUMBER"].ToString();
shipModel.SERIAL_NUMBER = ds.Tables[0].Rows[0]["SERIAL_NUMBER"].ToString();
if (ds.Tables[0].Rows[0]["SLIP_DATE"].ToString() != "")
{
shipModel.SLIP_DATE = DateTime.Parse(ds.Tables[0].Rows[0]["SLIP_DATE"].ToString());
}
if (ds.Tables[0].Rows[0]["ARRIVAL_DATE"].ToString() != "")
{
shipModel.ARRIVAL_DATE = DateTime.Parse(ds.Tables[0].Rows[0]["ARRIVAL_DATE"].ToString());
}
if (ds.Tables[0].Rows[0]["AMOUNT"].ToString() != "")
{
shipModel.AMOUNT = decimal.Parse(ds.Tables[0].Rows[0]["AMOUNT"].ToString());
}
shipModel.CURRENCY_CODE = ds.Tables[0].Rows[0]["CURRENCY_CODE"].ToString();
if (ds.Tables[0].Rows[0]["STATUS_FLAG"].ToString() != "")
{
shipModel.STATUS_FLAG = int.Parse(ds.Tables[0].Rows[0]["STATUS_FLAG"].ToString());
}
shipModel.CREATE_USER = ds.Tables[0].Rows[0]["CREATE_USER"].ToString();
if (ds.Tables[0].Rows[0]["CREATE_DATE_TIME"].ToString() != "")
{
shipModel.CREATE_DATE_TIME = DateTime.Parse(ds.Tables[0].Rows[0]["CREATE_DATE_TIME"].ToString());
}
if (ds.Tables[0].Rows[0]["LAST_UPDATE_TIME"].ToString() != "")
{
shipModel.LAST_UPDATE_TIME = DateTime.Parse(ds.Tables[0].Rows[0]["LAST_UPDATE_TIME"].ToString());
}
shipModel.LAST_UPDATE_USER = ds.Tables[0].Rows[0]["LAST_UPDATE_USER"].ToString();
if (ds.Tables[0].Rows[0]["AMOUNT_INCLUDED_TAX"].ToString() != "")
{
shipModel.AMOUNT_INCLUDED_TAX = decimal.Parse(ds.Tables[0].Rows[0]["AMOUNT_INCLUDED_TAX"].ToString());
}
if (ds.Tables[0].Rows[0]["AMOUNT_WITHOUT_TAX"].ToString() != "")
{
shipModel.AMOUNT_WITHOUT_TAX = decimal.Parse(ds.Tables[0].Rows[0]["AMOUNT_WITHOUT_TAX"].ToString());
}
if (ds.Tables[0].Rows[0]["TAX_RATE"].ToString() != "")
{
shipModel.TAX_RATE = decimal.Parse(ds.Tables[0].Rows[0]["TAX_RATE"].ToString());
}
if (ds.Tables[0].Rows[0]["TAX_AMOUNT"].ToString() != "")
{
shipModel.TAX_AMOUNT = decimal.Parse(ds.Tables[0].Rows[0]["TAX_AMOUNT"].ToString());
}
shipModel.COMPANY_CODE = ds.Tables[0].Rows[0]["COMPANY_CODE"].ToString();
strSql = new StringBuilder();
strSql.Append("select * from BLL_SHIPMENT_LINE ");
strSql.Append(" where SLIP_NUMBER=@SLIP_NUMBER ");
SqlParameter[] lineParam =
{
new SqlParameter("@SLIP_NUMBER", SqlDbType.VarChar, 50)
};
lineParam[0].Value = slipNumber;
ds = DbHelperSQL.Query(strSql.ToString(), lineParam);
BllShipmentLineTable lineModel = null;
foreach (DataRow row in ds.Tables[0].Rows)
{
lineModel = new BllShipmentLineTable();
lineModel.SLIP_NUMBER = CConvert.ToString(row["SLIP_NUMBER"]);
lineModel.LINE_NUMBER = CConvert.ToInt32(row["LINE_NUMBER"]);
lineModel.DEPARTUAL_WAREHOUSE_CODE = CConvert.ToString(row["DEPARTUAL_WAREHOUSE_CODE"]);
lineModel.PRODUCT_CODE = CConvert.ToString(row["PRODUCT_CODE"]);
lineModel.QUANTITY = CConvert.ToDecimal(row["QUANTITY"]);
lineModel.UNIT_CODE = CConvert.ToString(row["UNIT_CODE"]);
lineModel.PRICE = CConvert.ToDecimal(row["PRICE"]);
lineModel.AMOUNT = CConvert.ToDecimal(row["AMOUNT"]);
lineModel.MEMO = CConvert.ToString(row["MEMO"]);
lineModel.STATUS_FLAG = CConvert.ToInt32(row["STATUS_FLAG"]);
if (!string.IsNullOrEmpty(lineModel.SLIP_NUMBER))
{
shipModel.AddItems(lineModel);
}
}
return(shipModel);
}
else
{
return(null);
}
}
