/// <summary> /// 增加一条数据 /// </summary> public int Add(TtNum1.Model.GoodSort model) { StringBuilder strSql=new StringBuilder(); StringBuilder strSql1=new StringBuilder(); StringBuilder strSql2=new StringBuilder(); if (model.Sort_name != null) { strSql1.Append("Sort_name,"); strSql2.Append("'"+model.Sort_name+"',"); } strSql.Append("insert into GoodSort("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TtNum1.Model.Orderinfo model) { StringBuilder strSql=new StringBuilder(); StringBuilder strSql1=new StringBuilder(); StringBuilder strSql2=new StringBuilder(); if (model.U_ID != null) { strSql1.Append("U_ID,"); strSql2.Append(""+model.U_ID+","); } if (model.Goods_ID != null) { strSql1.Append("Goods_ID,"); strSql2.Append(""+model.Goods_ID+","); } if (model.Goods_Name != null) { strSql1.Append("Goods_Name,"); strSql2.Append("'"+model.Goods_Name+"',"); } if (model.Goods_Num != null) { strSql1.Append("Goods_Num,"); strSql2.Append(""+model.Goods_Num+","); } if (model.Style != null) { strSql1.Append("Style,"); strSql2.Append("'" + model.Style + "',"); } if (model.Goods_Money != null) { strSql1.Append("Goods_Money,"); strSql2.Append(""+model.Goods_Money+","); } if (model.IN_group_buying != null) { strSql1.Append("IN_group_buying,"); strSql2.Append("" + model.IN_group_buying + ","); } strSql.Append("insert into Orderinfo("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TtNum1.Model.Comment model) { StringBuilder strSql=new StringBuilder(); StringBuilder strSql1=new StringBuilder(); StringBuilder strSql2=new StringBuilder(); if (model.User_name != null) { strSql1.Append("User_name,"); strSql2.Append("'"+model.User_name+"',"); } if (model.Message_time != null) { strSql1.Append("Message_time,"); strSql2.Append("'"+model.Message_time+"',"); } if (model.Message_con != null) { strSql1.Append("Message_con,"); strSql2.Append("'"+model.Message_con+"',"); } if (model.Message_score != null) { strSql1.Append("Message_score,"); strSql2.Append(""+model.Message_score+","); } if (model.Message_IDU != null) { strSql1.Append("Message_IDU,"); strSql2.Append(""+model.Message_IDU+","); } if (model.G_ID != null) { strSql1.Append("G_ID,"); strSql2.Append(""+model.G_ID+","); } strSql.Append("insert into Comment("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TtNum1.Model.Notice model) { StringBuilder strSql=new StringBuilder(); StringBuilder strSql1=new StringBuilder(); StringBuilder strSql2=new StringBuilder(); if (model.N_title != null) { strSql1.Append("N_title,"); strSql2.Append("'"+model.N_title+"',"); } if (model.U_ID != null) { strSql1.Append("U_ID,"); strSql2.Append(""+model.U_ID+","); } if (model.N_time != null) { strSql1.Append("N_time,"); strSql2.Append("'"+model.N_time+"',"); } if (model.N_intro != null) { strSql1.Append("N_intro,"); strSql2.Append("'"+model.N_intro+"',"); } if (model.N_text != null) { strSql1.Append("N_text,"); strSql2.Append("'"+model.N_text+"',"); } strSql.Append("insert into Notice("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TtNum1.Model.C_a model) { StringBuilder strSql=new StringBuilder(); StringBuilder strSql1=new StringBuilder(); StringBuilder strSql2=new StringBuilder(); if (model.Sub != null) { strSql1.Append("Sub,"); strSql2.Append("'"+model.Sub+"',"); } if (model.StartTime != null) { strSql1.Append("StartTime,"); strSql2.Append("'"+model.StartTime+"',"); } if (model.StopTime != null) { strSql1.Append("StopTime,"); strSql2.Append("'"+model.StopTime+"',"); } if (model.G_id != null) { strSql1.Append("G_id,"); strSql2.Append(""+model.G_id+","); } strSql.Append("insert into C_a("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TtNum1.Model.SPECIFICATION model) { StringBuilder strSql=new StringBuilder(); StringBuilder strSql1=new StringBuilder(); StringBuilder strSql2=new StringBuilder(); if (model.Img_1 != null) { strSql1.Append("Img_1,"); strSql2.Append("'"+model.Img_1+"',"); } if (model.Img_2 != null) { strSql1.Append("Img_2,"); strSql2.Append("'"+model.Img_2+"',"); } if (model.Img_3 != null) { strSql1.Append("Img_3,"); strSql2.Append("'"+model.Img_3+"',"); } if (model.G_id != null) { strSql1.Append("G_id,"); strSql2.Append(""+model.G_id+","); } strSql.Append("insert into SPECIFICATION("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TtNum1.Model.UserInfo model) { return dal.Add(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TtNum1.Model.GroupBuying model) { StringBuilder strSql=new StringBuilder(); StringBuilder strSql1=new StringBuilder(); StringBuilder strSql2=new StringBuilder(); if (model.GB_GoodsID != null) { strSql1.Append("GB_GoodsID,"); strSql2.Append(""+model.GB_GoodsID+","); } if (model.GB_GroupPrice != null) { strSql1.Append("GB_GroupPrice,"); strSql2.Append(""+model.GB_GroupPrice+","); } if (model.GB_OfferDate != null) { strSql1.Append("GB_OfferDate,"); strSql2.Append("'"+model.GB_OfferDate+"',"); } if (model.GB_StopDate != null) { strSql1.Append("GB_StopDate,"); strSql2.Append("'"+model.GB_StopDate+"',"); } if (model.GB_TotalNumber != null) { strSql1.Append("GB_TotalNumber,"); strSql2.Append(""+model.GB_TotalNumber+","); } if (model.GB_participantsNumber != null) { strSql1.Append("GB_participantsNumber,"); strSql2.Append(""+model.GB_participantsNumber+","); } if (model.GB_State != null) { strSql1.Append("GB_State,"); strSql2.Append("'"+model.GB_State+"',"); } if (model.GB_PictureUrl != null) { strSql1.Append("GB_PictureUrl,"); strSql2.Append("'"+model.GB_PictureUrl+"',"); } if (model.GB_Note != null) { strSql1.Append("GB_Note,"); strSql2.Append("'"+model.GB_Note+"',"); } strSql.Append("insert into GroupBuying("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TtNum1.Model.UserInfo model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TtNum1.Model.Comment model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Comment set "); if (model.User_name != null) { strSql.Append("User_name='"+model.User_name+"',"); } if (model.Message_time != null) { strSql.Append("Message_time='"+model.Message_time+"',"); } else { strSql.Append("Message_time= null ,"); } if (model.Message_con != null) { strSql.Append("Message_con='"+model.Message_con+"',"); } else { strSql.Append("Message_con= null ,"); } if (model.Message_score != null) { strSql.Append("Message_score="+model.Message_score+","); } else { strSql.Append("Message_score= null ,"); } if (model.Message_IDU != null) { strSql.Append("Message_IDU="+model.Message_IDU+","); } else { strSql.Append("Message_IDU= null ,"); } if (model.G_ID != null) { strSql.Append("G_ID="+model.G_ID+","); } else { strSql.Append("G_ID= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where Message_ID="+ model.Message_ID+""); int rowsAffected=DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TtNum1.Model.C_a model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TtNum1.Model.Order model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update [Order] set "); if (model.U_ID != null) { strSql.Append("U_ID="+model.U_ID+","); } if (model.User_Name != null) { strSql.Append("User_Name='"+model.User_Name+"',"); } if (model.Order_status != null) { strSql.Append("Order_status='"+model.Order_status+"',"); } if (model.Method != null) { strSql.Append("Method='"+model.Method+"',"); } if (model.Style != null) { strSql.Append("Style='"+model.Style+"',"); } if (model.Goods_Name != null) { strSql.Append("Goods_Name='" + model.Goods_Name + "',"); } if (model.Goods_ID != null) { strSql.Append("Goods_ID="+model.Goods_ID+","); } if (model.Goods_Num != null) { strSql.Append("Goods_Num="+model.Goods_Num+","); } if (model.Goods_Money != null) { strSql.Append("Goods_Money="+model.Goods_Money+","); } if (model.IN_group_buying != null) { strSql.Append("IN_group_buying=" + model.IN_group_buying + ","); } if (model.Money_Sum != null) { strSql.Append("Money_Sum="+model.Money_Sum+","); } if (model.Order_time != null) { strSql.Append("Order_time='" + model.Order_time + "',"); } if (model.address_id != null) { strSql.Append("address_id='" + model.address_id + "',"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where Order_ID="+ model.Order_ID+""); int rowsAffected=DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TtNum1.Model.SPECIFICATION model) { return dal.Update(model); }
public bool Update_1(TtNum1.Model.GoodsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SPECIFICATION set "); if (model.Img_1 != null) { strSql.Append("SPECIFICATION.Img_1='" + model.Img_1 + "',"); } if (model.Img_2 != null) { strSql.Append("SPECIFICATION.Img_2='" + model.Img_2 + "' ,"); } if (model.Img_3 != null) { strSql.Append("SPECIFICATION.Img_3='" + model.Img_3 + "' ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where SPECIFICATION.G_id=" + model.Goods_ID + ""); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
public bool Update_2(TtNum1.Model.GoodsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GroupBuying set "); if (model.Img_1 != null) { strSql.Append("GroupBuying.GB_GroupPrice='" + model.GB_GroupPrice + "',"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where GroupBuying.GB_GoodsID=" + model.Goods_ID + ""); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新团购商品状态 /// </summary> public bool UpdateGBgoodsStatus(TtNum1.Model.GoodsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GoodsInfo set "); if (model.IN_group_buying != null) { strSql.Append("IN_group_buying=" + model.IN_group_buying + ","); } if (model.GB_Status != null) { strSql.Append("GB_Status='" + model.GB_Status + "',"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where Goods_ID=" + model.Goods_ID + ""); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新库存 /// </summary> public bool Updatestock(TtNum1.Model.GoodsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GoodsInfo set "); if (model.Stock != null) { strSql.Append("Stock=" + model.Stock + ","); } if (model.Sales_volume != null) { strSql.Append("Sales_volume=" + model.Sales_volume + ","); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where Goods_ID=" + model.Goods_ID + ""); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
public bool Updategbgoods(TtNum1.Model.GoodsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GoodsInfo set "); if (model.In_store_price != null) { strSql.Append("In_store_price=" + model.In_store_price + ","); } if (model.StartTime != null) { strSql.Append("StartTime='" + model.StartTime + "',"); } if (model.FinishTime != null) { strSql.Append("FinishTime='" + model.FinishTime + "',"); } if (model.GroupPerNum != null) { strSql.Append("GroupPerNum='" + model.GroupPerNum + "',"); } if (model.IN_group_buying != null) { strSql.Append("IN_group_buying='" + model.IN_group_buying + "',"); } if (model.GB_Status != null) { strSql.Append("GB_Status='" + model.GB_Status + "',"); } if (model.NowPerNum != null) { strSql.Append("NowPerNum=" + model.NowPerNum + ","); } if (model.Uptime != null) { strSql.Append("Uptime='" + model.Uptime + "',"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where Goods_ID=" + model.Goods_ID + ""); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新团购商品人数 /// </summary> public bool UpdateGBgoods(TtNum1.Model.GoodsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GoodsInfo set "); if (model.NowPerNum != null) { strSql.Append("NowPerNum=" + model.NowPerNum + ","); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where Goods_ID=" + model.Goods_ID + ""); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TtNum1.Model.GoodsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GoodsInfo set "); if (model.Goods_name != null) { strSql.Append("Goods_name='" + model.Goods_name + "',"); } if (model.Market_price != null) { strSql.Append("Market_price=" + model.Market_price + ","); } if (model.Group_Buying_Price != null) { strSql.Append("Group_Buying_Price=" + model.Group_Buying_Price + ","); } if (model.In_store_price != null) { strSql.Append("In_store_price=" + model.In_store_price + ","); } if (model.Stock != null) { strSql.Append("Stock=" + model.Stock + ","); } if (model.Uptime != null) { strSql.Append("Uptime='" + model.Uptime + "',"); } if (model.Goods_pic != null) { strSql.Append("Goods_pic='" + model.Goods_pic + "',"); } if (model.Goods_info != null) { strSql.Append("Goods_info='" + model.Goods_info + "',"); } if (model.Good_Brand != null) { strSql.Append("Good_Brand='" + model.Good_Brand + "',"); } if (model.IN_group_buying != null) { strSql.Append("IN_group_buying=" + model.IN_group_buying + ","); } if (model.GroupPerNum != null) { strSql.Append("GroupPerNum=" + model.GroupPerNum + ","); } if (model.NowPerNum != null) { strSql.Append("NowPerNum=" + model.NowPerNum + ","); } if (model.StartTime != null) { strSql.Append("StartTime='" + model.StartTime + "',"); } if (model.FinishTime != null) { strSql.Append("FinishTime='" + model.FinishTime + "',"); } if (model.GB_Status != null) { strSql.Append("GB_Status='" + model.GB_Status + "',"); } if (model.GS2 != null) { strSql.Append("GS2='" + model.GS2 + "',"); } if (model.Sales_volume != null) { strSql.Append("Sales_volume=" + model.Sales_volume + ","); } if (model.GS_id != null) { strSql.Append("GS_id=" + model.GS_id + ","); } if (model.Message_ID != null) { strSql.Append("Message_ID=" + model.Message_ID + ","); } if (model.Color != null) { strSql.Append("Color='" + model.Color + "',"); } if (model.Size != null) { strSql.Append("Size='" + model.Size + "',"); } if (model.Qqp != null) { strSql.Append("Qqp='" + model.Qqp + "',"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where Goods_ID=" + model.Goods_ID + ""); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TtNum1.Model.ShopCar model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TtNum1.Model.C_a model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update C_a set "); if (model.Sub != null) { strSql.Append("Sub='"+model.Sub+"',"); } if (model.StartTime != null) { strSql.Append("StartTime='"+model.StartTime+"',"); } if (model.StopTime != null) { strSql.Append("StopTime='"+model.StopTime+"',"); } if (model.G_id != null) { strSql.Append("G_id="+model.G_id+","); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where C_a_id="+ model.C_a_id+""); int rowsAffected=DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
public bool Update1(TtNum1.Model.Notice model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Notice set "); if (model.N_title != null) { strSql.Append("N_title='" + model.N_title + "',"); } /* if (model.U_ID != null) { strSql.Append("U_ID="+model.U_ID+","); }*/ if (model.N_intro != null) { strSql.Append("N_intro='" + model.N_intro + "',"); } if (model.N_text != null) { strSql.Append("N_text='" + model.N_text + "',"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where N_ID=" + model.N_ID + ""); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { //return false; return true; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TtNum1.Model.GoodSort model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update GoodSort set "); if (model.Sort_name != null) { strSql.Append("Sort_name='"+model.Sort_name+"',"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where Sort_ID="+ model.Sort_ID+""); int rowsAffected=DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新团购订单状态 /// </summary> public bool updateGBOrderlist(TtNum1.Model.Order model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [Order] set "); if (model.Style != null) { strSql.Append("Style='" + model.Style + "',"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append("where U_ID in (select U_ID from Orderinfo where Orderinfo.Style='已付款')"); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TtNum1.Model.ShopCar model) { return dal.Add(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TtNum1.Model.SPECIFICATION model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TtNum1.Model.GroupBuying model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update GroupBuying set "); if (model.GB_GoodsID != null) { strSql.Append("GB_GoodsID="+model.GB_GoodsID+","); } if (model.GB_GroupPrice != null) { strSql.Append("GB_GroupPrice="+model.GB_GroupPrice+","); } if (model.GB_OfferDate != null) { strSql.Append("GB_OfferDate='"+model.GB_OfferDate+"',"); } if (model.GB_StopDate != null) { strSql.Append("GB_StopDate='"+model.GB_StopDate+"',"); } else { strSql.Append("GB_StopDate= null ,"); } if (model.GB_TotalNumber != null) { strSql.Append("GB_TotalNumber="+model.GB_TotalNumber+","); } if (model.GB_participantsNumber != null) { strSql.Append("GB_participantsNumber="+model.GB_participantsNumber+","); } if (model.GB_State != null) { strSql.Append("GB_State='"+model.GB_State+"',"); } if (model.GB_PictureUrl != null) { strSql.Append("GB_PictureUrl='"+model.GB_PictureUrl+"',"); } if (model.GB_Note != null) { strSql.Append("GB_Note='"+model.GB_Note+"',"); } else { strSql.Append("GB_Note= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where GB_ID="+ model.GB_ID+""); int rowsAffected=DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TtNum1.Model.GoodsInfo model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.Goods_name != null) { strSql1.Append("Goods_name,"); strSql2.Append("'" + model.Goods_name + "',"); } if (model.Market_price != null) { strSql1.Append("Market_price,"); strSql2.Append("" + model.Market_price + ","); } if (model.Group_Buying_Price != null) { strSql1.Append("Group_Buying_Price,"); strSql2.Append("" + model.Group_Buying_Price + ","); } if (model.In_store_price != null) { strSql1.Append("In_store_price,"); strSql2.Append("" + model.In_store_price + ","); } if (model.Stock != null) { strSql1.Append("Stock,"); strSql2.Append("" + model.Stock + ","); } if (model.Uptime != null) { strSql1.Append("Uptime,"); strSql2.Append("'" + model.Uptime + "',"); } if (model.Goods_pic != null) { strSql1.Append("Goods_pic,"); strSql2.Append("'" + model.Goods_pic + "',"); } if (model.Goods_info != null) { strSql1.Append("Goods_info,"); strSql2.Append("'" + model.Goods_info + "',"); } if (model.Good_Brand != null) { strSql1.Append("Good_Brand,"); strSql2.Append("'" + model.Good_Brand + "',"); } if (model.IN_group_buying != null) { strSql1.Append("IN_group_buying,"); strSql2.Append("" + model.IN_group_buying + ","); } if (model.GroupPerNum != null) { strSql1.Append("GroupPerNum,"); strSql2.Append("" + model.GroupPerNum + ","); } if (model.NowPerNum != null) { strSql1.Append("NowPerNum,"); strSql2.Append("" + model.NowPerNum + ","); } if (model.StartTime != null) { strSql1.Append("StartTime,"); strSql2.Append("" + model.StartTime + ","); } if (model.FinishTime != null) { strSql1.Append("FinishTime,"); strSql2.Append("" + model.FinishTime + ","); } if (model.GB_Status != null) { strSql1.Append("GB_Status,"); strSql2.Append("" + model.GB_Status + ","); } if (model.GS2 != null) { strSql1.Append("GS2,"); strSql2.Append("'" + model.GS2 + "',"); } if (model.Sales_volume != null) { strSql1.Append("Sales_volume,"); strSql2.Append("" + model.Sales_volume + ","); } if (model.GS_id != null) { strSql1.Append("GS_id,"); strSql2.Append("" + model.GS_id + ","); } if (model.Message_ID != null) { strSql1.Append("Message_ID,"); strSql2.Append("" + model.Message_ID + ","); } if (model.Color != null) { strSql1.Append("Color,"); strSql2.Append("'" + model.Color + "',"); } if (model.Size != null) { strSql1.Append("Size,"); strSql2.Append("'" + model.Size + "',"); } if (model.Qqp != null) { strSql1.Append("Qqp,"); strSql2.Append("'" + model.Qqp + "',"); } strSql.Append("insert into GoodsInfo("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TtNum1.Model.C_a model) { return dal.Update(model); }