Пример #1
0
        /// <summary>
        /// 添加一条数据
        /// </summary>
        /// <param name="model">数据实体</param>
        /// <returns></returns>
        public int Add(Models.APP.Member model)
        {
            try
            {
                SqlParameter[] para =
                {
                    new SqlParameter("@username",      model.username),
                    new SqlParameter("@account",       model.account),
                    new SqlParameter("@pwd",           model.pwd),
                    new SqlParameter("@pic",           model.pic),
                    new SqlParameter("@name",          model.name),
                    new SqlParameter("@phon",          model.phon),
                    new SqlParameter("@sex",           model.sex),
                    new SqlParameter("@age",           model.age),
                    new SqlParameter("@city",          model.city),
                    new SqlParameter("@district",      model.district),
                    new SqlParameter("@address",       model.address),
                    new SqlParameter("@tp_pfid",       model.tp_pfid),
                    new SqlParameter("@tp_id",         model.tp_id),
                    new SqlParameter("@context",       model.context),
                    new SqlParameter("@isopen",        model.isopen),
                    new SqlParameter("@type",          model.type),
                    new SqlParameter("@ip",            model.ip),
                    new SqlParameter("@logintype",     model.logintype),
                    new SqlParameter("@loginnum",      model.loginnum),
                    new SqlParameter("@logintime",     model.logintime),
                    new SqlParameter("@openid",        model.openid),
                    new SqlParameter("@opentype",      model.opentype),
                    new SqlParameter("@datum",         model.datum),
                    new SqlParameter("@signnum",       model.signnum),
                    new SqlParameter("@sharenum",      model.sharenum),
                    new SqlParameter("@pushuserid",    model.pushuserid),
                    new SqlParameter("@pushchannelid", model.pushchannelid),
                    new SqlParameter("@m_valid",       model.m_valid)
                };
                StringBuilder cmdText = new StringBuilder();
                cmdText.Append(@"INSERT INTO App_Member(
			                        username
						            ,account
						            ,pwd
						            ,pic
						            ,name
						            ,phon
						            ,sex
						            ,age
                                    ,city
						            ,district
						            ,address
						            ,tp_pfid
						            ,tp_id
						            ,context
						            ,isopen
						            ,type
						            ,ip
						            ,logintype
						            ,loginnum
						            ,logintime
						            ,openid
						            ,opentype
						            ,datum
						            ,signnum
						            ,sharenum
						            ,pushuserid
						            ,pushchannelid
						            ,m_valid
						  ) VALUES(
									@username
									,@account
									,@pwd
									,@pic
									,@name
									,@phon
									,@sex
									,@age
                                    ,@city
									,@district
									,@address
									,@tp_pfid
									,@tp_id
									,@context
									,@isopen
									,@type
									,@ip
									,@logintype
									,@loginnum
									,@logintime
									,@openid
									,@opentype
									,@datum
									,@signnum
									,@sharenum
									,@pushuserid
									,@pushchannelid
									,@m_valid
					);SELECT @@Identity"                    );

                return(Convert.ToInt32(SqlHelper.ExecuteScalar(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, cmdText.ToString(), para)));
            }
            catch (ArgumentNullException ex)
            {
                logger.Error("调用方法Add()发生ArgumentNullException", ex);
            }
            catch (SqlException ex)
            {
                logger.Error("调用方法Add()发生SqlException", ex);
            }
            catch (Exception ex)
            {
                logger.Error("调用方法Add()发生Exception", ex);
            }
            return(-1);
        }
Пример #2
0
 /// <summary>
 /// 修改一个实体
 /// </summary>
 /// <param name="_entity"></param>
 /// <returns></returns>
 public int Update(Models.APP.Member model)
 {
     return(dal.Update(model));
 }
Пример #3
0
        /// <summary>
        /// 修改一个实体
        /// </summary>
        /// <param name="_entity"></param>
        /// <returns></returns>
        public int Update(Models.APP.Member model)
        {
            try
            {
                SqlParameter[] para =
                {
                    new SqlParameter("@m_id",          model.m_id),
                    new SqlParameter("@username",      model.username),
                    new SqlParameter("@account",       model.account),
                    new SqlParameter("@pwd",           model.pwd),
                    new SqlParameter("@pic",           model.pic),
                    new SqlParameter("@name",          model.name),
                    new SqlParameter("@phon",          model.phon),
                    new SqlParameter("@sex",           model.sex),
                    new SqlParameter("@age",           model.age),
                    new SqlParameter("@city",          model.city),
                    new SqlParameter("@district",      model.district),
                    new SqlParameter("@address",       model.address),
                    new SqlParameter("@tp_pfid",       model.tp_pfid),
                    new SqlParameter("@tp_id",         model.tp_id),
                    new SqlParameter("@context",       model.context),
                    new SqlParameter("@isopen",        model.isopen),
                    new SqlParameter("@type",          model.type),
                    new SqlParameter("@ip",            model.ip),
                    new SqlParameter("@logintype",     model.logintype),
                    new SqlParameter("@loginnum",      model.loginnum),
                    new SqlParameter("@logintime",     model.logintime),
                    new SqlParameter("@openid",        model.openid),
                    new SqlParameter("@opentype",      model.opentype),
                    new SqlParameter("@datum",         model.datum),
                    new SqlParameter("@signnum",       model.signnum),
                    new SqlParameter("@sharenum",      model.sharenum),
                    new SqlParameter("@pushuserid",    model.pushuserid),
                    new SqlParameter("@pushchannelid", model.pushchannelid),
                    new SqlParameter("@m_valid",       model.m_valid),
                    new SqlParameter("@modifytime",    model.modifytime)
                };

                StringBuilder cmdText = new StringBuilder();
                cmdText.Append(@"UPDATE [App_Member]
								SET [username]=@username
									   ,[account]=@account
							       ,[pwd]=@pwd
							       ,[pic]=@pic
							       ,[name]=@name
							       ,[phon]=@phon
							       ,[sex]=@sex
							       ,[age]=@age
                                   ,[city]=@city
                                   ,[district]=@district
							       ,[address]=@address
							       ,[tp_pfid]=@tp_pfid
							       ,[tp_id]=@tp_id
							       ,[context]=@context
							       ,[isopen]=@isopen
							       ,[type]=@type
							       ,[ip]=@ip
							       ,[logintype]=@logintype
							       ,[loginnum]=@loginnum
                                   ,[modifytime]=@modifytime
							       ,[logintime]=@logintime
							       ,[openid]=@openid
							       ,[opentype]=@opentype
							       ,[datum]=@datum
							       ,[signnum]=@signnum
							       ,[sharenum]=@sharenum
							       ,[pushuserid]=@pushuserid
							       ,[pushchannelid]=@pushchannelid
							       ,[m_valid]=@m_valid
							  WHERE [m_id]=@m_id"                            );
                return(SqlHelper.ExecuteNonQuery(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, cmdText.ToString(), para));
            }
            catch (ArgumentNullException ex)
            {
                logger.Error("调用方法Update()发生ArgumentNullException", ex);
            }
            catch (SqlException ex)
            {
                logger.Error("调用方法Update()发生SqlException", ex);
            }
            catch (Exception ex)
            {
                logger.Error("调用方法Update()发生Exception", ex);
            }
            return(-1);
        }
Пример #4
0
 /// <summary>
 /// 添加一条数据
 /// </summary>
 /// <param name="model">数据实体</param>
 /// <returns></returns>
 public int Add(Models.APP.Member model)
 {
     return(dal.Add(model));
 }