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