/// <summary> /// 添加一条数据 /// </summary> /// <param name="model">数据实体</param> /// <returns></returns> public int Add(Models.APP.About model) { try { SqlParameter[] para = { new SqlParameter("@title", model.title), new SqlParameter("@context", model.context), new SqlParameter("@tp_id", model.tp_id), new SqlParameter("@begintime", model.begintime), new SqlParameter("@contact", model.contact), new SqlParameter("@phone", model.phone), new SqlParameter("@praise", model.praise), new SqlParameter("@number", model.number), new SqlParameter("@numberlimit", model.numberlimit), new SqlParameter("@age", model.age), new SqlParameter("@sex", model.sex), new SqlParameter("@address", model.address), new SqlParameter("@province", model.province), new SqlParameter("@city", model.city), new SqlParameter("@district", model.district), new SqlParameter("@state", model.state), new SqlParameter("@specifictime", model.specifictime), new SqlParameter("@createtime", model.createtime), new SqlParameter("@modifytime", model.modifytime), new SqlParameter("@userid", model.userid), new SqlParameter("@muserid", model.muserid), new SqlParameter("@pic", model.pic), new SqlParameter("@other", model.other) }; StringBuilder cmdText = new StringBuilder(); cmdText.Append(@"INSERT INTO App_About( title ,context ,tp_id ,begintime ,contact ,phone ,praise ,number ,numberlimit ,age ,sex ,address ,province ,city ,district ,state ,specifictime ,createtime ,modifytime ,userid ,muserid ,pic ,other ) VALUES( @title ,@context ,@tp_id ,@begintime ,@contact ,@phone ,@praise ,@number ,@numberlimit ,@age ,@sex ,@address ,@province ,@city ,@district ,@state ,@specifictime ,@createtime ,@modifytime ,@userid ,@muserid ,@pic ,@other )" ); return(SqlHelper.ExecuteNonQuery(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); }
/// <summary> /// 修改一个实体 /// </summary> /// <param name="_entity"></param> /// <returns></returns> public int Update(Models.APP.About model) { return(dal.Update(model)); }
/// <summary> /// 修改一个实体 /// </summary> /// <param name="_entity"></param> /// <returns></returns> public int Update(Models.APP.About model) { try { SqlParameter[] para = { new SqlParameter("@ab_id", model.ab_id), new SqlParameter("@title", model.title), new SqlParameter("@context", model.context), new SqlParameter("@tp_id", model.tp_id), new SqlParameter("@begintime", model.begintime), new SqlParameter("@contact", model.contact), new SqlParameter("@phone", model.phone), new SqlParameter("@praise", model.praise), new SqlParameter("@number", model.number), new SqlParameter("@numberlimit", model.numberlimit), new SqlParameter("@age", model.age), new SqlParameter("@sex", model.sex), new SqlParameter("@address", model.address), new SqlParameter("@province", model.province), new SqlParameter("@city", model.city), new SqlParameter("@district", model.district), new SqlParameter("@state", model.state), new SqlParameter("@specifictime", model.specifictime), new SqlParameter("@createtime", model.createtime), new SqlParameter("@modifytime", model.modifytime), new SqlParameter("@userid", model.userid), new SqlParameter("@muserid", model.muserid), new SqlParameter("@pic", model.pic), new SqlParameter("@other", model.other) }; StringBuilder cmdText = new StringBuilder(); cmdText.Append(@"UPDATE [App_About] SET [title]=@title ,[context]=@context ,[tp_id]=@tp_id ,[begintime]=@begintime ,[contact]=@contact ,[phone]=@phone ,[praise]=@praise ,[number]=@number ,[numberlimit]=@numberlimit ,[age]=@age ,[sex]=@sex ,[address]=@address ,[province]=@province ,[city]=@city ,[district]=@district ,[state]=@state ,[specifictime]=@specifictime ,[createtime]=@createtime ,[modifytime]=@modifytime ,[userid]=@userid ,[muserid]=@muserid ,[pic]=@pic ,[other]=@other WHERE [ab_id]=@ab_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); }
/// <summary> /// 添加一条数据 /// </summary> /// <param name="model">数据实体</param> /// <returns></returns> public int Add(Models.APP.About model) { return(dal.Add(model)); }