/// <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);
}
