/// <summary>
/// 初始化显示信息
/// </summary>
/// <param name="strStockUpID"></param>
private void IniData(string strStockUpID)
{
ordStockUpModel = OrdStockUpBLL.GetInstance().GetOrdStockUpModel(strStockUpID);
if (ordStockUpModel != null)
{
this.labCode.Text = ordStockUpModel.Code;
this.labCreateUserName.Text = ordStockUpModel.Create_User_Name;
this.labStateName.Text = ordStockUpModel.State_Name;
this.labSenderName.Text = ordStockUpModel.Sender_Name;
this.labSendDate.Text = ordStockUpModel.Create_Date;
this.labStateName.Text = ordStockUpModel.State_Name;
}
}
/// <summary>
/// 采购备货单信息对象
/// </summary>
/// <param name="reader">The reader.</param>
/// <param name="row">The row number.</param>
/// <returns></returns>
private object StockUpModel(IDataReader reader, int row)
{
OrdStockUpModel model = new OrdStockUpModel();
model.Id = Convert.ToString(reader["ID"]);
model.Code = Convert.ToString(reader["CODE"]);
model.Sender_Id = Convert.ToString(reader["SENDER_ID"]);
model.Sender_Name = Convert.ToString(reader["SENDER_NAME"]);
model.Sender_Name_Abbr = Convert.ToString(reader["SENDER_NAME_ABBR"]);
model.Create_Date = Convert.ToString(reader["CREATE_DATE"]);
model.State_Name = Convert.ToString(reader["StateName"]);
model.Create_User_Name = Convert.ToString(reader["CREATE_USER_NAME"]);
return(model);
}
/// <summary>
/// 根据备货单ID 获取备货单记录对象
/// </summary>
/// <param name="stock_Id"></param>
public OrdStockUpModel GetOrdStockUpModel(string stock_Id)
{
List <DbParameter> parameters = new List <DbParameter>();
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Select
hoos.ID,
hoos.CODE,
hoos.BUYER_ID,
hoos.SENDER_ID,
hoos.SENDER_NAME,
hoos.SENDER_NAME_ABBR,
hoos.CREATE_USER_NAME,
hoos.CREATE_DATE,
(case hoos.STATE when '1' then '未发送' when '2' then '已发送' when '3' then '买方已确认' when '4' then '作废' when '5' then '确认中' when '6' then '完成' end) As StateName
From HC_ORD_ORD_STOCK As hoos
Where 1=1");
if (!string.IsNullOrEmpty(stock_Id))
{
strSql.Append(" And hoos.ID=@stock_Id");
DbParameter strStock_Id = DbFacade.CreateParameter();
strStock_Id.ParameterName = "stock_Id";
strStock_Id.DbType = DbType.String;
strStock_Id.Value = stock_Id;
parameters.Add(strStock_Id);
}
else
{
return(null);
}
OrdStockUpModel model = null;
model = base.DbFacade.SQLExecuteObject(strSql.ToString(), new MapRow(StockUpModel), parameters.ToArray()) as OrdStockUpModel;
return(model);
}
