/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.PointLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into PointLog(");
strSql.Append("CardID,MemName,Point,Type,CreateDateTime,ShopID,ShopName)");
strSql.Append(" values (");
strSql.Append("@CardID,@MemName,@Point,@Type,@CreateDateTime,@ShopID,@ShopName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@CardID", SqlDbType.VarChar,50),
new SqlParameter("@MemName", SqlDbType.VarChar,50),
new SqlParameter("@Point", SqlDbType.Int,4),
new SqlParameter("@Type", SqlDbType.Int,4),
new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
new SqlParameter("@ShopID", SqlDbType.Int,4),
new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
parameters[0].Value = model.CardID;
parameters[1].Value = model.MemName;
parameters[2].Value = model.Point;
parameters[3].Value = model.Type;
parameters[4].Value = model.CreateDateTime;
parameters[5].Value = model.ShopID;
parameters[6].Value = model.ShopName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.SysLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SysLog(");
strSql.Append("MasterAccount,MasterName,Area,Detail,CreateDateTime,ShopID,ShopName)");
strSql.Append(" values (");
strSql.Append("@MasterAccount,@MasterName,@Area,@Detail,@CreateDateTime,@ShopID,@ShopName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@MasterAccount", SqlDbType.VarChar,50),
new SqlParameter("@MasterName", SqlDbType.VarChar,50),
new SqlParameter("@Area", SqlDbType.VarChar,50),
new SqlParameter("@Detail", SqlDbType.VarChar,255),
new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
new SqlParameter("@ShopID", SqlDbType.Int,4),
new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
parameters[0].Value = model.MasterAccount;
parameters[1].Value = model.MasterName;
parameters[2].Value = model.Area;
parameters[3].Value = model.Detail;
parameters[4].Value = model.CreateDateTime;
parameters[5].Value = model.ShopID;
parameters[6].Value = model.ShopName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.CardLevel model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CardLevel(");
strSql.Append("LevelName,NeedPoint,Point,Percent,ShopID,ShopName)");
strSql.Append(" values (");
strSql.Append("@LevelName,@NeedPoint,@Point,@Percent,@ShopID,@ShopName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@LevelName", SqlDbType.VarChar,50),
new SqlParameter("@NeedPoint", SqlDbType.Int,4),
new SqlParameter("@Point", SqlDbType.Int,4),
new SqlParameter("@Percent", SqlDbType.Float,8),
new SqlParameter("@ShopID", SqlDbType.Int,4),
new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
parameters[0].Value = model.LevelName;
parameters[1].Value = model.NeedPoint;
parameters[2].Value = model.Point;
parameters[3].Value = model.Percent;
parameters[4].Value = model.ShopID;
parameters[5].Value = model.ShopName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.XExtensionValue model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into XExtensionValue(");
strSql.Append("ParentID,RecordID,ExtValue0)");
strSql.Append(" values (");
strSql.Append("@ParentID,@RecordID,@ExtValue0)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ParentID", SqlDbType.Int,4),
new SqlParameter("@RecordID", SqlDbType.Int,4),
new SqlParameter("@ExtValue0", SqlDbType.VarChar,255)};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.RecordID;
parameters[2].Value = model.ExtValue0;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(VipSoft.Model.MoneyRule model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into MoneyRule(");
strSql.Append("ID,Name,OneHour,SecondHour,ThirdHour,ThanTime)");
strSql.Append(" values (");
strSql.Append("@ID,@Name,@OneHour,@SecondHour,@ThirdHour,@ThanTime)");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@OneHour", SqlDbType.Money,8),
new SqlParameter("@SecondHour", SqlDbType.Money,8),
new SqlParameter("@ThirdHour", SqlDbType.Money,8),
new SqlParameter("@ThanTime", SqlDbType.Int,4)};
parameters[0].Value = model.ID;
parameters[1].Value = model.Name;
parameters[2].Value = model.OneHour;
parameters[3].Value = model.SecondHour;
parameters[4].Value = model.ThirdHour;
parameters[5].Value = model.ThanTime;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.GoodsClass model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into GoodsClass(");
strSql.Append("ClassName,ParentID,ShopID,ShopName)");
strSql.Append(" values (");
strSql.Append("@ClassName,@ParentID,@ShopID,@ShopName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ClassName", SqlDbType.VarChar,50),
new SqlParameter("@ParentID", SqlDbType.Int,4),
new SqlParameter("@ShopID", SqlDbType.Int,4),
new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
parameters[0].Value = model.ClassName;
parameters[1].Value = model.ParentID;
parameters[2].Value = model.ShopID;
parameters[3].Value = model.ShopName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.CardType model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CardType(");
strSql.Append("Type,IsExpenseGoods,IsExpensePoint,IsPointAuto)");
strSql.Append(" values (");
strSql.Append("@Type,@IsExpenseGoods,@IsExpensePoint,@IsPointAuto)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Type", SqlDbType.Int,4),
new SqlParameter("@IsExpenseGoods", SqlDbType.Bit,1),
new SqlParameter("@IsExpensePoint", SqlDbType.Bit,1),
new SqlParameter("@IsPointAuto", SqlDbType.Bit,1)};
parameters[0].Value = model.Type;
parameters[1].Value = model.IsExpenseGoods;
parameters[2].Value = model.IsExpensePoint;
parameters[3].Value = model.IsPointAuto;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(VipSoft.Model.SysParameter model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SysParameter(");
strSql.Append("ID,KeyName,Title,Type,MaxLength,GroupTitle,Value,Description)");
strSql.Append(" values (");
strSql.Append("@ID,@KeyName,@Title,@Type,@MaxLength,@GroupTitle,@Value,@Description)");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@KeyName", SqlDbType.VarChar,255),
new SqlParameter("@Title", SqlDbType.VarChar,255),
new SqlParameter("@Type", SqlDbType.Int,4),
new SqlParameter("@MaxLength", SqlDbType.Int,4),
new SqlParameter("@GroupTitle", SqlDbType.VarChar,50),
new SqlParameter("@Value", SqlDbType.VarChar,50),
new SqlParameter("@Description", SqlDbType.VarChar,255)};
parameters[0].Value = model.ID;
parameters[1].Value = model.KeyName;
parameters[2].Value = model.Title;
parameters[3].Value = model.Type;
parameters[4].Value = model.MaxLength;
parameters[5].Value = model.GroupTitle;
parameters[6].Value = model.Value;
parameters[7].Value = model.Description;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.Shop model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Shop(");
strSql.Append("Name,TelPhone,ShopLink,Remark)");
strSql.Append(" values (");
strSql.Append("@Name,@TelPhone,@ShopLink,@Remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@TelPhone", SqlDbType.VarChar,20),
new SqlParameter("@ShopLink", SqlDbType.VarChar,50),
new SqlParameter("@Remark", SqlDbType.VarChar,1000)};
parameters[0].Value = model.Name;
parameters[1].Value = model.TelPhone;
parameters[2].Value = model.ShopLink;
parameters[3].Value = model.Remark;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.CouponDetail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CouponDetail(");
strSql.Append("CouponID,CouponNumber,State,UsedTime)");
strSql.Append(" values (");
strSql.Append("@CouponID,@CouponNumber,@State,@UsedTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@CouponID", SqlDbType.Int,4),
new SqlParameter("@CouponNumber", SqlDbType.VarChar,20),
new SqlParameter("@State", SqlDbType.Int,4),
new SqlParameter("@UsedTime", SqlDbType.DateTime)};
parameters[0].Value = model.CouponID;
parameters[1].Value = model.CouponNumber;
parameters[2].Value = model.State;
parameters[3].Value = model.UsedTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.XDataNode model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into XDataNode(");
strSql.Append("ParentID,NodeType,Name,FieldPosition)");
strSql.Append(" values (");
strSql.Append("@ParentID,@NodeType,@Name,@FieldPosition)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ParentID", SqlDbType.Int,4),
new SqlParameter("@NodeType", SqlDbType.Int,4),
new SqlParameter("@Name", SqlDbType.VarChar,255),
new SqlParameter("@FieldPosition", SqlDbType.Int,4)};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.NodeType;
parameters[2].Value = model.Name;
parameters[3].Value = model.FieldPosition;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.XDataProperty model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into XDataProperty(");
strSql.Append("DataNodeID,PropertyType,PropertyValue)");
strSql.Append(" values (");
strSql.Append("@DataNodeID,@PropertyType,@PropertyValue)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@DataNodeID", SqlDbType.Int,4),
new SqlParameter("@PropertyType", SqlDbType.Int,4),
new SqlParameter("@PropertyValue", SqlDbType.VarChar,1000)};
parameters[0].Value = model.DataNodeID;
parameters[1].Value = model.PropertyType;
parameters[2].Value = model.PropertyValue;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.Gift model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Gift(");
strSql.Append("GiftCode,Name,Photo,Point,Number,ExchangeNumber)");
strSql.Append(" values (");
strSql.Append("@GiftCode,@Name,@Photo,@Point,@Number,@ExchangeNumber)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@GiftCode", SqlDbType.VarChar,50),
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@Photo", SqlDbType.VarChar,50),
new SqlParameter("@Point", SqlDbType.Int,4),
new SqlParameter("@Number", SqlDbType.Int,4),
new SqlParameter("@ExchangeNumber", SqlDbType.Int,4)};
parameters[0].Value = model.GiftCode;
parameters[1].Value = model.Name;
parameters[2].Value = model.Photo;
parameters[3].Value = model.Point;
parameters[4].Value = model.Number;
parameters[5].Value = model.ExchangeNumber;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.GoodsLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into GoodsLog(");
strSql.Append("GoodsID,Type,Number,MasterID,MasterName,CreateDateTime,Remark)");
strSql.Append(" values (");
strSql.Append("@GoodsID,@Type,@Number,@MasterID,@MasterName,@CreateDateTime,@Remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@GoodsID", SqlDbType.Int,4),
new SqlParameter("@Type", SqlDbType.Int,4),
new SqlParameter("@Number", SqlDbType.Int,4),
new SqlParameter("@MasterID", SqlDbType.Int,4),
new SqlParameter("@MasterName", SqlDbType.VarChar,50),
new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.VarChar,1000)};
parameters[0].Value = model.GoodsID;
parameters[1].Value = model.Type;
parameters[2].Value = model.Number;
parameters[3].Value = model.MasterID;
parameters[4].Value = model.MasterName;
parameters[5].Value = model.CreateDateTime;
parameters[6].Value = model.Remark;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
public ExpResult(decimal _totalMoney, bool _isTravelerMember, VipSoft.Model.MemCard _memInfo)
{
totalMoney = _totalMoney;
isTravelerMember = _isTravelerMember;
memInfo = _memInfo;
InitializeComponent();
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="master"></param>
/// <param name="area"></param>
/// <param name="detail"></param>
/// <param name="createdatetime"></param>
/// <param name="shopid"></param>
/// <param name="shopname"></param>
public SysLog(VipSoft.Model.Master master,string area,string detail,DateTime createdatetime)
{
_masteraccount = master.Account;
_mastername = master.Name;
_area = area;
_detail = detail;
_createdatetime = createdatetime;
_shopid = master.ShopID;
_shopname = master.ShopName;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.Goods model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Goods(");
strSql.Append("GoodsCode,Name,NameCode,Unit,Number,SaleNumber,ClassID,Price,BuyPrice,Point,MinPercent,GoodsType,PointType,CreateDateTime,ShopID,ShopName,Remark)");
strSql.Append(" values (");
strSql.Append("@GoodsCode,@Name,@NameCode,@Unit,@Number,@SaleNumber,@ClassID,@Price,@BuyPrice,@Point,@MinPercent,@GoodsType,@PointType,@CreateDateTime,@ShopID,@ShopName,@Remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@GoodsCode", SqlDbType.VarChar,50),
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@NameCode", SqlDbType.VarChar,50),
new SqlParameter("@Unit", SqlDbType.VarChar,20),
new SqlParameter("@Number", SqlDbType.Int,4),
new SqlParameter("@SaleNumber", SqlDbType.Int,4),
new SqlParameter("@ClassID", SqlDbType.Int,4),
new SqlParameter("@Price", SqlDbType.Money,8),
new SqlParameter("@BuyPrice", SqlDbType.Money,8),
new SqlParameter("@Point", SqlDbType.Int,4),
new SqlParameter("@MinPercent", SqlDbType.Float,8),
new SqlParameter("@GoodsType", SqlDbType.Bit,1),
new SqlParameter("@PointType", SqlDbType.Int,4),
new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
new SqlParameter("@ShopID", SqlDbType.Int,4),
new SqlParameter("@ShopName", SqlDbType.VarChar,50),
new SqlParameter("@Remark", SqlDbType.VarChar,1000)};
parameters[0].Value = model.GoodsCode;
parameters[1].Value = model.Name;
parameters[2].Value = model.NameCode;
parameters[3].Value = model.Unit;
parameters[4].Value = model.Number;
parameters[5].Value = model.SaleNumber;
parameters[6].Value = model.ClassID;
parameters[7].Value = model.Price;
parameters[8].Value = model.BuyPrice;
parameters[9].Value = model.Point;
parameters[10].Value = model.MinPercent;
parameters[11].Value = model.GoodsType;
parameters[12].Value = model.PointType;
parameters[13].Value = model.CreateDateTime;
parameters[14].Value = model.ShopID;
parameters[15].Value = model.ShopName;
parameters[16].Value = model.Remark;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.OrderLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into OrderLog(");
strSql.Append("OrderCode,OrderType,MemID,CardID,MemName,TotalNumber,TotalMoney,DisCountMoney,PayInfo,Point,CreateDateTime,PayType,MasterID,MasterName,ShopID,ShopName)");
strSql.Append(" values (");
strSql.Append("@OrderCode,@OrderType,@MemID,@CardID,@MemName,@TotalNumber,@TotalMoney,@DisCountMoney,@PayInfo,@Point,@CreateDateTime,@PayType,@MasterID,@MasterName,@ShopID,@ShopName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@OrderCode", SqlDbType.NChar,10),
new SqlParameter("@OrderType", SqlDbType.Int,4),
new SqlParameter("@MemID", SqlDbType.Int,4),
new SqlParameter("@CardID", SqlDbType.VarChar,50),
new SqlParameter("@MemName", SqlDbType.VarChar,20),
new SqlParameter("@TotalNumber", SqlDbType.Int,4),
new SqlParameter("@TotalMoney", SqlDbType.Money,8),
new SqlParameter("@DisCountMoney", SqlDbType.Money,8),
new SqlParameter("@PayInfo", SqlDbType.VarChar,50),
new SqlParameter("@Point", SqlDbType.Int,4),
new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
new SqlParameter("@PayType", SqlDbType.Int,4),
new SqlParameter("@MasterID", SqlDbType.Int,4),
new SqlParameter("@MasterName", SqlDbType.VarChar,50),
new SqlParameter("@ShopID", SqlDbType.Int,4),
new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
parameters[0].Value = model.OrderCode;
parameters[1].Value = model.OrderType;
parameters[2].Value = model.MemID;
parameters[3].Value = model.CardID;
parameters[4].Value = model.MemName;
parameters[5].Value = model.TotalNumber;
parameters[6].Value = model.TotalMoney;
parameters[7].Value = model.DisCountMoney;
parameters[8].Value = model.PayInfo;
parameters[9].Value = model.Point;
parameters[10].Value = model.CreateDateTime;
parameters[11].Value = model.PayType;
parameters[12].Value = model.MasterID;
parameters[13].Value = model.MasterName;
parameters[14].Value = model.ShopID;
parameters[15].Value = model.ShopName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
public ExpResult(List<TempOrderInfo> list, decimal _totalMoney, bool _isTravelerMember, VipSoft.Model.MemCard _memInfo)
{
totalMoney = 0;
listOrders = list;
foreach (TempOrderInfo order in listOrders)
{
totalMoney += order.DiscountPrice;
}
totalMoney = Math.Round(totalMoney, 0, MidpointRounding.AwayFromZero);
isTravelerMember = _isTravelerMember;
memInfo = _memInfo;
InitializeComponent();
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.OrderGoods model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into OrderGoods(");
strSql.Append("GoodsID,GoodsCode,GoodsName,type,GoodsUnit,Price,Number,TotalMoney,MasterID,MasterName,ShopID,ShopName,CreateTime)");
strSql.Append(" values (");
strSql.Append("@GoodsID,@GoodsCode,@GoodsName,@type,@GoodsUnit,@Price,@Number,@TotalMoney,@MasterID,@MasterName,@ShopID,@ShopName,@CreateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@GoodsID", SqlDbType.Int,4),
new SqlParameter("@GoodsCode", SqlDbType.VarChar,50),
new SqlParameter("@GoodsName", SqlDbType.VarChar,50),
new SqlParameter("@type", SqlDbType.Int,4),
new SqlParameter("@GoodsUnit", SqlDbType.VarChar,20),
new SqlParameter("@Price", SqlDbType.Money,8),
new SqlParameter("@Number", SqlDbType.Int,4),
new SqlParameter("@TotalMoney", SqlDbType.Money,8),
new SqlParameter("@MasterID", SqlDbType.Int,4),
new SqlParameter("@MasterName", SqlDbType.VarChar,50),
new SqlParameter("@ShopID", SqlDbType.Int,4),
new SqlParameter("@ShopName", SqlDbType.VarChar,50),
new SqlParameter("@CreateTime", SqlDbType.DateTime)
};
parameters[0].Value = model.GoodsID;
parameters[1].Value = model.GoodsCode;
parameters[2].Value = model.GoodsName;
parameters[3].Value = model.type;
parameters[4].Value = model.GoodsUnit;
parameters[5].Value = model.Price;
parameters[6].Value = model.Number;
parameters[7].Value = model.TotalMoney;
parameters[8].Value = model.MasterID;
parameters[9].Value = model.MasterName;
parameters[10].Value = model.ShopID;
parameters[11].Value = model.ShopName;
parameters[12].Value = model.CreateTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.ExchangeLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ExchangeLog(");
strSql.Append("MemID,CardID,Name,GiftID,GiftCode,GiftName,Number,Point,MasterID,MasterName,ShopID,ShopName)");
strSql.Append(" values (");
strSql.Append("@MemID,@CardID,@Name,@GiftID,@GiftCode,@GiftName,@Number,@Point,@MasterID,@MasterName,@ShopID,@ShopName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@MemID", SqlDbType.Int,4),
new SqlParameter("@CardID", SqlDbType.VarChar,50),
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@GiftID", SqlDbType.Int,4),
new SqlParameter("@GiftCode", SqlDbType.VarChar,20),
new SqlParameter("@GiftName", SqlDbType.VarChar,50),
new SqlParameter("@Number", SqlDbType.Int,4),
new SqlParameter("@Point", SqlDbType.Int,4),
new SqlParameter("@MasterID", SqlDbType.Int,4),
new SqlParameter("@MasterName", SqlDbType.VarChar,50),
new SqlParameter("@ShopID", SqlDbType.Int,4),
new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
parameters[0].Value = model.MemID;
parameters[1].Value = model.CardID;
parameters[2].Value = model.Name;
parameters[3].Value = model.GiftID;
parameters[4].Value = model.GiftCode;
parameters[5].Value = model.GiftName;
parameters[6].Value = model.Number;
parameters[7].Value = model.Point;
parameters[8].Value = model.MasterID;
parameters[9].Value = model.MasterName;
parameters[10].Value = model.ShopID;
parameters[11].Value = model.ShopName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.RechargeLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into RechargeLog(");
strSql.Append("MemID,CardID,MemName,Type,Money,GiveMoney,MasterID,MasterName,CreateTime,Remark,ShopID,ShopName)");
strSql.Append(" values (");
strSql.Append("@MemID,@CardID,@MemName,@Type,@Money,@GiveMoney,@MasterID,@MasterName,@CreateTime,@Remark,@ShopID,@ShopName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@MemID", SqlDbType.Int,4),
new SqlParameter("@CardID", SqlDbType.VarChar,50),
new SqlParameter("@MemName", SqlDbType.VarChar,50),
new SqlParameter("@Type", SqlDbType.Int,4),
new SqlParameter("@Money", SqlDbType.Money,8),
new SqlParameter("@GiveMoney", SqlDbType.Money,8),
new SqlParameter("@CreateTime",SqlDbType.DateTime),
new SqlParameter("@Remark",SqlDbType.VarChar,1000),
new SqlParameter("@MasterID", SqlDbType.Int,4),
new SqlParameter("@MasterName", SqlDbType.VarChar,50),
new SqlParameter("@ShopID", SqlDbType.Int,4),
new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
parameters[0].Value = model.MemID;
parameters[1].Value = model.CardID;
parameters[2].Value = model.MemName;
parameters[3].Value = model.Type;
parameters[4].Value = model.Money;
parameters[5].Value = model.GiveMoney;
parameters[6].Value = model.CreateTime;
parameters[7].Value = model.Remark;
parameters[8].Value = model.MasterID;
parameters[9].Value = model.MasterName;
parameters[10].Value = model.ShopID;
parameters[11].Value = model.ShopName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
protected void BindMemInfo(VipSoft.Model.MemCard memInfo)
{
string sex = memInfo.Sex == 0 ? "" : (memInfo.Sex == 1 ? "(男)" : "(女)");
this.label_CardID.Text = memInfo.CardID + sex;
this.label_Name.Text = memInfo.Name;
this.label_Money.Text = memInfo.Money.ToString("￥0.00");
this.label_Point.Text = memInfo.Point.ToString();
this.label_Mobile.Text = memInfo.Mobile.ToString();
this.label_State.Text = memInfo.State == (int)VipSoft.Common.CardState.Normal ? "正常" : (memInfo.State == (int)VipSoft.Common.CardState.Locked ? "锁定" : "挂失");
this.label_TotalMoney.Text = memInfo.TotalMoney.ToString("￥0.00");
if (!memInfo.IsPast)
this.label_PassTime.Text = "不限";
else
this.label_PassTime.Text = ((DateTime)(memInfo.PastTime)).ToShortDateString();
this.myMemberPhoto.PhotoPath = memInfo.Photo;
this.label_Level.Text = Function.LevelIDToName((int)memInfo.LevelID);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.Coupon model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Coupon(");
strSql.Append("Title,Prefix,Type,StartTime,EndTime,Money,ShopIDInfo,Remark,Num)");
strSql.Append(" values (");
strSql.Append("@Title,@Prefix,@Type,@StartTime,@EndTime,@Money,@ShopIDInfo,@Remark,@Num)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.VarChar,50),
new SqlParameter("@Prefix", SqlDbType.VarChar,20),
new SqlParameter("@Type",SqlDbType.Int,4),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@Money", SqlDbType.Money,8),
new SqlParameter("@ShopIDInfo", SqlDbType.VarChar,255),
new SqlParameter("@Remark", SqlDbType.VarChar,1000),
new SqlParameter("@Num",SqlDbType.Int,4)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.Prefix;
parameters[2].Value = model.Type;
parameters[3].Value = model.StartTime;
parameters[4].Value = model.EndTime;
parameters[5].Value = model.Money;
parameters[6].Value = model.ShopIDInfo;
parameters[7].Value = model.Remark;
parameters[8].Value = model.Num;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.Master model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Master(");
strSql.Append("Account,Password,Name,Sex,TelPhone,IsSuper,Authority,ShopID,ShopName)");
strSql.Append(" values (");
strSql.Append("@Account,@Password,@Name,@Sex,@TelPhone,@IsSuper,@Authority,@ShopID,@ShopName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Account", SqlDbType.VarChar,20),
new SqlParameter("@Password", SqlDbType.VarChar,20),
new SqlParameter("@Name", SqlDbType.VarChar,20),
new SqlParameter("@Sex", SqlDbType.Int,4),
new SqlParameter("@TelPhone", SqlDbType.VarChar,20),
new SqlParameter("@IsSuper", SqlDbType.Bit,1),
new SqlParameter("@Authority", SqlDbType.VarChar,1000),
new SqlParameter("@ShopID", SqlDbType.Int,4),
new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
parameters[0].Value = model.Account;
parameters[1].Value = model.Password;
parameters[2].Value = model.Name;
parameters[3].Value = model.Sex;
parameters[4].Value = model.TelPhone;
parameters[5].Value = model.IsSuper;
parameters[6].Value = model.Authority;
parameters[7].Value = model.ShopID;
parameters[8].Value = model.ShopName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.SmsLog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SmsLog(");
strSql.Append("CardID,Name,Mobile,Content,SendTime,State,Number,ShopID,ShopName)");
strSql.Append(" values (");
strSql.Append("@CardID,@Name,@Mobile,@Content,@SendTime,@State,@Number,@ShopID,@ShopName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@CardID", SqlDbType.VarChar,50),
new SqlParameter("@Name", SqlDbType.VarChar,20),
new SqlParameter("@Mobile", SqlDbType.VarChar,20),
new SqlParameter("@Content", SqlDbType.VarChar,255),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@State", SqlDbType.Int,4),
new SqlParameter("@Number", SqlDbType.Int,4),
new SqlParameter("@ShopID", SqlDbType.Int,4),
new SqlParameter("@ShopName", SqlDbType.VarChar,50)};
parameters[0].Value = model.CardID;
parameters[1].Value = model.Name;
parameters[2].Value = model.Mobile;
parameters[3].Value = model.Content;
parameters[4].Value = model.SendTime;
parameters[5].Value = model.State;
parameters[6].Value = model.Number;
parameters[7].Value = model.ShopID;
parameters[8].Value = model.ShopName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.OrderDetail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into OrderDetail(");
strSql.Append("OrderCode,GoodsID,GoodsCode,GoodsName,Price,DiscountPrice,Number,Percent,IsService)");
strSql.Append(" values (");
strSql.Append("@OrderCode,@GoodsID,@GoodsCode,@GoodsName,@Price,@DiscountPrice,@Number,@Percent,@IsService)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@OrderCode", SqlDbType.VarChar,50),
new SqlParameter("@GoodsID", SqlDbType.Int,4),
new SqlParameter("@GoodsCode", SqlDbType.VarChar,50),
new SqlParameter("@GoodsName", SqlDbType.VarChar,50),
new SqlParameter("@Price", SqlDbType.Money,8),
new SqlParameter("@DiscountPrice", SqlDbType.Money,8),
new SqlParameter("@Number", SqlDbType.Int,4),
new SqlParameter("@Percent", SqlDbType.Float,8),
new SqlParameter("@IsService", SqlDbType.Bit,1)};
parameters[0].Value = model.OrderCode;
parameters[1].Value = model.GoodsID;
parameters[2].Value = model.GoodsCode;
parameters[3].Value = model.GoodsName;
parameters[4].Value = model.Price;
parameters[5].Value = model.DiscountPrice;
parameters[6].Value = model.Number;
parameters[7].Value = model.Percent;
parameters[8].Value = model.IsService;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.SmsTemplate model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SmsTemplate(");
strSql.Append("TemplateName,TemplateContent)");
strSql.Append(" values (");
strSql.Append("@TemplateName,@TemplateContent)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@TemplateName", SqlDbType.VarChar,100),
new SqlParameter("@TemplateContent", SqlDbType.VarChar,1000)};
parameters[0].Value = model.TemplateName;
parameters[1].Value = model.TemplateContent;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.ActivityRule model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ActivityRule(");
strSql.Append("Title,Target,DeadLineType,DeadLine,Type,Rule,Remark,CreateDateTime)");
strSql.Append(" values (");
strSql.Append("@Title,@Target,@DeadLineType,@DeadLine,@Type,@Rule,@Remark,@CreateDateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.VarChar,255),
new SqlParameter("@Target", SqlDbType.Int,4),
new SqlParameter("@DeadLineType", SqlDbType.Int,4),
new SqlParameter("@DeadLine", SqlDbType.Int,4),
new SqlParameter("@Type", SqlDbType.Int,4),
new SqlParameter("@Rule", SqlDbType.VarChar,255),
new SqlParameter("@Remark", SqlDbType.VarChar,1000),
new SqlParameter("@CreateDateTime", SqlDbType.DateTime)};
parameters[0].Value = model.Title;
parameters[1].Value = model.Target;
parameters[2].Value = model.DeadLineType;
parameters[3].Value = model.DeadLine;
parameters[4].Value = model.Type;
parameters[5].Value = model.Rule;
parameters[6].Value = model.Remark;
parameters[7].Value = model.CreateDateTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(VipSoft.Model.OrderGoods model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update OrderGoods set ");
strSql.Append("GoodsID=@GoodsID,");
strSql.Append("GoodsCode=@GoodsCode,");
strSql.Append("GoodsName=@GoodsName,");
strSql.Append("type=@type,");
strSql.Append("GoodsUnit=@GoodsUnit,");
strSql.Append("Price=@Price,");
strSql.Append("Number=@Number,");
strSql.Append("TotalMoney=@TotalMoney,");
strSql.Append("MasterID=@MasterID,");
strSql.Append("MasterName=@MasterName,");
strSql.Append("ShopID=@ShopID,");
strSql.Append("ShopName=@ShopName,");
strSql.Append("CreateTime=@CreateTime");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@GoodsID", SqlDbType.Int,4),
new SqlParameter("@GoodsCode", SqlDbType.VarChar,50),
new SqlParameter("@GoodsName", SqlDbType.VarChar,50),
new SqlParameter("@type", SqlDbType.Int,4),
new SqlParameter("@GoodsUnit", SqlDbType.VarChar,20),
new SqlParameter("@Price", SqlDbType.Money,8),
new SqlParameter("@Number", SqlDbType.Int,4),
new SqlParameter("@TotalMoney", SqlDbType.Money,8),
new SqlParameter("@MasterID", SqlDbType.Int,4),
new SqlParameter("@MasterName", SqlDbType.VarChar,50),
new SqlParameter("@ShopID", SqlDbType.Int,4),
new SqlParameter("@ShopName", SqlDbType.VarChar,50),
new SqlParameter("@CreateTime",SqlDbType.DateTime),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.GoodsID;
parameters[1].Value = model.GoodsCode;
parameters[2].Value = model.GoodsName;
parameters[3].Value = model.type;
parameters[4].Value = model.GoodsUnit;
parameters[5].Value = model.Price;
parameters[6].Value = model.Number;
parameters[7].Value = model.TotalMoney;
parameters[8].Value = model.MasterID;
parameters[9].Value = model.MasterName;
parameters[10].Value = model.ShopID;
parameters[11].Value = model.ShopName;
parameters[12].Value = model.CreateTime;
parameters[13].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}