public Hashtable ModelToHashtable(lv_B2C.Model.OrderInfo modelOrder)
{
Hashtable ht = new Hashtable();
ht[modelOrder.OrderID] = modelOrder.OrderID;
ht[modelOrder.UserName] = modelOrder.UserName;
ht[modelOrder.OrderNum] = modelOrder.OrderNum;
ht[modelOrder.LogisticsNum] = modelOrder.LogisticsNum;
ht[modelOrder.Consignee] = modelOrder.Consignee;
ht[modelOrder.Province] = modelOrder.Province;
ht[modelOrder.City] = modelOrder.City;
ht[modelOrder.Town] = modelOrder.Town;
ht[modelOrder.Post] = modelOrder.Post;
ht[modelOrder.Address] = modelOrder.Address;
ht[modelOrder.MobilePhone] = modelOrder.MobilePhone;
ht[modelOrder.TelPhone] = modelOrder.TelPhone;
ht[modelOrder.Email] = modelOrder.Email;
ht[modelOrder.Landmark] = modelOrder.Landmark;
ht[modelOrder.BestTime] = modelOrder.BestTime;
ht[modelOrder.Logistics] = modelOrder.Logistics;
ht[modelOrder.LogisticsDetail] = modelOrder.LogisticsDetail;
ht[modelOrder.IsInsure] = modelOrder.IsInsure;
ht[modelOrder.Payment] = modelOrder.Payment;
ht[modelOrder.PaymentDetail] = modelOrder.PaymentDetail;
ht[modelOrder.PayPoundage] = modelOrder.PayPoundage;
ht[modelOrder.InvoiceType] = modelOrder.InvoiceType;
ht[modelOrder.InvoiceTitle] = modelOrder.InvoiceTitle;
ht[modelOrder.InvoiceDetail] = modelOrder.InvoiceDetail;
ht[modelOrder.InvoiceCustomersMsg] = modelOrder.InvoiceCustomersMsg;
ht[modelOrder.InvoiceMerchantsMsg] = modelOrder.InvoiceMerchantsMsg;
ht[modelOrder.InvoiceMoney] = modelOrder.InvoiceMoney;
ht[modelOrder.ProductTotalPrice] = modelOrder.ProductTotalPrice;
ht[modelOrder.Postage] = modelOrder.Postage;
ht[modelOrder.Insurance] = modelOrder.Insurance;
ht[modelOrder.PackingMoney] = modelOrder.PackingMoney;
ht[modelOrder.CARDSMoney] = modelOrder.CARDSMoney;
ht[modelOrder.Discount] = modelOrder.Discount;
ht[modelOrder.DiscountDetail] = modelOrder.DiscountDetail;
ht[modelOrder.PostageDerate] = modelOrder.PostageDerate;
ht[modelOrder.UsedBalance] = modelOrder.UsedBalance;
ht[modelOrder.UsedIntegral] = modelOrder.UsedIntegral;
ht[modelOrder.ProductQuantity] = modelOrder.ProductQuantity;
ht[modelOrder.ProductWeight] = modelOrder.ProductWeight;
ht[modelOrder.ActualPayMoney] = modelOrder.ActualPayMoney;
ht[modelOrder.MerchantsModifyPrice] = modelOrder.MerchantsModifyPrice;
ht[modelOrder.OrderStatus] = modelOrder.OrderStatus;
ht[modelOrder.CreateDate] = modelOrder.CreateDate;
ht[modelOrder.LastModifyDate] = modelOrder.LastModifyDate;
ht[modelOrder.Hits] = modelOrder.Hits;
ht[modelOrder.IsShow] = modelOrder.IsShow;
ht[modelOrder.Types] = modelOrder.Types;
ht[modelOrder.Tag] = modelOrder.Tag;
ht[modelOrder.StringValue] = modelOrder.StringValue;
ht[modelOrder.IsDel] = modelOrder.IsDel;
ht[modelOrder.Sort] = modelOrder.Sort;
ht[modelOrder.ExtendID] = modelOrder.ExtendID;
return ht;
}
/// <summary>
/// 执行更新或新增的存储过程
/// </summary>
private int Merger(lv_B2C.Model.AdPosition model, string strStoredProcedure)
{
try
{
SqlParameter[] parameters = {
new SqlParameter("@AdPositionID", model.AdPositionID) ,
new SqlParameter("@AdPageID", model.AdPageID) ,
new SqlParameter("@ShowType", model.ShowType) ,
new SqlParameter("@Title", model.Title) ,
new SqlParameter("@Title_en", model.Title_en) ,
new SqlParameter("@Detail", model.Detail) ,
new SqlParameter("@Width", model.Width) ,
new SqlParameter("@Height", model.Height) ,
new SqlParameter("@AdPositionType", model.AdPositionType) ,
new SqlParameter("@AdPositionProperty", model.AdPositionProperty) ,
new SqlParameter("@DefaultImg", model.DefaultImg) ,
new SqlParameter("@AlbumID", model.AlbumID) ,
new SqlParameter("@SiteID", model.SiteID) ,
new SqlParameter("@IsShow", model.IsShow) ,
new SqlParameter("@IsDel", model.IsDel) ,
new SqlParameter("@Types", model.Types) ,
new SqlParameter("@Sort", model.Sort) ,
new SqlParameter("@Tag", model.Tag) ,
new SqlParameter("@StringValue", model.StringValue) ,
new SqlParameter("@ExtendID", model.ExtendID)
};
return lv_DBUtility.DBManager.Instance().ExecuteNonQuery(CommandType.StoredProcedure, strStoredProcedure, parameters);
}
catch
{
return -1;
}
}
/// <summary>
/// 执行更新或新增的存储过程
/// </summary>
private int Merger(lv_B2C.Model.AdPage model, string strStoredProcedure)
{
try
{
SqlParameter[] parameters = {
new SqlParameter("@ADPageID", model.ADPageID) ,
new SqlParameter("@Title", model.Title) ,
new SqlParameter("@PagePath", model.PagePath) ,
new SqlParameter("@PreviewImage", model.PreviewImage) ,
new SqlParameter("@Detail", model.Detail) ,
new SqlParameter("@SiteID", model.SiteID) ,
new SqlParameter("@IsShow", model.IsShow) ,
new SqlParameter("@IsDel", model.IsDel) ,
new SqlParameter("@Types", model.Types) ,
new SqlParameter("@Sort", model.Sort) ,
new SqlParameter("@Tag", model.Tag) ,
new SqlParameter("@StringValue", model.StringValue) ,
new SqlParameter("@ExtendID", model.ExtendID)
};
return lv_DBUtility.DBManager.Instance().ExecuteNonQuery(CommandType.StoredProcedure, strStoredProcedure, parameters);
}
catch
{
return -1;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lv_B2C.Model.ChannelItem model)
{
return dal.Add(model);
}
/// <summary>
/// 执行更新或新增的存储过程
/// </summary>
private int Merger(lv_B2C.Model.HomePage model, string strStoredProcedure)
{
try
{
SqlParameter[] parameters = {
new SqlParameter("@PageID", model.PageID) ,
new SqlParameter("@ParentID", model.ParentID) ,
new SqlParameter("@RootID", model.RootID) ,
new SqlParameter("@Title", model.Title) ,
new SqlParameter("@Title_en", model.Title_en) ,
new SqlParameter("@Alt", model.Alt) ,
new SqlParameter("@Link", model.Link) ,
new SqlParameter("@Detail", model.Detail) ,
new SqlParameter("@UserName", model.UserName) ,
new SqlParameter("@AlbumID", model.AlbumID) ,
new SqlParameter("@CreateDate", model.CreateDate) ,
new SqlParameter("@LastModifyDate", model.LastModifyDate) ,
new SqlParameter("@Hits", model.Hits) ,
new SqlParameter("@IsShow", model.IsShow) ,
new SqlParameter("@Types", model.Types) ,
new SqlParameter("@Tag", model.Tag) ,
new SqlParameter("@StringValue", model.StringValue) ,
new SqlParameter("@IsDel", model.IsDel) ,
new SqlParameter("@Sort", model.Sort) ,
new SqlParameter("@ExtendID", model.ExtendID)
};
return lv_DBUtility.DBManager.Instance().ExecuteNonQuery(CommandType.StoredProcedure, strStoredProcedure, parameters);
}
catch
{
return -1;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(lv_B2C.Model.ProductPackage model)
{
return Merger(model, "ProductPackage_Update");
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(lv_B2C.Model.ProductFieldClass model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(lv_B2C.Model.ShippingAddress model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lv_B2C.Model.ArticleClass model)
{
return Merger(model, "ArticleClass_ADD");
}
/// <summary>
/// 执行更新或新增的存储过程
/// </summary>
private int Merger(lv_B2C.Model.ArticleClass model, string strStoredProcedure)
{
try
{
SqlParameter[] parameters = {
new SqlParameter("@ArticleClassID", model.ArticleClassID) ,
new SqlParameter("@LftID", model.LftID) ,
new SqlParameter("@RgtID", model.RgtID) ,
new SqlParameter("@ParentID", model.ParentID) ,
new SqlParameter("@RootID", model.RootID) ,
new SqlParameter("@Title", model.Title) ,
new SqlParameter("@Title_en", model.Title_en) ,
new SqlParameter("@Alt", model.Alt) ,
new SqlParameter("@Images", model.Images) ,
new SqlParameter("@FirstLetter", model.FirstLetter) ,
new SqlParameter("@Readme", model.Readme) ,
new SqlParameter("@ClassKeyWord", model.ClassKeyWord) ,
new SqlParameter("@AlbumID", model.AlbumID) ,
new SqlParameter("@ShowOrder", model.ShowOrder) ,
new SqlParameter("@CreateDate", model.CreateDate) ,
new SqlParameter("@LastModifyDate", model.LastModifyDate) ,
new SqlParameter("@Hits", model.Hits) ,
new SqlParameter("@IsShow", model.IsShow) ,
new SqlParameter("@Types", model.Types) ,
new SqlParameter("@Tag", model.Tag) ,
new SqlParameter("@StringValue", model.StringValue) ,
new SqlParameter("@IsDel", model.IsDel) ,
new SqlParameter("@Sort", model.Sort) ,
new SqlParameter("@ExtendID", model.ExtendID)
};
return lv_DBUtility.DBManager.Instance().ExecuteNonQuery(CommandType.StoredProcedure, strStoredProcedure, parameters);
}
catch
{
return -1;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(lv_B2C.Model.ArticleClass model)
{
return Merger(model, "ArticleClass_Update");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lv_B2C.Model.PriceAnnal model)
{
return Merger(model, "PriceAnnal_ADD");
}
/// <summary>
/// 执行更新或新增的存储过程
/// </summary>
private int Merger(lv_B2C.Model.PriceAnnal model, string strStoredProcedure)
{
try
{
SqlParameter[] parameters = {
new SqlParameter("@PriceAnnalID", model.PriceAnnalID) ,
new SqlParameter("@ProductID", model.ProductID) ,
new SqlParameter("@ProductFieldID", model.ProductFieldID) ,
new SqlParameter("@Title", model.Title) ,
new SqlParameter("@Images", model.Images) ,
new SqlParameter("@Link", model.Link) ,
new SqlParameter("@CurrentPrice", model.CurrentPrice) ,
new SqlParameter("@ShowOrder", model.ShowOrder) ,
new SqlParameter("@LastModifyDate", model.LastModifyDate) ,
new SqlParameter("@Hits", model.Hits) ,
new SqlParameter("@IsShow", model.IsShow) ,
new SqlParameter("@Types", model.Types) ,
new SqlParameter("@Tag", model.Tag) ,
new SqlParameter("@StringValue", model.StringValue) ,
new SqlParameter("@IsDel", model.IsDel) ,
new SqlParameter("@Sort", model.Sort) ,
new SqlParameter("@ExtendID", model.ExtendID)
};
return lv_DBUtility.DBManager.Instance().ExecuteNonQuery(CommandType.StoredProcedure, strStoredProcedure, parameters);
}
catch
{
return -1;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(lv_B2C.Model.PriceAnnal model)
{
return Merger(model, "PriceAnnal_Update");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lv_B2C.Model.AdPosition model)
{
return Merger(model, "AdPosition_ADD");
}
/// <summary>
/// 执行更新或新增的存储过程
/// </summary>
private int Merger(lv_B2C.Model.LogisticsCompany model, string strStoredProcedure)
{
try
{
SqlParameter[] parameters = {
new SqlParameter("@ID", model.ID) ,
new SqlParameter("@LogisticsID", model.LogisticsID) ,
new SqlParameter("@Title", model.Title) ,
new SqlParameter("@Title_en", model.Title_en) ,
new SqlParameter("@Alt", model.Alt) ,
new SqlParameter("@Detail", model.Detail)
};
return lv_DBUtility.DBManager.Instance().ExecuteNonQuery(CommandType.StoredProcedure, strStoredProcedure, parameters);
}
catch
{
return -1;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lv_B2C.Model.LogisticsCompany model)
{
return Merger(model, "LogisticsCompany_ADD");
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(lv_B2C.Model.ProductBrand model)
{
return Merger(model, "ProductBrand_Update");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lv_B2C.Model.ShippingAddress model)
{
return dal.Add(model);
}
/// <summary>
/// 执行更新或新增的存储过程
/// </summary>
private int Merger(lv_B2C.Model.ProductBrand model, string strStoredProcedure)
{
try
{
SqlParameter[] parameters = {
new SqlParameter("@ProductBrandID", model.ProductBrandID) ,
new SqlParameter("@Title", model.Title) ,
new SqlParameter("@Title_en", model.Title_en) ,
new SqlParameter("@Alt", model.Alt) ,
new SqlParameter("@Images", model.Images) ,
new SqlParameter("@Detail", model.Detail) ,
new SqlParameter("@BrandImage", model.BrandImage) ,
new SqlParameter("@IsHot", model.IsHot) ,
new SqlParameter("@IsNew", model.IsNew) ,
new SqlParameter("@ShowOrder", model.ShowOrder) ,
new SqlParameter("@CreateDate", model.CreateDate) ,
new SqlParameter("@LastModifyDate", model.LastModifyDate) ,
new SqlParameter("@Hits", model.Hits) ,
new SqlParameter("@IsShow", model.IsShow) ,
new SqlParameter("@Types", model.Types) ,
new SqlParameter("@Tag", model.Tag) ,
new SqlParameter("@StringValue", model.StringValue) ,
new SqlParameter("@IsDel", model.IsDel) ,
new SqlParameter("@Sort", model.Sort) ,
new SqlParameter("@ExtendID", model.ExtendID)
};
return lv_DBUtility.DBManager.Instance().ExecuteNonQuery(CommandType.StoredProcedure, strStoredProcedure, parameters);
}
catch
{
return -1;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lv_B2C.Model.ProductFieldClass model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lv_B2C.Model.ProductBrand model)
{
return Merger(model, "ProductBrand_ADD");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lv_B2C.Model.ProductPackage model)
{
return Merger(model, "ProductPackage_ADD");
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(lv_B2C.Model.Related model)
{
return Merger(model, "Related_Update");
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(lv_B2C.Model.ChannelItem model)
{
return dal.Update(model);
}
/// <summary>
/// 执行更新或新增的存储过程
/// </summary>
private int Merger(lv_B2C.Model.Related model, string strStoredProcedure)
{
try
{
SqlParameter[] parameters = {
new SqlParameter("@RelatedID", model.RelatedID) ,
new SqlParameter("@Title", model.Title) ,
new SqlParameter("@RelatedType", model.RelatedType) ,
new SqlParameter("@FirstID", model.FirstID) ,
new SqlParameter("@SecondID", model.SecondID) ,
new SqlParameter("@Tag", model.Tag) ,
new SqlParameter("@Types", model.Types)
};
return lv_DBUtility.DBManager.Instance().ExecuteNonQuery(CommandType.StoredProcedure, strStoredProcedure, parameters);
}
catch
{
return -1;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(lv_B2C.Model.AdPage model)
{
return Merger(model, "AdPage_Update");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lv_B2C.Model.Related model)
{
return Merger(model, "Related_ADD");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lv_B2C.Model.AdPage model)
{
return Merger(model, "AdPage_ADD");
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(lv_B2C.Model.LogisticsCompany model)
{
return Merger(model, "LogisticsCompany_Update");
}
