/// <summary>
/// 根据goodsid编号获取自定义属性集合(新型),判断是否null返回
/// </summary>
public DataTable GetMorePropertyInfo(string goodsId)
{
GoodsModel mod = dal.GetModel(goodsId);
if (mod != null)
{
GoodsTypeModel modCate = new GoodsTypeBll().GetModel(mod.CategoryId);
if (modCate != null)
{
//DataTable dt = new TableObject("T_Goods_MorePropertySet").Util_GetList("*", "propertyId in(select morePropertyId from T_Goods_Category_MoreProperty where categoryId='" + modCate.CategoryId + "')");
string strSQL = "select * from T_Goods_MorePropertySet where propertyId in(select morePropertyId from T_Goods_Category_MoreProperty where categoryId='" + modCate.CategoryId + "');";
AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance);
DataTable dt = adohelper.ExecuteSqlDataset(strSQL).Tables[0];
return(dt);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public GoodsModel GetModel(string GoodsId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from T_Goods_Info ");
strSql.Append(" where GoodsId=@GoodsId ");
SqlParameter[] parameters =
{
new SqlParameter("@GoodsId", SqlDbType.VarChar, 50)
};
parameters[0].Value = GoodsId;
GoodsModel model = new GoodsModel();
DataSet ds = adoHelper.ExecuteSqlDataset(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["GoodsId"] != null && ds.Tables[0].Rows[0]["GoodsId"].ToString() != "")
{
model.GoodsId = ds.Tables[0].Rows[0]["GoodsId"].ToString();
}
if (ds.Tables[0].Rows[0]["CategoryId"] != null && ds.Tables[0].Rows[0]["CategoryId"].ToString() != "")
{
model.CategoryId = ds.Tables[0].Rows[0]["CategoryId"].ToString();
}
if (ds.Tables[0].Rows[0]["GoodsToTypeId"] != null && ds.Tables[0].Rows[0]["GoodsToTypeId"].ToString() != "")
{
model.GoodsToTypeId = ds.Tables[0].Rows[0]["GoodsToTypeId"].ToString();
}
if (ds.Tables[0].Rows[0]["BrandId"] != null && ds.Tables[0].Rows[0]["BrandId"].ToString() != "")
{
model.BrandId = ds.Tables[0].Rows[0]["BrandId"].ToString();
}
if (ds.Tables[0].Rows[0]["GoodsName"] != null && ds.Tables[0].Rows[0]["GoodsName"].ToString() != "")
{
model.GoodsName = ds.Tables[0].Rows[0]["GoodsName"].ToString();
}
if (ds.Tables[0].Rows[0]["GoodsCode"] != null && ds.Tables[0].Rows[0]["GoodsCode"].ToString() != "")
{
model.GoodsCode = ds.Tables[0].Rows[0]["GoodsCode"].ToString();
}
if (ds.Tables[0].Rows[0]["Uint"] != null && ds.Tables[0].Rows[0]["Uint"].ToString() != "")
{
model.Uint = ds.Tables[0].Rows[0]["Uint"].ToString();
}
if (ds.Tables[0].Rows[0]["Weight"] != null && ds.Tables[0].Rows[0]["Weight"].ToString() != "")
{
model.Weight = int.Parse(ds.Tables[0].Rows[0]["Weight"].ToString());
}
if (ds.Tables[0].Rows[0]["GoodsSmallPic"] != null && ds.Tables[0].Rows[0]["GoodsSmallPic"].ToString() != "")
{
model.GoodsSmallPic = ds.Tables[0].Rows[0]["GoodsSmallPic"].ToString();
}
if (ds.Tables[0].Rows[0]["GoodsSampleDesc"] != null && ds.Tables[0].Rows[0]["GoodsSampleDesc"].ToString() != "")
{
model.GoodsSampleDesc = ds.Tables[0].Rows[0]["GoodsSampleDesc"].ToString();
}
if (ds.Tables[0].Rows[0]["GoodsDesc"] != null && ds.Tables[0].Rows[0]["GoodsDesc"].ToString() != "")
{
model.GoodsDesc = ds.Tables[0].Rows[0]["GoodsDesc"].ToString();
}
if (ds.Tables[0].Rows[0]["GoodsDesc2"] != null && ds.Tables[0].Rows[0]["GoodsDesc2"].ToString() != "")
{
model.GoodsDesc2 = ds.Tables[0].Rows[0]["GoodsDesc2"].ToString();
}
if (ds.Tables[0].Rows[0]["GoodsDesc3"] != null && ds.Tables[0].Rows[0]["GoodsDesc3"].ToString() != "")
{
model.GoodsDesc3 = ds.Tables[0].Rows[0]["GoodsDesc3"].ToString();
}
if (ds.Tables[0].Rows[0]["GoodsDesc4"] != null && ds.Tables[0].Rows[0]["GoodsDesc4"].ToString() != "")
{
model.GoodsDesc4 = ds.Tables[0].Rows[0]["GoodsDesc4"].ToString();
}
if (ds.Tables[0].Rows[0]["GoodsDesc5"] != null && ds.Tables[0].Rows[0]["GoodsDesc5"].ToString() != "")
{
model.GoodsDesc5 = ds.Tables[0].Rows[0]["GoodsDesc5"].ToString();
}
if (ds.Tables[0].Rows[0]["IsRec"] != null && ds.Tables[0].Rows[0]["IsRec"].ToString() != "")
{
model.IsRec = int.Parse(ds.Tables[0].Rows[0]["IsRec"].ToString());
}
if (ds.Tables[0].Rows[0]["IsHot"] != null && ds.Tables[0].Rows[0]["IsHot"].ToString() != "")
{
model.IsHot = int.Parse(ds.Tables[0].Rows[0]["IsHot"].ToString());
}
if (ds.Tables[0].Rows[0]["IsNew"] != null && ds.Tables[0].Rows[0]["IsNew"].ToString() != "")
{
model.IsNew = int.Parse(ds.Tables[0].Rows[0]["IsNew"].ToString());
}
if (ds.Tables[0].Rows[0]["IsSpe"] != null && ds.Tables[0].Rows[0]["IsSpe"].ToString() != "")
{
model.IsSpe = int.Parse(ds.Tables[0].Rows[0]["IsSpe"].ToString());
}
if (ds.Tables[0].Rows[0]["SalePrice"] != null && ds.Tables[0].Rows[0]["SalePrice"].ToString() != "")
{
model.SalePrice = decimal.Parse(ds.Tables[0].Rows[0]["SalePrice"].ToString());
}
if (ds.Tables[0].Rows[0]["MarketPrice"] != null && ds.Tables[0].Rows[0]["MarketPrice"].ToString() != "")
{
model.MarketPrice = decimal.Parse(ds.Tables[0].Rows[0]["MarketPrice"].ToString());
}
if (ds.Tables[0].Rows[0]["CBPrice"] != null && ds.Tables[0].Rows[0]["CBPrice"].ToString() != "")
{
model.CBPrice = decimal.Parse(ds.Tables[0].Rows[0]["CBPrice"].ToString());
}
if (ds.Tables[0].Rows[0]["IsSale"] != null && ds.Tables[0].Rows[0]["IsSale"].ToString() != "")
{
model.IsSale = int.Parse(ds.Tables[0].Rows[0]["IsSale"].ToString());
}
if (ds.Tables[0].Rows[0]["Sotck"] != null && ds.Tables[0].Rows[0]["Sotck"].ToString() != "")
{
model.Sotck = int.Parse(ds.Tables[0].Rows[0]["Sotck"].ToString());
}
if (ds.Tables[0].Rows[0]["MinSaleNumber"] != null && ds.Tables[0].Rows[0]["MinSaleNumber"].ToString() != "")
{
model.MinSaleNumber = int.Parse(ds.Tables[0].Rows[0]["MinSaleNumber"].ToString());
}
if (ds.Tables[0].Rows[0]["MaxSaleNumber"] != null && ds.Tables[0].Rows[0]["MaxSaleNumber"].ToString() != "")
{
model.MaxSaleNumber = int.Parse(ds.Tables[0].Rows[0]["MaxSaleNumber"].ToString());
}
if (ds.Tables[0].Rows[0]["Orderby"] != null && ds.Tables[0].Rows[0]["Orderby"].ToString() != "")
{
model.Orderby = int.Parse(ds.Tables[0].Rows[0]["Orderby"].ToString());
}
if (ds.Tables[0].Rows[0]["ViewCount"] != null && ds.Tables[0].Rows[0]["ViewCount"].ToString() != "")
{
model.ViewCount = int.Parse(ds.Tables[0].Rows[0]["ViewCount"].ToString());
}
if (ds.Tables[0].Rows[0]["TotalSaleCount"] != null && ds.Tables[0].Rows[0]["TotalSaleCount"].ToString() != "")
{
model.TotalSaleCount = int.Parse(ds.Tables[0].Rows[0]["TotalSaleCount"].ToString());
}
if (ds.Tables[0].Rows[0]["Remarks"] != null && ds.Tables[0].Rows[0]["Remarks"].ToString() != "")
{
model.Remarks = ds.Tables[0].Rows[0]["Remarks"].ToString();
}
if (ds.Tables[0].Rows[0]["AddTime"] != null && ds.Tables[0].Rows[0]["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString());
}
if (ds.Tables[0].Rows[0]["AreaInfo"] != null && ds.Tables[0].Rows[0]["AreaInfo"].ToString() != "")
{
model.AreaInfo = ds.Tables[0].Rows[0]["AreaInfo"].ToString();
}
if (ds.Tables[0].Rows[0]["BookInfo"] != null && ds.Tables[0].Rows[0]["BookInfo"].ToString() != "")
{
model.BookInfo = ds.Tables[0].Rows[0]["BookInfo"].ToString();
}
if (ds.Tables[0].Rows[0]["ProviderInfo"] != null && ds.Tables[0].Rows[0]["ProviderInfo"].ToString() != "")
{
model.ProviderInfo = ds.Tables[0].Rows[0]["ProviderInfo"].ToString();
}
if (ds.Tables[0].Rows[0]["DataFrom"] != null && ds.Tables[0].Rows[0]["DataFrom"].ToString() != "")
{
model.DataFrom = ds.Tables[0].Rows[0]["DataFrom"].ToString();
}
if (ds.Tables[0].Rows[0]["MorePropertys"] != null && ds.Tables[0].Rows[0]["MorePropertys"].ToString() != "")
{
model.MorePropertys = ds.Tables[0].Rows[0]["MorePropertys"].ToString();
}
if (ds.Tables[0].Rows[0]["IfSh"] != null && ds.Tables[0].Rows[0]["IfSh"].ToString() != "")
{
model.IfSh = int.Parse(ds.Tables[0].Rows[0]["IfSh"].ToString());
}
if (ds.Tables[0].Rows[0]["ShPerson"] != null && ds.Tables[0].Rows[0]["ShPerson"].ToString() != "")
{
model.ShPerson = ds.Tables[0].Rows[0]["ShPerson"].ToString();
}
if (ds.Tables[0].Rows[0]["ShTime"] != null && ds.Tables[0].Rows[0]["ShTime"].ToString() != "")
{
model.ShTime = DateTime.Parse(ds.Tables[0].Rows[0]["ShTime"].ToString());
}
if (ds.Tables[0].Rows[0]["ShMark"] != null && ds.Tables[0].Rows[0]["ShMark"].ToString() != "")
{
model.ShMark = ds.Tables[0].Rows[0]["ShMark"].ToString();
}
if (ds.Tables[0].Rows[0]["IsOldGoods"] != null && ds.Tables[0].Rows[0]["IsOldGoods"].ToString() != "")
{
model.IsOldGoods = int.Parse(ds.Tables[0].Rows[0]["IsOldGoods"].ToString());
}
if (ds.Tables[0].Rows[0]["OldGoodsLevel"] != null && ds.Tables[0].Rows[0]["OldGoodsLevel"].ToString() != "")
{
model.OldGoodsLevel = ds.Tables[0].Rows[0]["OldGoodsLevel"].ToString();
}
if (ds.Tables[0].Rows[0]["saleCount"] != null && ds.Tables[0].Rows[0]["saleCount"].ToString() != "")
{
model.saleCount = int.Parse(ds.Tables[0].Rows[0]["saleCount"].ToString());
}
if (ds.Tables[0].Rows[0]["Postage"] != null && ds.Tables[0].Rows[0]["Postage"].ToString() != "")
{
model.Postage = decimal.Parse(ds.Tables[0].Rows[0]["Postage"].ToString());
}
if (ds.Tables[0].Rows[0]["PingLunCount"] != null && ds.Tables[0].Rows[0]["PingLunCount"].ToString() != "")
{
model.PingLunCount = int.Parse(ds.Tables[0].Rows[0]["PingLunCount"].ToString());
}
if (ds.Tables[0].Rows[0]["vipPrice1"] != null && ds.Tables[0].Rows[0]["vipPrice1"].ToString() != "")
{
model.vipPrice1 = decimal.Parse(ds.Tables[0].Rows[0]["vipPrice1"].ToString());
}
if (ds.Tables[0].Rows[0]["vipPrice2"] != null && ds.Tables[0].Rows[0]["vipPrice2"].ToString() != "")
{
model.vipPrice2 = decimal.Parse(ds.Tables[0].Rows[0]["vipPrice2"].ToString());
}
if (ds.Tables[0].Rows[0]["signId"] != null && ds.Tables[0].Rows[0]["signId"].ToString() != "")
{
model.signId = ds.Tables[0].Rows[0]["signId"].ToString();
}
if (ds.Tables[0].Rows[0]["serviceId"] != null && ds.Tables[0].Rows[0]["serviceId"].ToString() != "")
{
model.ServiceId = ds.Tables[0].Rows[0]["serviceId"].ToString();
}
if (ds.Tables[0].Rows[0]["JobType"] != null)
{
model.JobType = ds.Tables[0].Rows[0]["JobType"].ToString();
}
if (ds.Tables[0].Rows[0]["JobStartTime"] != null && ds.Tables[0].Rows[0]["JobStartTime"].ToString() != "")
{
model.JobStartTime = DateTime.Parse(ds.Tables[0].Rows[0]["JobStartTime"].ToString());
}
if (ds.Tables[0].Rows[0]["JobEndTime"] != null && ds.Tables[0].Rows[0]["JobEndTime"].ToString() != "")
{
model.JobEndTime = DateTime.Parse(ds.Tables[0].Rows[0]["JobEndTime"].ToString());
}
if (ds.Tables[0].Rows[0]["JobAddress"] != null)
{
model.JobAddress = ds.Tables[0].Rows[0]["JobAddress"].ToString();
}
if (ds.Tables[0].Rows[0]["JobSquare"] != null)
{
model.JobSquare = ds.Tables[0].Rows[0]["JobSquare"].ToString();
}
if (ds.Tables[0].Rows[0]["JobByPersonType"] != null)
{
model.JobByPersonType = ds.Tables[0].Rows[0]["JobByPersonType"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(GoodsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Goods_Info(");
strSql.Append("GoodsId,CategoryId,GoodsToTypeId,BrandId,GoodsName,GoodsCode,Uint,Weight,GoodsSmallPic,GoodsSampleDesc,GoodsDesc,GoodsDesc2,GoodsDesc3,GoodsDesc4,GoodsDesc5,IsRec,IsHot,IsNew,IsSpe,SalePrice,MarketPrice,CBPrice,IsSale,Sotck,MinSaleNumber,MaxSaleNumber,Orderby,ViewCount,TotalSaleCount,Remarks,AddTime,AreaInfo,BookInfo,ProviderInfo,DataFrom,MorePropertys,IfSh,ShPerson,ShTime,ShMark,IsOldGoods,OldGoodsLevel,saleCount,Postage,PingLunCount,vipPrice1,vipPrice2,signId,serviceId,JobType,JobStartTime,JobEndTime,JobAddress,JobSquare,JobByPersonType)");
strSql.Append(" values (");
strSql.Append("@GoodsId,@CategoryId,@GoodsToTypeId,@BrandId,@GoodsName,@GoodsCode,@Uint,@Weight,@GoodsSmallPic,@GoodsSampleDesc,@GoodsDesc,@GoodsDesc2,@GoodsDesc3,@GoodsDesc4,@GoodsDesc5,@IsRec,@IsHot,@IsNew,@IsSpe,@SalePrice,@MarketPrice,@CBPrice,@IsSale,@Sotck,@MinSaleNumber,@MaxSaleNumber,@Orderby,@ViewCount,@TotalSaleCount,@Remarks,@AddTime,@AreaInfo,@BookInfo,@ProviderInfo,@DataFrom,@MorePropertys,@IfSh,@ShPerson,@ShTime,@ShMark,@IsOldGoods,@OldGoodsLevel,@saleCount,@Postage,@PingLunCount,@vipPrice1,@vipPrice2,@signId,@serviceId,@JobType,@JobStartTime,@JobEndTime,@JobAddress,@JobSquare,@JobByPersonType)");
SqlParameter[] parameters =
{
new SqlParameter("@GoodsId", SqlDbType.VarChar, 50),
new SqlParameter("@CategoryId", SqlDbType.VarChar, 50),
new SqlParameter("@GoodsToTypeId", SqlDbType.VarChar, 50),
new SqlParameter("@BrandId", SqlDbType.VarChar, 50),
new SqlParameter("@GoodsName", SqlDbType.VarChar, 200),
new SqlParameter("@GoodsCode", SqlDbType.VarChar, 50),
new SqlParameter("@Uint", SqlDbType.VarChar, 50),
new SqlParameter("@Weight", SqlDbType.Int, 4),
new SqlParameter("@GoodsSmallPic", SqlDbType.VarChar, 500),
new SqlParameter("@GoodsSampleDesc", SqlDbType.VarChar, 500),
new SqlParameter("@GoodsDesc", SqlDbType.Text),
new SqlParameter("@GoodsDesc2", SqlDbType.Text),
new SqlParameter("@GoodsDesc3", SqlDbType.Text),
new SqlParameter("@GoodsDesc4", SqlDbType.Text),
new SqlParameter("@GoodsDesc5", SqlDbType.Text),
new SqlParameter("@IsRec", SqlDbType.Int, 4),
new SqlParameter("@IsHot", SqlDbType.Int, 4),
new SqlParameter("@IsNew", SqlDbType.Int, 4),
new SqlParameter("@IsSpe", SqlDbType.Int, 4),
new SqlParameter("@SalePrice", SqlDbType.Decimal, 9),
new SqlParameter("@MarketPrice", SqlDbType.Decimal, 9),
new SqlParameter("@CBPrice", SqlDbType.Decimal, 9),
new SqlParameter("@IsSale", SqlDbType.Int, 4),
new SqlParameter("@Sotck", SqlDbType.Int, 4),
new SqlParameter("@MinSaleNumber", SqlDbType.Int, 4),
new SqlParameter("@MaxSaleNumber", SqlDbType.Int, 4),
new SqlParameter("@Orderby", SqlDbType.Int, 4),
new SqlParameter("@ViewCount", SqlDbType.Int, 4),
new SqlParameter("@TotalSaleCount", SqlDbType.Int, 4),
new SqlParameter("@Remarks", SqlDbType.VarChar, 500),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@AreaInfo", SqlDbType.VarChar, 500),
new SqlParameter("@BookInfo", SqlDbType.VarChar, 500),
new SqlParameter("@ProviderInfo", SqlDbType.VarChar, 500),
new SqlParameter("@DataFrom", SqlDbType.VarChar, 50),
new SqlParameter("@MorePropertys", SqlDbType.VarChar, 4000),
new SqlParameter("@IfSh", SqlDbType.Int, 4),
new SqlParameter("@ShPerson", SqlDbType.VarChar, 50),
new SqlParameter("@ShTime", SqlDbType.DateTime),
new SqlParameter("@ShMark", SqlDbType.VarChar, 500),
new SqlParameter("@IsOldGoods", SqlDbType.Int, 4),
new SqlParameter("@OldGoodsLevel", SqlDbType.VarChar, 50),
new SqlParameter("@saleCount", SqlDbType.Int, 4),
new SqlParameter("@Postage", SqlDbType.Decimal, 9),
new SqlParameter("@PingLunCount", SqlDbType.Int, 4),
new SqlParameter("@vipPrice1", SqlDbType.Decimal, 9),
new SqlParameter("@vipPrice2", SqlDbType.Decimal, 9),
new SqlParameter("@signId", SqlDbType.VarChar, 1000),
new SqlParameter("@serviceId", SqlDbType.VarChar, 500),
new SqlParameter("@JobType", SqlDbType.VarChar, 500),
new SqlParameter("@JobStartTime", SqlDbType.DateTime),
new SqlParameter("@JobEndTime", SqlDbType.DateTime),
new SqlParameter("@JobAddress", SqlDbType.VarChar, 2000),
new SqlParameter("@JobSquare", SqlDbType.VarChar, 500),
new SqlParameter("@JobByPersonType", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.GoodsId;
parameters[1].Value = model.CategoryId;
parameters[2].Value = model.GoodsToTypeId;
parameters[3].Value = model.BrandId;
parameters[4].Value = model.GoodsName;
parameters[5].Value = model.GoodsCode;
parameters[6].Value = model.Uint;
parameters[7].Value = model.Weight;
parameters[8].Value = model.GoodsSmallPic;
parameters[9].Value = model.GoodsSampleDesc;
parameters[10].Value = model.GoodsDesc;
parameters[11].Value = model.GoodsDesc2;
parameters[12].Value = model.GoodsDesc3;
parameters[13].Value = model.GoodsDesc4;
parameters[14].Value = model.GoodsDesc5;
parameters[15].Value = model.IsRec;
parameters[16].Value = model.IsHot;
parameters[17].Value = model.IsNew;
parameters[18].Value = model.IsSpe;
parameters[19].Value = model.SalePrice;
parameters[20].Value = model.MarketPrice;
parameters[21].Value = model.CBPrice;
parameters[22].Value = model.IsSale;
parameters[23].Value = model.Sotck;
parameters[24].Value = model.MinSaleNumber;
parameters[25].Value = model.MaxSaleNumber;
parameters[26].Value = model.Orderby;
parameters[27].Value = model.ViewCount;
parameters[28].Value = model.TotalSaleCount;
parameters[29].Value = model.Remarks;
parameters[30].Value = model.AddTime;
parameters[31].Value = model.AreaInfo;
parameters[32].Value = model.BookInfo;
parameters[33].Value = model.ProviderInfo;
parameters[34].Value = model.DataFrom;
parameters[35].Value = model.MorePropertys;
parameters[36].Value = model.IfSh;
parameters[37].Value = model.ShPerson;
parameters[38].Value = model.ShTime;
parameters[39].Value = model.ShMark;
parameters[40].Value = model.IsOldGoods;
parameters[41].Value = model.OldGoodsLevel;
parameters[42].Value = model.saleCount;
parameters[43].Value = model.Postage;
parameters[44].Value = model.PingLunCount;
parameters[45].Value = model.vipPrice1;
parameters[46].Value = model.vipPrice2;
parameters[47].Value = model.signId;
parameters[48].Value = model.serviceId;
parameters[49].Value = model.JobType;
parameters[50].Value = model.JobStartTime;
parameters[51].Value = model.JobEndTime;
parameters[52].Value = model.JobAddress;
parameters[53].Value = model.JobSquare;
parameters[54].Value = model.JobByPersonType;
return(adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(GoodsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Goods_Info set ");
strSql.Append("CategoryId=@CategoryId,");
strSql.Append("GoodsToTypeId=@GoodsToTypeId,");
strSql.Append("BrandId=@BrandId,");
strSql.Append("GoodsName=@GoodsName,");
strSql.Append("GoodsCode=@GoodsCode,");
strSql.Append("Uint=@Uint,");
strSql.Append("Weight=@Weight,");
strSql.Append("GoodsSmallPic=@GoodsSmallPic,");
strSql.Append("GoodsSampleDesc=@GoodsSampleDesc,");
strSql.Append("GoodsDesc=@GoodsDesc,");
strSql.Append("GoodsDesc2=@GoodsDesc2,");
strSql.Append("GoodsDesc3=@GoodsDesc3,");
strSql.Append("GoodsDesc4=@GoodsDesc4,");
strSql.Append("GoodsDesc5=@GoodsDesc5,");
strSql.Append("IsRec=@IsRec,");
strSql.Append("IsHot=@IsHot,");
strSql.Append("IsNew=@IsNew,");
strSql.Append("IsSpe=@IsSpe,");
strSql.Append("SalePrice=@SalePrice,");
strSql.Append("MarketPrice=@MarketPrice,");
strSql.Append("CBPrice=@CBPrice,");
strSql.Append("IsSale=@IsSale,");
strSql.Append("Sotck=@Sotck,");
strSql.Append("MinSaleNumber=@MinSaleNumber,");
strSql.Append("MaxSaleNumber=@MaxSaleNumber,");
strSql.Append("Orderby=@Orderby,");
strSql.Append("ViewCount=@ViewCount,");
strSql.Append("TotalSaleCount=@TotalSaleCount,");
strSql.Append("Remarks=@Remarks,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("AreaInfo=@AreaInfo,");
strSql.Append("BookInfo=@BookInfo,");
strSql.Append("ProviderInfo=@ProviderInfo,");
strSql.Append("DataFrom=@DataFrom,");
strSql.Append("MorePropertys=@MorePropertys,");
strSql.Append("IfSh=@IfSh,");
strSql.Append("ShPerson=@ShPerson,");
strSql.Append("ShTime=@ShTime,");
strSql.Append("ShMark=@ShMark,");
strSql.Append("IsOldGoods=@IsOldGoods,");
strSql.Append("OldGoodsLevel=@OldGoodsLevel,");
strSql.Append("saleCount=@saleCount,");
strSql.Append("Postage=@Postage,");
strSql.Append("PingLunCount=@PingLunCount,");
strSql.Append("vipPrice1=@vipPrice1,");
strSql.Append("vipPrice2=@vipPrice2,");
strSql.Append("signId=@signId,");
strSql.Append("serviceId=@serviceId,");
strSql.Append("JobType=@JobType,");
strSql.Append("JobStartTime=@JobStartTime,");
strSql.Append("JobEndTime=@JobEndTime,");
strSql.Append("JobAddress=@JobAddress,");
strSql.Append("JobSquare=@JobSquare,");
strSql.Append("JobByPersonType=@JobByPersonType");
strSql.Append(" where GoodsId=@GoodsId ");
SqlParameter[] parameters =
{
new SqlParameter("@CategoryId", SqlDbType.VarChar, 50),
new SqlParameter("@GoodsToTypeId", SqlDbType.VarChar, 50),
new SqlParameter("@BrandId", SqlDbType.VarChar, 50),
new SqlParameter("@GoodsName", SqlDbType.VarChar, 200),
new SqlParameter("@GoodsCode", SqlDbType.VarChar, 50),
new SqlParameter("@Uint", SqlDbType.VarChar, 50),
new SqlParameter("@Weight", SqlDbType.Int, 4),
new SqlParameter("@GoodsSmallPic", SqlDbType.VarChar, 500),
new SqlParameter("@GoodsSampleDesc", SqlDbType.VarChar, 500),
new SqlParameter("@GoodsDesc", SqlDbType.Text),
new SqlParameter("@GoodsDesc2", SqlDbType.Text),
new SqlParameter("@GoodsDesc3", SqlDbType.Text),
new SqlParameter("@GoodsDesc4", SqlDbType.Text),
new SqlParameter("@GoodsDesc5", SqlDbType.Text),
new SqlParameter("@IsRec", SqlDbType.Int, 4),
new SqlParameter("@IsHot", SqlDbType.Int, 4),
new SqlParameter("@IsNew", SqlDbType.Int, 4),
new SqlParameter("@IsSpe", SqlDbType.Int, 4),
new SqlParameter("@SalePrice", SqlDbType.Decimal, 9),
new SqlParameter("@MarketPrice", SqlDbType.Decimal, 9),
new SqlParameter("@CBPrice", SqlDbType.Decimal, 9),
new SqlParameter("@IsSale", SqlDbType.Int, 4),
new SqlParameter("@Sotck", SqlDbType.Int, 4),
new SqlParameter("@MinSaleNumber", SqlDbType.Int, 4),
new SqlParameter("@MaxSaleNumber", SqlDbType.Int, 4),
new SqlParameter("@Orderby", SqlDbType.Int, 4),
new SqlParameter("@ViewCount", SqlDbType.Int, 4),
new SqlParameter("@TotalSaleCount", SqlDbType.Int, 4),
new SqlParameter("@Remarks", SqlDbType.VarChar, 500),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@AreaInfo", SqlDbType.VarChar, 500),
new SqlParameter("@BookInfo", SqlDbType.VarChar, 500),
new SqlParameter("@ProviderInfo", SqlDbType.VarChar, 500),
new SqlParameter("@DataFrom", SqlDbType.VarChar, 50),
new SqlParameter("@MorePropertys", SqlDbType.VarChar, 4000),
new SqlParameter("@IfSh", SqlDbType.Int, 4),
new SqlParameter("@ShPerson", SqlDbType.VarChar, 50),
new SqlParameter("@ShTime", SqlDbType.DateTime),
new SqlParameter("@ShMark", SqlDbType.VarChar, 500),
new SqlParameter("@IsOldGoods", SqlDbType.Int, 4),
new SqlParameter("@OldGoodsLevel", SqlDbType.VarChar, 50),
new SqlParameter("@saleCount", SqlDbType.Int, 4),
new SqlParameter("@Postage", SqlDbType.Decimal, 9),
new SqlParameter("@PingLunCount", SqlDbType.Int, 4),
new SqlParameter("@vipPrice1", SqlDbType.Decimal, 9),
new SqlParameter("@vipPrice2", SqlDbType.Decimal, 9),
new SqlParameter("@signId", SqlDbType.VarChar, 1000),
new SqlParameter("@serviceId", SqlDbType.VarChar, 500),
new SqlParameter("@JobType", SqlDbType.VarChar, 500),
new SqlParameter("@JobStartTime", SqlDbType.DateTime),
new SqlParameter("@JobEndTime", SqlDbType.DateTime),
new SqlParameter("@JobAddress", SqlDbType.VarChar, 2000),
new SqlParameter("@JobSquare", SqlDbType.VarChar, 500),
new SqlParameter("@JobByPersonType", SqlDbType.VarChar, 500),
new SqlParameter("@GoodsId", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.CategoryId;
parameters[1].Value = model.GoodsToTypeId;
parameters[2].Value = model.BrandId;
parameters[3].Value = model.GoodsName;
parameters[4].Value = model.GoodsCode;
parameters[5].Value = model.Uint;
parameters[6].Value = model.Weight;
parameters[7].Value = model.GoodsSmallPic;
parameters[8].Value = model.GoodsSampleDesc;
parameters[9].Value = model.GoodsDesc;
parameters[10].Value = model.GoodsDesc2;
parameters[11].Value = model.GoodsDesc3;
parameters[12].Value = model.GoodsDesc4;
parameters[13].Value = model.GoodsDesc5;
parameters[14].Value = model.IsRec;
parameters[15].Value = model.IsHot;
parameters[16].Value = model.IsNew;
parameters[17].Value = model.IsSpe;
parameters[18].Value = model.SalePrice;
parameters[19].Value = model.MarketPrice;
parameters[20].Value = model.CBPrice;
parameters[21].Value = model.IsSale;
parameters[22].Value = model.Sotck;
parameters[23].Value = model.MinSaleNumber;
parameters[24].Value = model.MaxSaleNumber;
parameters[25].Value = model.Orderby;
parameters[26].Value = model.ViewCount;
parameters[27].Value = model.TotalSaleCount;
parameters[28].Value = model.Remarks;
parameters[29].Value = model.AddTime;
parameters[30].Value = model.AreaInfo;
parameters[31].Value = model.BookInfo;
parameters[32].Value = model.ProviderInfo;
parameters[33].Value = model.DataFrom;
parameters[34].Value = model.MorePropertys;
parameters[35].Value = model.IfSh;
parameters[36].Value = model.ShPerson;
parameters[37].Value = model.ShTime;
parameters[38].Value = model.ShMark;
parameters[39].Value = model.IsOldGoods;
parameters[40].Value = model.OldGoodsLevel;
parameters[41].Value = model.saleCount;
parameters[42].Value = model.Postage;
parameters[43].Value = model.PingLunCount;
parameters[44].Value = model.vipPrice1;
parameters[45].Value = model.vipPrice2;
parameters[46].Value = model.signId;
parameters[47].Value = model.serviceId;
parameters[48].Value = model.JobType;
parameters[49].Value = model.JobStartTime;
parameters[50].Value = model.JobEndTime;
parameters[51].Value = model.JobAddress;
parameters[52].Value = model.JobSquare;
parameters[53].Value = model.JobByPersonType;
parameters[54].Value = model.GoodsId;
int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <GoodsModel> DataTableToList(DataTable dt)
{
List <GoodsModel> modelList = new List <GoodsModel>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
GoodsModel model;
for (int n = 0; n < rowsCount; n++)
{
model = new GoodsModel();
if (dt.Rows[n]["GoodsId"] != null && dt.Rows[n]["GoodsId"].ToString() != "")
{
model.GoodsId = dt.Rows[n]["GoodsId"].ToString();
}
if (dt.Rows[n]["CategoryId"] != null && dt.Rows[n]["CategoryId"].ToString() != "")
{
model.CategoryId = dt.Rows[n]["CategoryId"].ToString();
}
if (dt.Rows[n]["GoodsToTypeId"] != null && dt.Rows[n]["GoodsToTypeId"].ToString() != "")
{
model.GoodsToTypeId = dt.Rows[n]["GoodsToTypeId"].ToString();
}
if (dt.Rows[n]["BrandId"] != null && dt.Rows[n]["BrandId"].ToString() != "")
{
model.BrandId = dt.Rows[n]["BrandId"].ToString();
}
if (dt.Rows[n]["GoodsName"] != null && dt.Rows[n]["GoodsName"].ToString() != "")
{
model.GoodsName = dt.Rows[n]["GoodsName"].ToString();
}
if (dt.Rows[n]["GoodsCode"] != null && dt.Rows[n]["GoodsCode"].ToString() != "")
{
model.GoodsCode = dt.Rows[n]["GoodsCode"].ToString();
}
if (dt.Rows[n]["Uint"] != null && dt.Rows[n]["Uint"].ToString() != "")
{
model.Uint = dt.Rows[n]["Uint"].ToString();
}
if (dt.Rows[n]["Weight"] != null && dt.Rows[n]["Weight"].ToString() != "")
{
model.Weight = int.Parse(dt.Rows[n]["Weight"].ToString());
}
if (dt.Rows[n]["GoodsSmallPic"] != null && dt.Rows[n]["GoodsSmallPic"].ToString() != "")
{
model.GoodsSmallPic = dt.Rows[n]["GoodsSmallPic"].ToString();
}
if (dt.Rows[n]["GoodsSampleDesc"] != null && dt.Rows[n]["GoodsSampleDesc"].ToString() != "")
{
model.GoodsSampleDesc = dt.Rows[n]["GoodsSampleDesc"].ToString();
}
if (dt.Rows[n]["GoodsDesc"] != null && dt.Rows[n]["GoodsDesc"].ToString() != "")
{
model.GoodsDesc = dt.Rows[n]["GoodsDesc"].ToString();
}
if (dt.Rows[n]["GoodsDesc2"] != null && dt.Rows[n]["GoodsDesc2"].ToString() != "")
{
model.GoodsDesc2 = dt.Rows[n]["GoodsDesc2"].ToString();
}
if (dt.Rows[n]["GoodsDesc3"] != null && dt.Rows[n]["GoodsDesc3"].ToString() != "")
{
model.GoodsDesc3 = dt.Rows[n]["GoodsDesc3"].ToString();
}
if (dt.Rows[n]["GoodsDesc4"] != null && dt.Rows[n]["GoodsDesc4"].ToString() != "")
{
model.GoodsDesc4 = dt.Rows[n]["GoodsDesc4"].ToString();
}
if (dt.Rows[n]["GoodsDesc5"] != null && dt.Rows[n]["GoodsDesc5"].ToString() != "")
{
model.GoodsDesc5 = dt.Rows[n]["GoodsDesc5"].ToString();
}
if (dt.Rows[n]["IsRec"] != null && dt.Rows[n]["IsRec"].ToString() != "")
{
model.IsRec = int.Parse(dt.Rows[n]["IsRec"].ToString());
}
if (dt.Rows[n]["IsHot"] != null && dt.Rows[n]["IsHot"].ToString() != "")
{
model.IsHot = int.Parse(dt.Rows[n]["IsHot"].ToString());
}
if (dt.Rows[n]["IsNew"] != null && dt.Rows[n]["IsNew"].ToString() != "")
{
model.IsNew = int.Parse(dt.Rows[n]["IsNew"].ToString());
}
if (dt.Rows[n]["IsSpe"] != null && dt.Rows[n]["IsSpe"].ToString() != "")
{
model.IsSpe = int.Parse(dt.Rows[n]["IsSpe"].ToString());
}
if (dt.Rows[n]["SalePrice"] != null && dt.Rows[n]["SalePrice"].ToString() != "")
{
model.SalePrice = decimal.Parse(dt.Rows[n]["SalePrice"].ToString());
}
if (dt.Rows[n]["MarketPrice"] != null && dt.Rows[n]["MarketPrice"].ToString() != "")
{
model.MarketPrice = decimal.Parse(dt.Rows[n]["MarketPrice"].ToString());
}
if (dt.Rows[n]["CBPrice"] != null && dt.Rows[n]["CBPrice"].ToString() != "")
{
model.CBPrice = decimal.Parse(dt.Rows[n]["CBPrice"].ToString());
}
if (dt.Rows[n]["IsSale"] != null && dt.Rows[n]["IsSale"].ToString() != "")
{
model.IsSale = int.Parse(dt.Rows[n]["IsSale"].ToString());
}
if (dt.Rows[n]["Sotck"] != null && dt.Rows[n]["Sotck"].ToString() != "")
{
model.Sotck = int.Parse(dt.Rows[n]["Sotck"].ToString());
}
if (dt.Rows[n]["MinSaleNumber"] != null && dt.Rows[n]["MinSaleNumber"].ToString() != "")
{
model.MinSaleNumber = int.Parse(dt.Rows[n]["MinSaleNumber"].ToString());
}
if (dt.Rows[n]["MaxSaleNumber"] != null && dt.Rows[n]["MaxSaleNumber"].ToString() != "")
{
model.MaxSaleNumber = int.Parse(dt.Rows[n]["MaxSaleNumber"].ToString());
}
if (dt.Rows[n]["Orderby"] != null && dt.Rows[n]["Orderby"].ToString() != "")
{
model.Orderby = int.Parse(dt.Rows[n]["Orderby"].ToString());
}
if (dt.Rows[n]["ViewCount"] != null && dt.Rows[n]["ViewCount"].ToString() != "")
{
model.ViewCount = int.Parse(dt.Rows[n]["ViewCount"].ToString());
}
if (dt.Rows[n]["TotalSaleCount"] != null && dt.Rows[n]["TotalSaleCount"].ToString() != "")
{
model.TotalSaleCount = int.Parse(dt.Rows[n]["TotalSaleCount"].ToString());
}
if (dt.Rows[n]["Remarks"] != null && dt.Rows[n]["Remarks"].ToString() != "")
{
model.Remarks = dt.Rows[n]["Remarks"].ToString();
}
if (dt.Rows[n]["AddTime"] != null && dt.Rows[n]["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(dt.Rows[n]["AddTime"].ToString());
}
if (dt.Rows[n]["AreaInfo"] != null && dt.Rows[n]["AreaInfo"].ToString() != "")
{
model.AreaInfo = dt.Rows[n]["AreaInfo"].ToString();
}
if (dt.Rows[n]["BookInfo"] != null && dt.Rows[n]["BookInfo"].ToString() != "")
{
model.BookInfo = dt.Rows[n]["BookInfo"].ToString();
}
if (dt.Rows[n]["ProviderInfo"] != null && dt.Rows[n]["ProviderInfo"].ToString() != "")
{
model.ProviderInfo = dt.Rows[n]["ProviderInfo"].ToString();
}
if (dt.Rows[n]["DataFrom"] != null && dt.Rows[n]["DataFrom"].ToString() != "")
{
model.DataFrom = dt.Rows[n]["DataFrom"].ToString();
}
if (dt.Rows[n]["MorePropertys"] != null && dt.Rows[n]["MorePropertys"].ToString() != "")
{
model.MorePropertys = dt.Rows[n]["MorePropertys"].ToString();
}
if (dt.Rows[n]["IfSh"] != null && dt.Rows[n]["IfSh"].ToString() != "")
{
model.IfSh = int.Parse(dt.Rows[n]["IfSh"].ToString());
}
if (dt.Rows[n]["ShPerson"] != null && dt.Rows[n]["ShPerson"].ToString() != "")
{
model.ShPerson = dt.Rows[n]["ShPerson"].ToString();
}
if (dt.Rows[n]["ShTime"] != null && dt.Rows[n]["ShTime"].ToString() != "")
{
model.ShTime = DateTime.Parse(dt.Rows[n]["ShTime"].ToString());
}
if (dt.Rows[n]["ShMark"] != null && dt.Rows[n]["ShMark"].ToString() != "")
{
model.ShMark = dt.Rows[n]["ShMark"].ToString();
}
if (dt.Rows[n]["IsOldGoods"] != null && dt.Rows[n]["IsOldGoods"].ToString() != "")
{
model.IsOldGoods = int.Parse(dt.Rows[n]["IsOldGoods"].ToString());
}
if (dt.Rows[n]["OldGoodsLevel"] != null && dt.Rows[n]["OldGoodsLevel"].ToString() != "")
{
model.OldGoodsLevel = dt.Rows[n]["OldGoodsLevel"].ToString();
}
if (dt.Rows[n]["saleCount"] != null && dt.Rows[n]["saleCount"].ToString() != "")
{
model.saleCount = int.Parse(dt.Rows[n]["saleCount"].ToString());
}
if (dt.Rows[n]["Postage"] != null && dt.Rows[n]["Postage"].ToString() != "")
{
model.Postage = decimal.Parse(dt.Rows[n]["Postage"].ToString());
}
if (dt.Rows[n]["PingLunCount"] != null && dt.Rows[n]["PingLunCount"].ToString() != "")
{
model.PingLunCount = int.Parse(dt.Rows[n]["PingLunCount"].ToString());
}
if (dt.Rows[n]["vipPrice1"] != null && dt.Rows[n]["vipPrice1"].ToString() != "")
{
model.vipPrice1 = decimal.Parse(dt.Rows[n]["vipPrice1"].ToString());
}
if (dt.Rows[n]["vipPrice2"] != null && dt.Rows[n]["vipPrice2"].ToString() != "")
{
model.vipPrice2 = decimal.Parse(dt.Rows[n]["vipPrice2"].ToString());
}
if (dt.Rows[n]["signId"] != null && dt.Rows[n]["signId"].ToString() != "")
{
model.signId = dt.Rows[n]["signId"].ToString();
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(GoodsModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(GoodsModel model)
{
return(dal.Add(model));
}
