/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.Channel.ChannelSupplier model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into channelsupplier("); strSql.Append("typeid,suppid,userid,isopen,payrate)"); strSql.Append(" values ("); strSql.Append("@typeid,@suppid,@userid,@isopen,@payrate)"); SqlParameter[] parameters = { new SqlParameter("@typeid", SqlDbType.Int, 4), new SqlParameter("@suppid", SqlDbType.Int, 4), new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@isopen", SqlDbType.Bit, 1), new SqlParameter("@payrate", SqlDbType.Decimal, 9) }; parameters[0].Value = model.typeid; parameters[1].Value = model.suppid; parameters[2].Value = model.userid; parameters[3].Value = model.isopen; parameters[4].Value = model.payrate; int rows = DataBase.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
///// <summary> ///// 得到最大ID ///// </summary> //public int GetMaxId() //{ // return DbHelperSQL.GetMaxID("typeid", "channelsupplier"); //} ///// <summary> ///// 是否存在该记录 ///// </summary> //public bool Exists(int typeid, int suppid) //{ // StringBuilder strSql = new StringBuilder(); // strSql.Append("select count(1) from channelsupplier"); // strSql.Append(" where typeid=@typeid and suppid=@suppid "); // SqlParameter[] parameters = { // new SqlParameter("@typeid", SqlDbType.Int,4), // new SqlParameter("@suppid", SqlDbType.Int,4) }; // parameters[0].Value = typeid; // parameters[1].Value = suppid; // return DbHelperSQL.Exists(strSql.ToString(), parameters); //} public static bool Insert(Model.Channel.ChannelSupplier model) { SqlParameter[] parameters = { new SqlParameter("@typeid", SqlDbType.Int, 4), new SqlParameter("@suppid", SqlDbType.Int, 4), new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@isopen", SqlDbType.Bit, 1), new SqlParameter("@payrate", SqlDbType.Decimal, 9),new SqlParameter("@isdefault", SqlDbType.Bit, 1) }; parameters[0].Value = model.typeid; parameters[1].Value = model.suppid; parameters[2].Value = model.userid; parameters[3].Value = model.isopen; parameters[4].Value = model.payrate; parameters[5].Value = model.isdefault; int rows = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_channelsupplier_Insert", parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Channel.ChannelSupplier GetModel(int typeid, int suppid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 typeid,suppid,userid,isopen,payrate from channelsupplier "); strSql.Append(" where typeid=@typeid and suppid=@suppid "); SqlParameter[] parameters = { new SqlParameter("@typeid", SqlDbType.Int, 4), new SqlParameter("@suppid", SqlDbType.Int, 4) }; parameters[0].Value = typeid; parameters[1].Value = suppid; Model.Channel.ChannelSupplier model = new Model.Channel.ChannelSupplier(); DataSet ds = DataBase.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Channel.ChannelSupplier DataRowToModel(DataRow row) { Model.Channel.ChannelSupplier model = new Model.Channel.ChannelSupplier(); if (row != null) { if (row["typeid"] != null && row["typeid"].ToString() != "") { model.typeid = int.Parse(row["typeid"].ToString()); } if (row["suppid"] != null && row["suppid"].ToString() != "") { model.suppid = int.Parse(row["suppid"].ToString()); } if (row["userid"] != null && row["userid"].ToString() != "") { model.userid = int.Parse(row["userid"].ToString()); } if (row["isopen"] != null && row["isopen"].ToString() != "") { if ((row["isopen"].ToString() == "1") || (row["isopen"].ToString().ToLower() == "true")) { model.isopen = true; } else { model.isopen = false; } } if (row["payrate"] != null && row["payrate"].ToString() != "") { model.payrate = decimal.Parse(row["payrate"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Channel.ChannelSupplier model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update channelsupplier set "); strSql.Append("userid=@userid,"); strSql.Append("isopen=@isopen,"); strSql.Append("payrate=@payrate"); strSql.Append(" where typeid=@typeid and suppid=@suppid "); SqlParameter[] parameters = { new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@isopen", SqlDbType.Bit, 1), new SqlParameter("@payrate", SqlDbType.Decimal, 9), new SqlParameter("@typeid", SqlDbType.Int, 4), new SqlParameter("@suppid", SqlDbType.Int, 4) }; parameters[0].Value = model.userid; parameters[1].Value = model.isopen; parameters[2].Value = model.payrate; parameters[3].Value = model.typeid; parameters[4].Value = model.suppid; int rows = DataBase.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }