public bool UpdateSkus(Entity.Goods.Skus model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Skus set "); strSql.Append(" Properties = @Properties , "); strSql.Append(" PropertiesName = @PropertiesName , "); strSql.Append(" Quantity = @Quantity , "); strSql.Append(" SkuDeliveryTime = @SkuDeliveryTime , "); strSql.Append(" SkuId = @SkuId , "); strSql.Append(" SkuSpecId = @SkuSpecId , "); strSql.Append(" Status = @Status , "); strSql.Append(" WithHoldQuantity = @WithHoldQuantity , "); strSql.Append(" Barcode = @Barcode , "); strSql.Append(" ChangeProp = @ChangeProp , "); strSql.Append(" Created = @Created , "); strSql.Append(" Iid = @Iid , "); strSql.Append(" Modified = @Modified , "); strSql.Append(" NumIid = @NumIid , "); strSql.Append(" OuterId = @OuterId , "); strSql.Append(" Price = @Price , "); strSql.Append(" SPJC = @SPJC ,"); strSql.Append(" SPZL = @SPZL , "); strSql.Append(" CBJ = @CBJ "); strSql.Append(" where SkusID=@SkusID "); SqlParameter[] parameters = { new SqlParameter("@SkusID", SqlDbType.Int, 4), new SqlParameter("@Properties", SqlDbType.VarChar, 5000), new SqlParameter("@PropertiesName", SqlDbType.VarChar, 5000), new SqlParameter("@Quantity", SqlDbType.Int, 4), new SqlParameter("@SkuDeliveryTime", SqlDbType.VarChar, 500), new SqlParameter("@SkuId", SqlDbType.Int, 4), new SqlParameter("@SkuSpecId", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.VarChar, 50), new SqlParameter("@WithHoldQuantity", SqlDbType.Int, 4), new SqlParameter("@Barcode", SqlDbType.VarChar, 100), new SqlParameter("@ChangeProp", SqlDbType.VarChar, 5000), new SqlParameter("@Created", SqlDbType.VarChar, 100), new SqlParameter("@Iid", SqlDbType.VarChar, 100), new SqlParameter("@Modified", SqlDbType.VarChar, 100), new SqlParameter("@NumIid", SqlDbType.VarChar, 100), new SqlParameter("@OuterId", SqlDbType.VarChar, 100), new SqlParameter("@Price", SqlDbType.Decimal, 9), new SqlParameter("@SPZL", SqlDbType.VarChar, 100), new SqlParameter("@SPJC", SqlDbType.VarChar, 200), new SqlParameter("@CBJ", SqlDbType.Decimal, 13) }; parameters[0].Value = model.SkusId; parameters[1].Value = model.Properties; parameters[2].Value = model.PropertiesName; parameters[3].Value = model.Quantity; parameters[4].Value = model.SkuDeliveryTime; parameters[5].Value = model.SkuId; parameters[6].Value = model.SkuSpecId; parameters[7].Value = model.Status; parameters[8].Value = model.WithHoldQuantity; parameters[9].Value = model.Barcode; parameters[10].Value = model.ChangeProp; parameters[11].Value = model.Created; parameters[12].Value = model.Iid; parameters[13].Value = model.Modified; parameters[14].Value = model.NumIid; parameters[15].Value = model.OuterId; parameters[16].Value = model.Price; parameters[17].Value = model.SPZL; parameters[18].Value = model.SPJC; parameters[19].Value = model.CBJ; int Ares = DBHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (Ares > 0) { return(true); } else { return(false); } }
public bool AddSkus(Entity.Goods.Skus model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Skus("); strSql.Append("SkusID,Properties,PropertiesName,Quantity,SkuDeliveryTime,SkuId,SkuSpecId,Status,WithHoldQuantity,Barcode,ChangeProp,Created,Iid,Modified,NumIid,OuterId,Price,SPZL,SPJC,CBJ"); strSql.Append(") values ("); strSql.Append("@SkusID,@Properties,@PropertiesName,@Quantity,@SkuDeliveryTime,@SkuId,@SkuSpecId,@Status,@WithHoldQuantity,@Barcode,@ChangeProp,@Created,@Iid,@Modified,@NumIid,@OuterId,@Price,@SPZL,@SPJC,@CBJ"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@SkusID", SqlDbType.Int, 4), new SqlParameter("@Properties", SqlDbType.VarChar, 5000), new SqlParameter("@PropertiesName", SqlDbType.VarChar, 5000), new SqlParameter("@Quantity", SqlDbType.Int, 4), new SqlParameter("@SkuDeliveryTime", SqlDbType.VarChar, 500), new SqlParameter("@SkuId", SqlDbType.Int, 4), new SqlParameter("@SkuSpecId", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.VarChar, 50), new SqlParameter("@WithHoldQuantity", SqlDbType.Int, 4), new SqlParameter("@Barcode", SqlDbType.VarChar, 100), new SqlParameter("@ChangeProp", SqlDbType.VarChar, 5000), new SqlParameter("@Created", SqlDbType.VarChar, 100), new SqlParameter("@Iid", SqlDbType.VarChar, 100), new SqlParameter("@Modified", SqlDbType.VarChar, 100), new SqlParameter("@NumIid", SqlDbType.VarChar, 100), new SqlParameter("@OuterId", SqlDbType.VarChar, 100), new SqlParameter("@Price", SqlDbType.Decimal, 9), new SqlParameter("@SPJC", SqlDbType.VarChar, 200), new SqlParameter("@SPZL", SqlDbType.VarChar, 100), new SqlParameter("@CBJ", SqlDbType.Decimal, 13) }; parameters[0].Value = model.SkusId; parameters[1].Value = model.Properties; parameters[2].Value = model.PropertiesName; parameters[3].Value = model.Quantity; parameters[4].Value = model.SkuDeliveryTime; parameters[5].Value = model.SkuId; parameters[6].Value = model.SkuSpecId; parameters[7].Value = model.Status; parameters[8].Value = model.WithHoldQuantity; parameters[9].Value = model.Barcode; parameters[10].Value = model.ChangeProp; parameters[11].Value = model.Created; parameters[12].Value = model.Iid; parameters[13].Value = model.Modified; parameters[14].Value = model.NumIid; parameters[15].Value = model.OuterId; parameters[16].Value = model.Price; parameters[17].Value = model.SPJC; parameters[18].Value = model.SPZL; parameters[19].Value = model.CBJ; int Ares = DBHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (Ares > 0) { return(true); } else { return(false); } }