/// <summary> /// 添加一条数据 /// </summary> /// <param name="model">数据实体</param> /// <returns></returns> public int Add(Models.APP.Type model) { try { SqlParameter[] para = { new SqlParameter("@text", model.text), new SqlParameter("@Anpic", model.Anpic), new SqlParameter("@AnIsHomepic", model.AnIsHomepic), new SqlParameter("@AnHomepic", model.AnHomepic), new SqlParameter("@AnWhitepic", model.AnWhitepic), new SqlParameter("@AnOrangepic", model.AnOrangepic), new SqlParameter("@AnIsAllpic", model.AnIsAllpic), new SqlParameter("@AnAllpic", model.AnAllpic), new SqlParameter("@Anpicguanfang", model.Anpicguanfang), new SqlParameter("@Anpicminjian", model.Anpicminjian), new SqlParameter("@Iospic", model.Iospic), new SqlParameter("@IosIsHomepic", model.IosIsHomepic), new SqlParameter("@IosHomepic", model.IosHomepic), new SqlParameter("@IosWhitepic", model.IosWhitepic), new SqlParameter("@IosOrangepic", model.IosOrangepic), new SqlParameter("@IosIsAllpic", model.IosIsAllpic), new SqlParameter("@IosAllpic", model.IosAllpic), new SqlParameter("@Iospicguanfang", model.Iospicguanfang), new SqlParameter("@Iospicminjian", model.Iospicminjian), new SqlParameter("@type", model.type), new SqlParameter("@sort", model.sort), new SqlParameter("@createtime", model.createtime), new SqlParameter("@modifytime", model.modifytime), new SqlParameter("@userid", model.userid), new SqlParameter("@muserid", model.muserid), new SqlParameter("@tdisabled", model.tdisabled) }; StringBuilder cmdText = new StringBuilder(); cmdText.Append(@"INSERT INTO App_Type( text ,Anpic ,AnIsHomepic ,AnHomepic ,AnWhitepic ,AnOrangepic ,AnIsAllpic ,AnAllpic ,Anpicguanfang ,Anpicminjian ,Iospic ,IosIsHomepic ,IosHomepic ,IosWhitepic ,IosOrangepic ,IosIsAllpic ,IosAllpic ,Iospicguanfang ,Iospicminjian ,type ,sort ,createtime ,modifytime ,userid ,muserid,tdisabled ) VALUES( @text ,@Anpic ,@AnIsHomepic ,@AnHomepic ,@AnWhitepic ,@AnOrangepic ,@AnIsAllpic ,@AnAllpic ,@Anpicguanfang ,@Anpicminjian ,@Iospic ,@IosIsHomepic ,@IosHomepic ,@IosWhitepic ,@IosOrangepic ,@IosIsAllpic ,@IosAllpic ,@Iospicguanfang ,@Iospicminjian ,@type ,@sort ,@createtime ,@modifytime ,@userid ,@muserid,@tdisabled )" ); 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.Type model) { return(dal.Update(model)); }
/// <summary> /// 修改一个实体 /// </summary> /// <param name="_entity"></param> /// <returns></returns> public int Update(Models.APP.Type model) { try { SqlParameter[] para = { new SqlParameter("@t_id", model.t_id), new SqlParameter("@text", model.text), new SqlParameter("@Anpic", model.Anpic), new SqlParameter("@AnIsHomepic", model.AnIsHomepic), new SqlParameter("@AnHomepic", model.AnHomepic), new SqlParameter("@AnWhitepic", model.AnWhitepic), new SqlParameter("@AnOrangepic", model.AnOrangepic), new SqlParameter("@AnIsAllpic", model.AnIsAllpic), new SqlParameter("@AnAllpic", model.AnAllpic), new SqlParameter("@Anpicguanfang", model.Anpicguanfang), new SqlParameter("@Anpicminjian", model.Anpicminjian), new SqlParameter("@Iospic", model.Iospic), new SqlParameter("@IosIsHomepic", model.IosIsHomepic), new SqlParameter("@IosHomepic", model.IosHomepic), new SqlParameter("@IosWhitepic", model.IosWhitepic), new SqlParameter("@IosOrangepic", model.IosOrangepic), new SqlParameter("@IosIsAllpic", model.IosIsAllpic), new SqlParameter("@IosAllpic", model.IosAllpic), new SqlParameter("@Iospicguanfang", model.Iospicguanfang), new SqlParameter("@Iospicminjian", model.Iospicminjian), new SqlParameter("@type", model.type), new SqlParameter("@sort", model.sort), new SqlParameter("@createtime", model.createtime), new SqlParameter("@modifytime", model.modifytime), new SqlParameter("@userid", model.userid), new SqlParameter("@muserid", model.muserid) }; StringBuilder cmdText = new StringBuilder(); cmdText.Append(@"UPDATE [App_Type] SET [text]=@text ,[Anpic]=@Anpic ,[AnIsHomepic]=@AnIsHomepic ,[AnHomepic]=@AnHomepic ,[AnWhitepic]=@AnWhitepic ,[AnOrangepic]=@AnOrangepic ,[AnIsAllpic]=@AnIsAllpic ,[AnAllpic]=@AnAllpic ,[Anpicguanfang]=@Anpicguanfang ,[Anpicminjian]=@Anpicminjian ,[Iospic]=@Iospic ,[IosIsHomepic]=@IosIsHomepic ,[IosHomepic]=@IosHomepic ,[IosWhitepic]=@IosWhitepic ,[IosOrangepic]=@IosOrangepic ,[IosIsAllpic]=@IosIsAllpic ,[IosAllpic]=@IosAllpic ,[Iospicguanfang]=@Iospicguanfang ,[Iospicminjian]=@Iospicminjian ,[type]=@type ,[sort]=@sort ,[createtime]=@createtime ,[modifytime]=@modifytime ,[userid]=@userid ,[muserid]=@muserid WHERE [t_id]=@t_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.Type model) { return(dal.Add(model)); }