using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
namespace dd
{
public class orderList
{
/// 查询一个单元格[李正义]
/// ID
/// 字段
public static string cell(string id, string field) { return cc.db.Cell(mm.orderList.table, mm.orderList.field.id + " " + id, field); }
/// 查询一个数据行[李正义]
/// ID
/// 字段
public static DataTable row(string id, string fields) { return cc.db.Row(mm.orderList.table, mm.orderList.field.id + " " + id, fields); }
/// 删除商品[李正义]
/// 实体类
public static int delete(mm.orderList.entity ee)
{
string s = "delete from [0] where [1]=@[1] and [2]=@[2]";
string[] sa = new string[]
{
mm.orderList.table,
mm.orderList.field.buyerId+" "+ee.BuyerId,
mm.orderList.field.id+" "+ee.Id
};
return cc.db.Execute(s, sa);
}
/// 添加订单[李正义]
/// 实体类
public static int insert(mm.orderList.entity ee)
{
string s = "insert into [0] ([1],[2],[3]) values (@[1],@[2],@[3])";
string[] sa = new string[]
{
mm.orderList.table,
mm.orderList.field.sellerId+" "+ee.SellerId,
mm.orderList.field.tradeId+" "+ee.TradeId,
mm.orderList.field.count+" "+ee.Count
};
return cc.db.Execute(s, sa);
}
/// 更新订单[李正义]
/// ID
/// 数量
/// 订单表ID
public static int update(string id, string count, string orderId)
{
string s = "update [0] set [1]=@[1],[2]=@[2] where [3]=@[3]";
string[] sa = new string[]
{
mm.orderList.table,
mm.orderList.field.count+" "+count,
mm.orderList.field.orderId+" "+orderId,
mm.orderList.field.id+" "+id
};
return cc.db.Execute(s, sa);
}
}
}
#E:\Web\c-c\Web\ascx\baidu\da2v.ascx #E:\Web\c-c\Web\ascx\baidu\da21.ascx #E:\Web\c-c\Web\ascx\baidu\da22.ascx #E:\Web\c-c\Web\ascx\baidu\da2i.ascx #E:\Web\c-c\Web\ascx\baidu\da2s.ascx E:\Web\c-c\Web\ascx\Head.ascx E:\Web\c-c\Web\ascx\Kind.ascx! E:\Web\c-c\Web\ascx\Link.ascx" E:\Web\c-c\Web\ascx\Logo.ascx# $E:\Web\c-c\Web\ascx\search\Cgzc.ascx$ $E:\Web\c-c\Web\ascx\search\Fbcg.ascx% $E:\Web\c-c\Web\ascx\search\Hyfl.ascx&