• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# Eyousoft_yhq类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中Eyousoft_yhq的典型用法代码示例。如果您正苦于以下问题:C# Eyousoft_yhq类的具体用法?C# Eyousoft_yhq怎么用?C# Eyousoft_yhq使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



Eyousoft_yhq类属于命名空间,在下文中一共展示了Eyousoft_yhq类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: AddSysDistrict

 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool AddSysDistrict(Eyousoft_yhq.Model.MSysDistrict model)
 {
     if (model != null && model.ProvinceId > 0 && model.CityId > 0 && !string.IsNullOrEmpty(model.Name))
         return dal.AddSysDistrict(model);
     else
         return false;
 }
开发者ID:uwitec,项目名称:O2O,代码行数:10,代码来源:AreaInfo.cs


示例2: Add

 /// <summary>
 ///  增加一条数据
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public int Add(Eyousoft_yhq.Model.Order model)
 {
     model.OrderID = Guid.NewGuid().ToString();
     if (string.IsNullOrEmpty(model.MemberID) ||
         string.IsNullOrEmpty(model.ProductID)) return 0;
     return dal.Add(model);
 }
开发者ID:uwitec,项目名称:O2O,代码行数:12,代码来源:Order.cs


示例3: AddSysProvince

 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool AddSysProvince(Eyousoft_yhq.Model.MSysProvince model)
 {
     if (model != null && !string.IsNullOrEmpty(model.Name))
         return dal.AddSysProvince(model);
     else
         return false;
 }
开发者ID:uwitec,项目名称:O2O,代码行数:10,代码来源:AreaInfo.cs


示例4: AddSysCountry

 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool AddSysCountry(Eyousoft_yhq.Model.MSysCountry model)
 {
     if (model != null && !string.IsNullOrEmpty(model.CnName))
         return dal.AddSysCountry(model);
     else
         return false;
 }
开发者ID:uwitec,项目名称:O2O,代码行数:10,代码来源:AreaInfo.cs


示例5: Add

        /// <summary>
        /// 注册用户/添加用户
        /// </summary>
        /// <param name="model">用户实体/管理员实体</param>
        /// <returns></returns>
        public bool Add(Eyousoft_yhq.Model.User model)
        {
            StringBuilder strSqlExists = new StringBuilder();
            strSqlExists.Append("select count(1) from tbl_Member");
            strSqlExists.Append(" where [email protected] ");

            DbCommand cmdExists = this._db.GetSqlStringCommand(strSqlExists.ToString());
            this._db.AddInParameter(cmdExists, "PollCode", System.Data.DbType.String, model.PollCode);

            if (!DbHelper.Exists(cmdExists, this._db))
            {
                model.PollCode = "";
            }

            StringBuilder strSql = new StringBuilder();

            strSql.Append("  INSERT INTO tbl_Member([UserID],[UserName],[UserPwd],[ContactName],[ContactSex],[Remark],[IssueTime],[PollCode],[IsAgent],[YuE]  )		VALUES (@UserID,@UserName,@UserPwd,@ContactName,@ContactSex,@Remark,@IssueTime,@PollCode,@IsAgent,@YuE) ");

            DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
            this._db.AddInParameter(cmd, "UserID", System.Data.DbType.AnsiStringFixedLength, model.UserID);
            this._db.AddInParameter(cmd, "UserName", System.Data.DbType.String, model.UserName);
            this._db.AddInParameter(cmd, "UserPwd", System.Data.DbType.String, model.UserPwd);
            this._db.AddInParameter(cmd, "ContactName", System.Data.DbType.String, model.ContactName);
            this._db.AddInParameter(cmd, "ContactSex", System.Data.DbType.Byte, (int)model.ContactSex);
            this._db.AddInParameter(cmd, "Remark", System.Data.DbType.String, model.Remark);
            this._db.AddInParameter(cmd, "IssueTime", System.Data.DbType.DateTime, model.IssueTime);
            this._db.AddInParameter(cmd, "PollCode", System.Data.DbType.String, model.PollCode);
            this._db.AddInParameter(cmd, "IsAgent", System.Data.DbType.Byte, GetBooleanToStr(model.IsAgent));
            this._db.AddInParameter(cmd, "YuE", System.Data.DbType.Decimal, model.YuE);

            return DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false;
        }
开发者ID:uwitec,项目名称:O2O,代码行数:37,代码来源:DMember.cs


示例6: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Eyousoft_yhq.Model.User model)
        {
            model.UserID = Guid.NewGuid().ToString();
            bool result = dal.Add(model);
            if (result) new Eyousoft_yhq.BLL.Login().isLogin(model.UserName, model.UserPwd);

            return result;
        }
开发者ID:uwitec,项目名称:O2O,代码行数:11,代码来源:Member.cs


示例7: GetList

        /// <summary>
        /// 返回分页列表
        /// </summary>
        /// <param name="PageSize"></param>
        /// <param name="PageIndex"></param>
        /// <param name="RecordCount"></param>
        /// <param name="serModel"></param>
        /// <returns></returns>
        public IList<Eyousoft_yhq.Model.GYSticket> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.GysTicketSer serModel)
        {
            IList<Eyousoft_yhq.Model.GYSticket> list = new List<Eyousoft_yhq.Model.GYSticket>();

            string tableName = "GYSTicket";
            string fileds = "  ID  , CusName  , CusSex  , CusMob  , PlaneTicket  , IssueTime  , Remark, OpertorID,OrderState,TicketState ";
            string orderByString = "IssueTime desc";

            StringBuilder query = new StringBuilder();
            query.Append(" 1=1  ");

            if (serModel != null)
            {
                if (!string.IsNullOrEmpty(serModel.OpertorID))
                {
                    query.AppendFormat(" and  OpertorID =  '{0}' ", serModel.OpertorID);
                }
                if (!string.IsNullOrEmpty(serModel.cusName))
                {
                    query.AppendFormat(" and  CusName  LIKE  '%{0}%' ", serModel.cusName);
                }
                if (!string.IsNullOrEmpty(serModel.cusMob))
                {
                    query.AppendFormat(" and  CusMob  LIKE  '%{0}%' ", serModel.cusMob);
                }
                if (!string.IsNullOrEmpty(serModel.tickNO))
                {
                    query.AppendFormat(" and  PlaneTicket  LIKE  '%{0}%' ", serModel.tickNO);
                }
            }

            using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
            {
                while (dr.Read())
                {

                    Eyousoft_yhq.Model.GYSticket model = new Eyousoft_yhq.Model.GYSticket();
                    model.ID = dr.GetString(dr.GetOrdinal("ID")); ;
                    model.CusName = dr.GetString(dr.GetOrdinal("CusName"));
                    model.CusSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("CusSex"));
                    model.CusMob = dr.GetString(dr.GetOrdinal("CusMob"));
                    model.PlaneTicket = dr.GetString(dr.GetOrdinal("PlaneTicket"));
                    model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
                    model.Remark = dr.GetString(dr.GetOrdinal("Remark"));
                    model.OpertorID = dr.GetString(dr.GetOrdinal("OpertorID"));
                    model.orderState = (Eyousoft_yhq.Model.TickOrderState)dr.GetByte(dr.GetOrdinal("OrderState"));
                    model.payState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("TicketState"));

                    list.Add(model);
                }
            }
            return list;
        }
开发者ID:uwitec,项目名称:O2O,代码行数:61,代码来源:GYSticket.cs


示例8: Add

 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool Add(Eyousoft_yhq.Model.Product model)
 {
     model.ProductID = Guid.NewGuid().ToString();
     if (model.AttachList != null && model.AttachList.Count > 0)
     {
         for (int i = 0; i < model.AttachList.Count; i++)
         {
             model.AttachList[i].ItemId = model.ProductID;
         }
     }
     return dal.Add(model);
 }
开发者ID:uwitec,项目名称:O2O,代码行数:15,代码来源:Product.cs


示例9: Add

        /// <summary>
        ///  增加一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Add(Eyousoft_yhq.Model.MYuYue model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("INSERT INTO tbl_YuYue (YYRoute ,YYName ,YYMobile ,YYInfo ) VALUES (@YYRoute ,@YYName ,@YYMobile ,@YYInfo )");
            DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
            this._db.AddInParameter(cmd, "YYRoute", System.Data.DbType.String, model.YYRoute);
            this._db.AddInParameter(cmd, "YYName", System.Data.DbType.String, model.YYRoute);
            this._db.AddInParameter(cmd, "YYMobile", System.Data.DbType.String, model.YYMobile);
            this._db.AddInParameter(cmd, "YYInfo", System.Data.DbType.String, model.YYInfo);

            return DbHelper.ExecuteSql(cmd, this._db);
        }
开发者ID:uwitec,项目名称:O2O,代码行数:18,代码来源:DYuYue.cs


示例10: AddSysCity

 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool AddSysCity(Eyousoft_yhq.Model.MSysCity model)
 {
     string StrSql = "INSERT INTO tbl_SysCity(ProvinceId,Name,CenterCityId,HeaderLetter,IsSite,DomainName,IsEnabled) VALUES(@ProvinceId,@Name,@CenterCityId,@HeaderLetter,@IsSite,@DomainName,@IsEnabled)";
     DbCommand dc = this._db.GetSqlStringCommand(StrSql);
     this._db.AddInParameter(dc, "ProvinceId", DbType.Int32, model.ProvinceId);
     this._db.AddInParameter(dc, "Name", DbType.String, model.Name);
     this._db.AddInParameter(dc, "CenterCityId", DbType.Int32, model.CenterCityId);
     this._db.AddInParameter(dc, "HeaderLetter", DbType.String, model.HeaderLetter);
     this._db.AddInParameter(dc, "IsSite", DbType.AnsiStringFixedLength, this.GetBooleanToStr(model.IsSite));
     this._db.AddInParameter(dc, "DomainName", DbType.String, model.DomainName);
     this._db.AddInParameter(dc, "IsEnabled", DbType.AnsiStringFixedLength, this.GetBooleanToStr(model.IsEnabled));
     return DbHelper.ExecuteSql(dc, this._db) > 0 ? true : false;
 }
开发者ID:uwitec,项目名称:O2O,代码行数:16,代码来源:AreaInfo.cs


示例11: Add

        /// <summary>
        ///  增加一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Add(Eyousoft_yhq.Model.CustomMsg model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("INSERT INTO tbl_Recommend (OpenId ,NickName ,Sex ,CommendInfo ) VALUES (@OpenId ,@NickName ,@Sex ,@CommendInfo )");

            DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
            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, "CommendInfo", System.Data.DbType.String, model.CommendInfo);

            return DbHelper.ExecuteSql(cmd, this._db);
        }
开发者ID:uwitec,项目名称:O2O,代码行数:19,代码来源:DCustomMsg.cs


示例12: GetList

        /// <summary>
        /// 获取保险编号
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public IList<MPlanIns> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MPlanInsSer serModel)
        {
            IList<Eyousoft_yhq.Model.MPlanIns> list = new List<Eyousoft_yhq.Model.MPlanIns>();

            string tableName = "tbl_PlantIns";

            string fileds = " * ";

            string orderByString = " IssueTime desc ";

            StringBuilder query = new StringBuilder();
            query.Append(" 1=1");

            if (serModel != null)
            {
                if (!string.IsNullOrEmpty(serModel.OperatorID))
                {
                    query.AppendFormat(" and  OperatorID='{0}'  ", serModel.OperatorID);
                }

            }

            using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
            {

                while (dr.Read())
                {
                    Eyousoft_yhq.Model.MPlanIns model = new Eyousoft_yhq.Model.MPlanIns();

                    model.ID = dr.GetInt32(dr.GetOrdinal("ID"));
                    model.InsMoney = dr.GetDecimal(dr.GetOrdinal("InsMoney"));
                    model.InsName = dr.GetString(dr.GetOrdinal("InsName"));
                    model.InsNO = dr.GetString(dr.GetOrdinal("InsNO"));
                    model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
                    model.LinkAddress = dr.GetString(dr.GetOrdinal("LinkAddress"));
                    model.LinkMail = dr.GetString(dr.GetOrdinal("LinkMail"));
                    model.LinkTel = dr.GetString(dr.GetOrdinal("LinkTel"));
                    model.OperatorID = dr.GetString(dr.GetOrdinal("OperatorID"));
                    model.OperatorName = dr.GetString(dr.GetOrdinal("OperatorName"));
                    model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode"));
                    model.OrderID = dr.GetString(dr.GetOrdinal("OrderID"));
                    model.PlantID = dr.GetString(dr.GetOrdinal("PlantID"));
                    model.PolicTor = dr.GetString(dr.GetOrdinal("PolicTor"));
                    model.State = (InsState)dr.GetByte(dr.GetOrdinal("State"));

                    list.Add(model);
                }
            }
            return list;
        }
开发者ID:uwitec,项目名称:O2O,代码行数:55,代码来源:DPlanIns.cs


示例13: Add

        /// <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;
        }
开发者ID:uwitec,项目名称:O2O,代码行数:20,代码来源:Comment.cs


示例14: GetWeiDianChanPins

        /// <summary>
        /// 获取微店产品信息集合
        /// </summary>
        /// <param name="weiDianId">微店编号</param>
        /// <param name="chaXun">查询</param>
        /// <returns></returns>
        public IList<Eyousoft_yhq.Model.MWeiDianChanPinInfo> GetWeiDianChanPins(string weiDianId,Eyousoft_yhq.Model.MWeiDianChanPinChaXunInfo chaXun)
        {
            IList<Eyousoft_yhq.Model.MWeiDianChanPinInfo> items = new List<Eyousoft_yhq.Model.MWeiDianChanPinInfo>();
            var sql = new StringBuilder();
            sql.AppendFormat("SELECT * FROM view_WeiDian_ChanPin WHERE [WeiDianId]='{0}' ", weiDianId);

            if (chaXun != null)
            {
                if (chaXun.ChanPinLeiXing.HasValue)
                {
                    sql.AppendFormat(" AND ChanPinLeiXing={0} ", chaXun.ChanPinLeiXing.Value);
                }

                if (!string.IsNullOrEmpty(chaXun.ChanPinName))
                {
                    sql.AppendFormat(" AND ChanPinName LIKE '%{0}%' ", chaXun.ChanPinName);
                }
            }

            sql.AppendFormat(" ORDER BY IssueTime DESC ");

            var cmd = _db.GetSqlStringCommand(sql.ToString());

            using (var rdr = DbHelper.ExecuteReader(cmd, _db))
            {
                while (rdr.Read())
                {
                    var item = new Eyousoft_yhq.Model.MWeiDianChanPinInfo();
                    item.ChanPinId = rdr["ChanPinId"].ToString();
                    item.ChanPinName = rdr["ChanPinName"].ToString();
                    item.ChanPinTuPianFilepath = rdr["ChanPinTuPianFilepath"].ToString();
                    item.GuanXiId = rdr.GetInt32(rdr.GetOrdinal("IdentityId"));
                    item.HuiYuanId = rdr["HuiYuanId"].ToString();
                    item.TianJiaTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
                    item.WeiDianId = rdr["WeiDianId"].ToString();

                    item.ShiChangJiaGe = rdr.GetDecimal(rdr.GetOrdinal("ShiChangJiaGe"));
                    item.JieSuanJiaGe = rdr.GetDecimal(rdr.GetOrdinal("JieSuanJiaGe"));
                    if (!rdr.IsDBNull(rdr.GetOrdinal("ChuTuanRiQi"))) item.ChuTuanRiQi = rdr.GetDateTime(rdr.GetOrdinal("ChuTuanRiQi"));
                    item.IsTianTianFaTuan = rdr["IsTianTianFaTuan"].ToString() == "1";
                    item.PingLunJiShu = rdr.GetInt32(rdr.GetOrdinal("PingLunJiShu"));

                    items.Add(item);
                }
            }

            return items;
        }
开发者ID:uwitec,项目名称:O2O,代码行数:54,代码来源:DWeiDian.cs


示例15: Add

        /// <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;
        }
开发者ID:uwitec,项目名称:O2O,代码行数:21,代码来源:SendMsg.cs


示例16: Add

        /// <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;
        }
开发者ID:uwitec,项目名称:O2O,代码行数:23,代码来源:DJiPiaoBaoCun.cs


示例17: AddOrder

        protected bool AddOrder(string Pid, object OrderstateDown, decimal Price, out  Eyousoft_yhq.Model.Order order)
        {
            Eyousoft_yhq.BLL.Order OrderBll = new Eyousoft_yhq.BLL.Order();
            var MemberModel = EyouSoft.Common.Page.HuiyuanPage.GetUserInfo();

            int peopole = Utils.GetInt(Utils.GetQueryStringValue("renshu"), 1);

            if (MemberModel != null)
            {
                Eyousoft_yhq.Model.Order OrderModel = new Eyousoft_yhq.Model.Order()
                {
                    OrderID = Guid.NewGuid().ToString(),
                    ProductID = Pid,
                    MemberID = MemberModel.UserID,
                    MemberTel = MemberModel.UserName,
                    MemberName = MemberModel.ContactName,
                    MemberSex = MemberModel.ContactSex,
                    OrderState = (Eyousoft_yhq.Model.OrderState)OrderstateDown,
                    PayState = Eyousoft_yhq.Model.PaymentState.未支付,
                    IsCheck = true,
                    ConfirmCode = "",
                    Remark = "",
                    OrderPrice = Price * peopole,
                    PeopleNum = peopole
                };
                OrderModel.WeiDianId = Utils.GetQueryStringValue("weidianid");
                int num = OrderBll.Add(OrderModel);
                if (num > 0)
                {
                    order = OrderModel;
                    return true;
                }
                else
                {
                    order = OrderModel;
                    return false;
                }
            }
            else
            {
                order = new Eyousoft_yhq.Model.Order();
                return false;
            }
        }
开发者ID:uwitec,项目名称:O2O,代码行数:44,代码来源:ajaxDownOrder.aspx.cs


示例18: Add

        /// <summary>
        /// 车票/景点门票添加
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Add(Eyousoft_yhq.Model.GYSticket model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("  INSERT INTO GYSTicket  (ID,CusName,CusSex,CusMob,PlaneTicket,IssueTime,Remark,OpertorID,OrderState,TicketState) VALUES (@ID,@CusName,@CusSex,@CusMob,@PlaneTicket,@IssueTime,@Remark,@OpertorID,@OrderState,@TicketState) ");

            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;
        }
开发者ID:uwitec,项目名称:O2O,代码行数:25,代码来源:GYSticket.cs


示例19: GetModelList

        /// <summary>
        /// 获取分页数据
        /// </summary>
        /// <param name="PageSize"></param>
        /// <param name="PageIndex"></param>
        /// <param name="RecordCount"></param>
        /// <param name="serModel"></param>
        /// <returns></returns>
        public IList<Eyousoft_yhq.Model.MConDetaile> GetModelList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MConDetaile serModel)
        {
            IList<Eyousoft_yhq.Model.MConDetaile> list = new List<Eyousoft_yhq.Model.MConDetaile>();

            string tableName = "tbl_ConDetailed";
            string fileds = " ID,HuiYuanID,(select UserName from tbl_Member where UserId=tbl_ConDetailed.HuiYuanID ) as HuiYuanName, JiaoYiHao ,JinE ,JiaoYiShiJian, XiaoFeiFangShi ,DingDanBianHao ,JiaoYiDuiXiang,(select UserName from tbl_Member where UserId=tbl_ConDetailed.JiaoYiDuiXiang ) as DXName, DingDanLeiBie ";
            string orderByString = "JiaoYiShiJian desc ";

            StringBuilder query = new StringBuilder();
            query.AppendFormat(" 1=1 ");

            if (serModel != null)
            {

            }

            using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
            {
                while (dr.Read())
                {
                    Eyousoft_yhq.Model.MConDetaile model = new Eyousoft_yhq.Model.MConDetaile();
                    model.ID = dr.GetInt32(dr.GetOrdinal("ID"));
                    model.HuiYuanID = dr.GetString(dr.GetOrdinal("HuiYuanID"));
                    model.HuiYuanName = dr.GetString(dr.GetOrdinal("HuiYuanName"));

                    model.JiaoYiHao = dr.GetString(dr.GetOrdinal("JiaoYiHao"));
                    model.JinE = dr.GetDecimal(dr.GetOrdinal("JinE"));
                    model.JiaoYiShiJian = dr.GetDateTime(dr.GetOrdinal("JiaoYiShiJian"));
                    model.XFway = (Eyousoft_yhq.Model.XFfangshi)dr.GetByte(dr.GetOrdinal("XiaoFeiFangShi"));

                    model.DingDanBianHao = dr.GetString(dr.GetOrdinal("DingDanBianHao"));
                    model.DuiXiangName = dr.IsDBNull(dr.GetOrdinal("DXName")) ? "" : dr.GetString(dr.GetOrdinal("DXName"));
                    model.DDCarrtes = (Eyousoft_yhq.Model.DDleibie)dr.GetByte(dr.GetOrdinal("DingDanLeiBie"));

                    list.Add(model);
                }
            }
            return list;
        }
开发者ID:uwitec,项目名称:O2O,代码行数:47,代码来源:DConDetaile.cs


示例20: GetList

        /// <summary>
        /// 获取分页列表
        /// </summary>
        /// <param name="PageSize"></param>
        /// <param name="PageIndex"></param>
        /// <param name="RecordCount"></param>
        /// <param name="serModel"></param>
        /// <returns></returns>
        public IList<Eyousoft_yhq.Model.MYuYue> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MYuYueSer serModel)
        {
            IList<Eyousoft_yhq.Model.MYuYue> list = new List<Eyousoft_yhq.Model.MYuYue>();

            string tableName = "tbl_YuYue";

            string fileds = " * ";

            string orderByString = " YYTime desc ";

            StringBuilder query = new StringBuilder();
            query.Append(" 1=1 ");

            if (serModel != null)
            {

            }

            using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
            {

                while (dr.Read())
                {
                    Eyousoft_yhq.Model.MYuYue model = new Eyousoft_yhq.Model.MYuYue();

                    model.YYID = dr.GetInt32(dr.GetOrdinal("YYID"));

                    model.YYRoute = dr.IsDBNull(dr.GetOrdinal("YYRoute")) ? "" : dr.GetString(dr.GetOrdinal("YYRoute"));
                    model.YYName = dr.IsDBNull(dr.GetOrdinal("YYName")) ? "" : dr.GetString(dr.GetOrdinal("YYName"));
                    model.YYMobile = dr.IsDBNull(dr.GetOrdinal("YYMobile")) ? "" : dr.GetString(dr.GetOrdinal("YYMobile"));
                    model.YYInfo = dr.IsDBNull(dr.GetOrdinal("YYInfo")) ? "" : dr.GetString(dr.GetOrdinal("YYInfo"));

                    model.YYTime = dr.GetDateTime(dr.GetOrdinal("YYTime"));
                    list.Add(model);
                }
            };
            return list;
        }
开发者ID:uwitec,项目名称:O2O,代码行数:46,代码来源:DYuYue.cs



注:本文中的Eyousoft_yhq类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# FALibrary类代码示例发布时间:2022-05-24
下一篇:
C# Eye类代码示例发布时间:2022-05-24
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap