/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MConDetaile model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO tbl_ConDetailed( HuiYuanID, JiaoYiHao ,JinE ,JiaoYiShiJian, XiaoFeiFangShi ,DingDanBianHao ,JiaoYiDuiXiang, DingDanLeiBie) VALUES ( @HuiYuanID, @JiaoYiHao,@JinE,@JiaoYiShiJian, @XiaoFeiFangShi,@DingDanBianHao,@JiaoYiDuiXiang,@DingDanLeiBie)");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "HuiYuanID", DbType.AnsiStringFixedLength, model.HuiYuanID);
this._db.AddInParameter(cmd, "JiaoYiHao", DbType.String, model.JiaoYiHao);
this._db.AddInParameter(cmd, "JinE", DbType.Decimal, model.JinE);
this._db.AddInParameter(cmd, "JiaoYiShiJian", DbType.DateTime, model.JiaoYiShiJian);
this._db.AddInParameter(cmd, "XiaoFeiFangShi", DbType.Byte, model.XFway);
this._db.AddInParameter(cmd, "DingDanBianHao", DbType.String, model.DingDanBianHao);
this._db.AddInParameter(cmd, "JiaoYiDuiXiang", DbType.String, model.JiaoYiDuiXiang);
this._db.AddInParameter(cmd, "DingDanLeiBie", DbType.Byte, model.DDCarrtes);
return(DbHelper.ExecuteSql(cmd, this._db));
}
/// <summary>
/// 留言
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Eyousoft_yhq.Model.Comment model)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("INSERT INTO tbl_Comment ( ProductID , CommentID , PeopleID , CommentText, CheckState , IssueTime ) VALUES ( @ProductID , @CommentID , @PeopleID , @CommentText, 0 , @IssueTime )");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "ProductID", System.Data.DbType.AnsiStringFixedLength, model.ProductID);
this._db.AddInParameter(cmd, "CommentID", System.Data.DbType.String, model.CommentID);
this._db.AddInParameter(cmd, "PeopleID", System.Data.DbType.String, model.PeopleID);
this._db.AddInParameter(cmd, "CommentText", System.Data.DbType.String, model.CommentText);
//this._db.AddInParameter(cmd, "CheckState", System.Data.DbType.String, model.ContactSex);
this._db.AddInParameter(cmd, "IssueTime", System.Data.DbType.String, model.IssueTime);
return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int updateWXBind(Eyousoft_yhq.Model.WXBind model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE tbl_WeiXinBind SET CustomerId=@CustomerId, OpenId = @OpenId , NickName = @NickName , Sex = @Sex WHERE Id=@Id)");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "Id", System.Data.DbType.String, model.Id);
this._db.AddInParameter(cmd, "CustomerId", System.Data.DbType.String, model.CustomerId);
this._db.AddInParameter(cmd, "OpenId", System.Data.DbType.String, model.OpenId);
this._db.AddInParameter(cmd, "NickName", System.Data.DbType.String, model.NickName);
this._db.AddInParameter(cmd, "Sex", System.Data.DbType.String, model.Sex);
return(DbHelper.ExecuteSql(cmd, this._db));
}
/// <summary>
/// 添加发送信息
/// </summary>
/// <param name="model">发送信息实体</param>
/// <returns></returns>
public bool Add(Eyousoft_yhq.Model.SendMSG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" INSERT INTO tbl_SendMSG (sendNum,SendText,issuetime,ProductID,FavourCode) VALUES (@sendNum,@SendText,@issuetime,@ProductID,@FavourCode) ;UPDATE [tbl_KV] SET v= v - @minusNum WHERE k='MsgNumber' ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "sendNum", System.Data.DbType.AnsiStringFixedLength, model.SendNum);
this._db.AddInParameter(cmd, "SendText", System.Data.DbType.String, model.SendText);
this._db.AddInParameter(cmd, "issuetime", System.Data.DbType.DateTime, model.IssueTime);
this._db.AddInParameter(cmd, "ProductID", System.Data.DbType.AnsiStringFixedLength, model.ProductID);
this._db.AddInParameter(cmd, "minusNum", System.Data.DbType.Int32, model.minusNum);
this._db.AddInParameter(cmd, "FavourCode", System.Data.DbType.String, model.FavourCode);
return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 实体修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(Eyousoft_yhq.Model.ProductType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" UPDATE tbl_ProductType SET TypeName = @TypeName,ProductID = @ProductID,TypeImg = @TypeImg ,AdminName=@AdminName,OrderByInt=@OrderByInt,WebImg=@WebImg,XianLu=@XianLu");
strSql.Append(" WHERE ");
strSql.Append(" TypeID = @TypeID ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "TypeName", System.Data.DbType.AnsiStringFixedLength, model.TypeName);
this._db.AddInParameter(cmd, "ProductID", System.Data.DbType.String, model.ProductID);
this._db.AddInParameter(cmd, "TypeImg", System.Data.DbType.String, model.TypeImg);
this._db.AddInParameter(cmd, "AdminName", System.Data.DbType.String, getJsonStr(model.AdminName));
this._db.AddInParameter(cmd, "TypeID", System.Data.DbType.Int32, model.TypeID);
this._db.AddInParameter(cmd, "OrderByInt", System.Data.DbType.Int32, model.OrderBy);
this._db.AddInParameter(cmd, "WebImg", System.Data.DbType.String, model.WebImg);
this._db.AddInParameter(cmd, "XianLu", System.Data.DbType.Byte, (int)model.xianlu);
return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 添加发送信息
/// </summary>
/// <param name="model">发送信息实体</param>
/// <returns></returns>
public bool Add(Eyousoft_yhq.Model.MJiPiaoBaoCun model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO tbl_PlanTicket (OrderID ,OrderCode ,OpeatorID ,OpeatorName ,IssueTime,ModifyTag,JpAdress,OrderPrice,InsPrice,WeiDianId) VALUES (@OrderID ,@OrderCode ,@OpeatorID ,@OpeatorName ,@IssueTime,@ModifyTag,@JpAdress,@OrderPrice,@InsPrice,@WeiDianId)");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "OrderID", System.Data.DbType.String, model.OrderID);
this._db.AddInParameter(cmd, "OrderCode", System.Data.DbType.String, model.OrderCode);
this._db.AddInParameter(cmd, "OpeatorID", System.Data.DbType.String, model.OpeatorID);
this._db.AddInParameter(cmd, "OpeatorName", System.Data.DbType.String, model.OpeatorName);
this._db.AddInParameter(cmd, "IssueTime", System.Data.DbType.DateTime, model.IssueTime);
this._db.AddInParameter(cmd, "ModifyTag", System.Data.DbType.String, model.ModifyTag);
this._db.AddInParameter(cmd, "JpAdress", System.Data.DbType.String, model.JpAdress);
this._db.AddInParameter(cmd, "OrderPrice", System.Data.DbType.Decimal, model.OrderPrice);
this._db.AddInParameter(cmd, "InsPrice", System.Data.DbType.Decimal, model.InsPrice);
_db.AddInParameter(cmd, "WeiDianId", System.Data.DbType.AnsiStringFixedLength, model.WeiDianId);
return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="model">保险</param>
/// <returns></returns>
public int Insert(MPlanIns model)
{
string strSql = "INSERT INTO tbl_PlantIns(OrderID ,InsNO ,InsName ,OperatorID ,OperatorName ,IssueTime ,PlantID ,InsMoney ,OrderCode ,PolicTor ,LinkTel ,LinkMail ,LinkAddress) VALUES (@OrderID ,@InsNO ,@InsName ,@OperatorID ,@OperatorName ,@IssueTime ,@PlantID ,@InsMoney ,@OrderCode ,@PolicTor ,@LinkTel ,@LinkMail ,@LinkAddress)";
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "OrderID", DbType.String, model.OrderID);
this._db.AddInParameter(cmd, "InsNO", DbType.String, model.InsNO);
this._db.AddInParameter(cmd, "InsName", DbType.String, model.InsName);
this._db.AddInParameter(cmd, "OperatorID", DbType.String, model.OperatorID);
this._db.AddInParameter(cmd, "OperatorName", DbType.String, model.OperatorName);
this._db.AddInParameter(cmd, "IssueTime", DbType.DateTime, model.IssueTime);
this._db.AddInParameter(cmd, "PlantID", DbType.String, model.PlantID);
this._db.AddInParameter(cmd, "InsMoney", DbType.Decimal, model.InsMoney);
this._db.AddInParameter(cmd, "PolicTor", DbType.String, model.PolicTor);
this._db.AddInParameter(cmd, "LinkTel", DbType.String, model.LinkTel);
this._db.AddInParameter(cmd, "LinkMail", DbType.String, model.LinkMail);
this._db.AddInParameter(cmd, "LinkAddress", DbType.String, model.LinkAddress);
return(DbHelper.ExecuteSql(cmd, this._db));
}
public bool Add(Eyousoft_yhq.Model.ProductType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" INSERT INTO tbl_ProductType ( TypeName , ProductID , TypeImg , TpMark,AdminName,OrderByInt,WebImg,XianLu) ");
strSql.Append(" VALUES ");
strSql.Append(" (@TypeName , @ProductID , @TypeImg,@TpMark,@AdminName,@OrderByInt,@WebImg,@XianLu) ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "TypeName", System.Data.DbType.AnsiStringFixedLength, model.TypeName);
this._db.AddInParameter(cmd, "ProductID", System.Data.DbType.String, model.ProductID);
this._db.AddInParameter(cmd, "TypeImg", System.Data.DbType.String, model.TypeImg);
this._db.AddInParameter(cmd, "TpMark", System.Data.DbType.Byte, model.TpMark);
this._db.AddInParameter(cmd, "AdminName", System.Data.DbType.String, getJsonStr(model.AdminName));
this._db.AddInParameter(cmd, "OrderByInt", System.Data.DbType.Int32, model.OrderBy);
this._db.AddInParameter(cmd, "WebImg", System.Data.DbType.String, model.WebImg);
this._db.AddInParameter(cmd, "XianLu", System.Data.DbType.Byte, (int)model.xianlu);
return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 添加一条抽奖记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int Insert(ChouJiang info)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" INSERT INTO tbl_ChouJiang (ChouJiangID ,LiuShuiHao ,ID ,CaoZuoRenID ,ChouJiangShiJian ,JieGuo ,DianShu,FangShi) VALUES ( @ChouJiangID , @LiuShuiHao , @ID , @CaoZuoRenID , @ChouJiangShiJian , @JieGuo , @DianShu ,@FangShi) ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "ChouJiangID", System.Data.DbType.AnsiStringFixedLength, info.ChouJiangID);
this._db.AddInParameter(cmd, "LiuShuiHao", System.Data.DbType.String, info.LiuShuiHao);
this._db.AddInParameter(cmd, "ID", System.Data.DbType.AnsiStringFixedLength, info.ID);
this._db.AddInParameter(cmd, "CaoZuoRenID", System.Data.DbType.AnsiStringFixedLength, info.CaoZuoRenID);
this._db.AddInParameter(cmd, "ChouJiangShiJian", System.Data.DbType.DateTime, info.ChouJiangShiJian);
this._db.AddInParameter(cmd, "JieGuo", System.Data.DbType.Byte, info.JieGuo);
this._db.AddInParameter(cmd, "DianShu", System.Data.DbType.Decimal, info.DianShu);
this._db.AddInParameter(cmd, "FangShi", System.Data.DbType.Byte, info.FangShi);
return(DbHelper.ExecuteSql(cmd, this._db));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MYouJi model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbl_HuiYouYouJi(");
strSql.Append("YouJiId,HuiYuanId,YouJiTitle,YouJiContent,IssueTime,YouJiLeiXing,ShiPinLink,WeiXinMa)");
strSql.Append(" values (");
strSql.Append("@YouJiId,@HuiYuanId,@YouJiTitle,@YouJiContent,@IssueTime,@YouJiLeiXing,@ShiPinLink,@WeiXinMa)");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "YouJiId", System.Data.DbType.String, model.YouJiId);
this._db.AddInParameter(cmd, "HuiYuanId", System.Data.DbType.String, model.HuiYuanId);
this._db.AddInParameter(cmd, "YouJiTitle", System.Data.DbType.String, model.YouJiTitle);
this._db.AddInParameter(cmd, "YouJiContent", System.Data.DbType.String, getJsonStr(model.YouJiContent));
this._db.AddInParameter(cmd, "IssueTime", System.Data.DbType.DateTime, model.IssueTime);
this._db.AddInParameter(cmd, "YouJiLeiXing", System.Data.DbType.Byte, model.YouJiType);
this._db.AddInParameter(cmd, "ShiPinLink", System.Data.DbType.String, model.ShiPinLink);
this._db.AddInParameter(cmd, "WeiXinMa", System.Data.DbType.String, model.WeiXinMa);
return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 修改产品信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(Eyousoft_yhq.Model.GYSticket model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" UPDATE GYSTicket SET CusName = @CusName , CusSex = @CusSex , CusMob = @CusMob , PlaneTicket = @PlaneTicket , IssueTime = @IssueTime , Remark = @Remark ,OpertorID=@OpertorID ,OrderState=@OrderState,TicketState=@TicketState WHERE ID = @ID ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "ID", DbType.AnsiStringFixedLength, model.ID);
this._db.AddInParameter(cmd, "CusName", DbType.String, model.CusName);
this._db.AddInParameter(cmd, "CusSex", DbType.Int32, (int)model.CusSex);
this._db.AddInParameter(cmd, "CusMob", DbType.String, model.CusMob);
this._db.AddInParameter(cmd, "PlaneTicket", DbType.String, model.PlaneTicket);
this._db.AddInParameter(cmd, "IssueTime", DbType.DateTime, model.IssueTime);
this._db.AddInParameter(cmd, "Remark", DbType.String, model.Remark);
this._db.AddInParameter(cmd, "OpertorID", DbType.AnsiStringFixedLength, model.OpertorID);
this._db.AddInParameter(cmd, "OrderState", DbType.Byte, (int)model.orderState);
this._db.AddInParameter(cmd, "TicketState", DbType.Byte, (int)model.payState);
return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Eyousoft_yhq.Model.WXBind model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO tbl_WeiXinBind( CustomerId , CustomerName , MobilePhone , OpenId , NickName , Sex , SubscribeTime , Country , Province , City , Language ) VALUES ( @CustomerId , @CustomerName , @MobilePhone , @OpenId , @NickName , @Sex , @SubscribeTime , @Country , @Province , @City , @LANGUAGE )");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "CustomerId", System.Data.DbType.String, model.CustomerId);
this._db.AddInParameter(cmd, "CustomerName", System.Data.DbType.String, model.CustomerName);
this._db.AddInParameter(cmd, "MobilePhone", System.Data.DbType.String, model.MobilePhone);
this._db.AddInParameter(cmd, "OpenId", System.Data.DbType.String, model.OpenId);
this._db.AddInParameter(cmd, "NickName", System.Data.DbType.String, model.NickName);
this._db.AddInParameter(cmd, "Sex", System.Data.DbType.String, model.Sex);
this._db.AddInParameter(cmd, "SubscribeTime", System.Data.DbType.String, model.SubscribeTime);
this._db.AddInParameter(cmd, "Province", System.Data.DbType.String, model.Province);
this._db.AddInParameter(cmd, "City", System.Data.DbType.String, model.City);
this._db.AddInParameter(cmd, "Language", System.Data.DbType.String, model.Language);
return(DbHelper.ExecuteSql(cmd, this._db));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="TypeID">产品类型编号</param>
/// <returns></returns>
public bool Delete(int[] TypeID)
{
StringBuilder Sql = new StringBuilder();
Sql.AppendFormat("SELECT COUNT(1) FROM dbo.tbl_Product WHERE ProductType IN({0})", Utils.GetSqlIdStrByArray(TypeID));
DbCommand EXcmd = this._db.GetSqlStringCommand(Sql.ToString());
bool result = DbHelper.Exists(EXcmd, this._db);
if (result)
{
return(false);
}
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(" DELETE FROM tbl_ProductType WHERE TypeID in ({0}) ", Utils.GetSqlIdStrByArray(TypeID));
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
