/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.DeliveryData DataRowToModel(DataRow row)
{
Maticsoft.Model.DeliveryData model = new Maticsoft.Model.DeliveryData();
if (row != null)
{
if (row["PhoneNumber"] != null)
{
model.PhoneNumber = row["PhoneNumber"].ToString();
}
if (row["DeliveryDate"] != null && row["DeliveryDate"].ToString() != "")
{
model.DeliveryDate = DateTime.Parse(row["DeliveryDate"].ToString());
}
if (row["CustomerName"] != null)
{
model.CustomerName = row["CustomerName"].ToString();
}
if (row["Province"] != null)
{
model.Province = row["Province"].ToString();
}
if (row["City"] != null)
{
model.City = row["City"].ToString();
}
if (row["Address"] != null)
{
model.Address = row["Address"].ToString();
}
if (row["CourierID"] != null)
{
model.CourierID = row["CourierID"].ToString();
}
if (row["CourierCompanyName"] != null)
{
model.CourierCompanyName = row["CourierCompanyName"].ToString();
}
if (row["GiftPacks"] != null && row["GiftPacks"].ToString() != "")
{
model.GiftPacks = int.Parse(row["GiftPacks"].ToString());
}
if (row["ProductPacks"] != null && row["ProductPacks"].ToString() != "")
{
model.ProductPacks = int.Parse(row["ProductPacks"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.DeliveryData GetModel(string PhoneNumber, DateTime DeliveryDate)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 PhoneNumber,DeliveryDate,CustomerName,Province,City,Address,CourierID,CourierCompanyName,GiftPacks,ProductPacks from DeliveryData ");
strSql.Append(" where PhoneNumber=@PhoneNumber and DeliveryDate=@DeliveryDate ");
SqlParameter[] parameters = {
new SqlParameter("@PhoneNumber", SqlDbType.NVarChar,50),
new SqlParameter("@DeliveryDate", SqlDbType.DateTime) };
parameters[0].Value = PhoneNumber;
parameters[1].Value = DeliveryDate;
Maticsoft.Model.DeliveryData model = new Maticsoft.Model.DeliveryData();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
