/// <summary> /// ��������б� /// </summary> public List<NoName.NetShop.Model.OrderModel> GetModelList(string strWhere) { DataSet ds = dal.GetList(strWhere); List<NoName.NetShop.Model.OrderModel> modelList = new List<NoName.NetShop.Model.OrderModel>(); int rowsCount = ds.Tables[0].Rows.Count; if (rowsCount > 0) { NoName.NetShop.Model.OrderModel model; for (int n = 0; n < rowsCount; n++) { model = new NoName.NetShop.Model.OrderModel(); if(ds.Tables[0].Rows[n]["UserId"].ToString()!="") { model.UserId=int.Parse(ds.Tables[0].Rows[n]["UserId"].ToString()); } if(ds.Tables[0].Rows[n]["OrderId"].ToString()!="") { model.OrderId=int.Parse(ds.Tables[0].Rows[n]["OrderId"].ToString()); } if(ds.Tables[0].Rows[n]["OrderStatus"].ToString()!="") { model.OrderStatus=int.Parse(ds.Tables[0].Rows[n]["OrderStatus"].ToString()); } if(ds.Tables[0].Rows[n]["PayMethod"].ToString()!="") { model.PayMethod=int.Parse(ds.Tables[0].Rows[n]["PayMethod"].ToString()); } if(ds.Tables[0].Rows[n]["ShipMethod"].ToString()!="") { model.ShipMethod=int.Parse(ds.Tables[0].Rows[n]["ShipMethod"].ToString()); } if(ds.Tables[0].Rows[n]["PayStatus"].ToString()!="") { model.PayStatus=int.Parse(ds.Tables[0].Rows[n]["PayStatus"].ToString()); } if(ds.Tables[0].Rows[n]["Paysum"].ToString()!="") { model.Paysum=decimal.Parse(ds.Tables[0].Rows[n]["Paysum"].ToString()); } if(ds.Tables[0].Rows[n]["ShipFee"].ToString()!="") { model.ShipFee=decimal.Parse(ds.Tables[0].Rows[n]["ShipFee"].ToString()); } if(ds.Tables[0].Rows[n]["ProductFee"].ToString()!="") { model.ProductFee=decimal.Parse(ds.Tables[0].Rows[n]["ProductFee"].ToString()); } if(ds.Tables[0].Rows[n]["DerateFee"].ToString()!="") { model.DerateFee=decimal.Parse(ds.Tables[0].Rows[n]["DerateFee"].ToString()); } if(ds.Tables[0].Rows[n]["AddressId"].ToString()!="") { model.AddressId=int.Parse(ds.Tables[0].Rows[n]["AddressId"].ToString()); } model.RecieverName=ds.Tables[0].Rows[n]["RecieverName"].ToString(); model.RecieverEmail=ds.Tables[0].Rows[n]["RecieverEmail"].ToString(); model.RecieverPhone=ds.Tables[0].Rows[n]["RecieverPhone"].ToString(); model.Postalcode=ds.Tables[0].Rows[n]["Postalcode"].ToString(); model.RecieverCity=ds.Tables[0].Rows[n]["RecieverCity"].ToString(); model.RecieverProvince=ds.Tables[0].Rows[n]["RecieverProvince"].ToString(); model.AddressDetial=ds.Tables[0].Rows[n]["AddressDetial"].ToString(); if(ds.Tables[0].Rows[n]["ChangeTime"].ToString()!="") { model.ChangeTime=DateTime.Parse(ds.Tables[0].Rows[n]["ChangeTime"].ToString()); } if(ds.Tables[0].Rows[n]["PayTime"].ToString()!="") { model.PayTime=DateTime.Parse(ds.Tables[0].Rows[n]["PayTime"].ToString()); } if(ds.Tables[0].Rows[n]["CreateTime"].ToString()!="") { model.CreateTime=DateTime.Parse(ds.Tables[0].Rows[n]["CreateTime"].ToString()); } if(ds.Tables[0].Rows[n]["OrderType"].ToString()!="") { model.OrderType=int.Parse(ds.Tables[0].Rows[n]["OrderType"].ToString()); } modelList.Add(model); } } return modelList; }
/// <summary> /// 增加一条数据 /// </summary> public void Add(NoName.NetShop.Model.OrderModel model) { dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(NoName.NetShop.Model.OrderModel model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <NoName.NetShop.Model.OrderModel> GetModelList(string strWhere) { DataSet ds = dal.GetList(strWhere); List <NoName.NetShop.Model.OrderModel> modelList = new List <NoName.NetShop.Model.OrderModel>(); int rowsCount = ds.Tables[0].Rows.Count; if (rowsCount > 0) { NoName.NetShop.Model.OrderModel model; for (int n = 0; n < rowsCount; n++) { model = new NoName.NetShop.Model.OrderModel(); if (ds.Tables[0].Rows[n]["UserId"].ToString() != "") { model.UserId = int.Parse(ds.Tables[0].Rows[n]["UserId"].ToString()); } if (ds.Tables[0].Rows[n]["OrderId"].ToString() != "") { model.OrderId = int.Parse(ds.Tables[0].Rows[n]["OrderId"].ToString()); } if (ds.Tables[0].Rows[n]["OrderStatus"].ToString() != "") { model.OrderStatus = int.Parse(ds.Tables[0].Rows[n]["OrderStatus"].ToString()); } if (ds.Tables[0].Rows[n]["PayMethod"].ToString() != "") { model.PayMethod = int.Parse(ds.Tables[0].Rows[n]["PayMethod"].ToString()); } if (ds.Tables[0].Rows[n]["ShipMethod"].ToString() != "") { model.ShipMethod = int.Parse(ds.Tables[0].Rows[n]["ShipMethod"].ToString()); } if (ds.Tables[0].Rows[n]["PayStatus"].ToString() != "") { model.PayStatus = int.Parse(ds.Tables[0].Rows[n]["PayStatus"].ToString()); } if (ds.Tables[0].Rows[n]["Paysum"].ToString() != "") { model.Paysum = decimal.Parse(ds.Tables[0].Rows[n]["Paysum"].ToString()); } if (ds.Tables[0].Rows[n]["ShipFee"].ToString() != "") { model.ShipFee = decimal.Parse(ds.Tables[0].Rows[n]["ShipFee"].ToString()); } if (ds.Tables[0].Rows[n]["ProductFee"].ToString() != "") { model.ProductFee = decimal.Parse(ds.Tables[0].Rows[n]["ProductFee"].ToString()); } if (ds.Tables[0].Rows[n]["DerateFee"].ToString() != "") { model.DerateFee = decimal.Parse(ds.Tables[0].Rows[n]["DerateFee"].ToString()); } if (ds.Tables[0].Rows[n]["AddressId"].ToString() != "") { model.AddressId = int.Parse(ds.Tables[0].Rows[n]["AddressId"].ToString()); } model.RecieverName = ds.Tables[0].Rows[n]["RecieverName"].ToString(); model.RecieverEmail = ds.Tables[0].Rows[n]["RecieverEmail"].ToString(); model.RecieverPhone = ds.Tables[0].Rows[n]["RecieverPhone"].ToString(); model.Postalcode = ds.Tables[0].Rows[n]["Postalcode"].ToString(); model.RecieverCity = ds.Tables[0].Rows[n]["RecieverCity"].ToString(); model.RecieverProvince = ds.Tables[0].Rows[n]["RecieverProvince"].ToString(); model.AddressDetial = ds.Tables[0].Rows[n]["AddressDetial"].ToString(); if (ds.Tables[0].Rows[n]["ChangeTime"].ToString() != "") { model.ChangeTime = DateTime.Parse(ds.Tables[0].Rows[n]["ChangeTime"].ToString()); } if (ds.Tables[0].Rows[n]["PayTime"].ToString() != "") { model.PayTime = DateTime.Parse(ds.Tables[0].Rows[n]["PayTime"].ToString()); } if (ds.Tables[0].Rows[n]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[n]["CreateTime"].ToString()); } if (ds.Tables[0].Rows[n]["OrderType"].ToString() != "") { model.OrderType = int.Parse(ds.Tables[0].Rows[n]["OrderType"].ToString()); } modelList.Add(model); } } return(modelList); }