/// <summary>
/// 得到一个对象实体
/// </summary>
public ShowShop.Model.Order.ConsignMent GetModelByID(int id)
{
ShowShop.Model.Order.ConsignMent model = new ShowShop.Model.Order.ConsignMent();
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,orderid,username,consignmentdate,expresscompany,expressoddnumbers,consignmentpeople,remark,bosomnote,informmode,notedate,notename,received,consignmenttype from yxs_consignment ");
strSql.Append(" where [id]=@id ");
SqlParameter[] parameters = (SqlParameter[])this.ValueIDPara(id);
using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.Read())
{
model.ID = reader.GetInt32(0);
model.OrderId = reader.GetString(1);
model.UserName = reader.GetString(2);
model.ConsignMentDate = reader.GetDateTime(3);
model.ExpressCompany = reader.GetString(4);
model.ExpressOddNumbers = reader.GetString(5);
model.ConsignMentPeople = reader.GetString(6);
model.Remark = reader.GetString(7);
model.BosomNote = reader.GetString(8);
model.InformMode = reader.GetString(9);
model.NoteDate = reader.GetDateTime(10);
model.NoteName = reader.GetString(11);
model.Received = reader.GetInt32(12);
model.ConsignMentType = reader.GetInt32(13);
}
else
{
model = null;
}
}
return model;
}
protected void lbtnSave_Click(object sender, EventArgs e)
{
ShowShop.Model.Order.ConsignMent model = new ShowShop.Model.Order.ConsignMent();
ShowShop.BLL.Order.ConsignMent bll = new ShowShop.BLL.Order.ConsignMent();
ShowShop.Model.Admin.AdminInfo adminInfo = (ShowShop.Model.Admin.AdminInfo)ShowShop.Common.AdministrorManager.Get();
model.OrderId = this.lblOrderId.Text;
model.UserName = this.lblUserName.Text;
model.ConsignMentDate = Convert.ToDateTime(this.txtConsignMentDate.Text);
model.ExpressCompany = this.ddlExpressCompany.SelectedItem.Text;
model.ExpressOddNumbers = this.txtExpressOddNumbers.Text;
model.ConsignMentPeople = this.txtConsignMentPeople.Text;
model.Remark = this.txtRemark.Text;
model.BosomNote = this.txtBosomNote.Text;
model.InformMode = GetInforMode(cbxInformMode)["txt"]; //通知方式
model.NoteDate = DateTime.Now;
model.NoteName = adminInfo.AdminName;
model.Received = ShowShop.Common.OrdersStatusEnum.OgisticsStatus.已发货.GetHashCode();
model.ConsignMentType = 0;//类型 发货
#region 订单状态
ShowShop.BLL.Order.Orders orderBll = new ShowShop.BLL.Order.Orders();
ShowShop.Model.Order.Orders orderModel = orderBll.GetModel(this.lblOrderId.Text);
#endregion
try
{
bll.Add(model);
#region 操作订单状态
int OrderId = ChangeHope.WebPage.PageRequest.GetQueryInt("OrderId");
orderBll.Amend(OrderId, "OgisticsStatus", ShowShop.Common.OrdersStatusEnum.OgisticsStatus.已发货.GetHashCode());
#endregion
ChangeHope.WebPage.BasePage.PageRight("已保存该信息.", "order_bank_pay.aspx?OrderId=" + orderModel.Id, "<li><a href='order_order_info.aspx?OrderId=" + orderModel.Id.ToString() + "'>返回信息页</a></li>");
return;
}
catch
{
this.ltlMsg.Text = "操作失败！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
}
finally
{
bll = null;
model = null;
}
}
/// <summary>
/// 得到指定条件的所有集合
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public List<ShowShop.Model.Order.ConsignMent> GetAll(string strWhere)
{
List<ShowShop.Model.Order.ConsignMent> list = new List<ShowShop.Model.Order.ConsignMent>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,orderid,username,consignmentdate,expresscompany,expressoddnumbers,consignmentpeople,remark,bosomnote,informmode,notedate,notename,received,consignmenttype from yxs_consignment ");
if (strWhere != null && strWhere != "")
{
strSql.Append("where " + strWhere + " ");
}
using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString()))
{
while (reader.Read())
{
ShowShop.Model.Order.ConsignMent model = new ShowShop.Model.Order.ConsignMent();
model.ID = reader.GetInt32(0);
model.OrderId = reader.GetString(1);
model.UserName = reader.GetString(2);
model.ConsignMentDate = reader.GetDateTime(3);
model.ExpressCompany = reader.GetString(4);
model.ExpressOddNumbers = reader.GetString(5);
model.ConsignMentPeople = reader.GetString(6);
model.Remark = reader.GetString(7);
model.BosomNote = reader.GetString(8);
model.InformMode = reader.GetString(9);
model.NoteDate = reader.GetDateTime(10);
model.NoteName = reader.GetString(11);
model.Received = reader.GetInt32(12);
model.ConsignMentType = reader.GetInt32(13);
list.Add(model);
}
}
return list;
}
