/// <summary>
/// 得到一个对象实体 by SQLpara
/// </summary>
public Lebi_Supplier_Config GetModel(SQLPara para)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from [Lebi_Supplier_Config] ");
if (para.Where != "")
{
strSql.Append(" where " + para.Where + "");
}
Lebi_Supplier_Config model = new Lebi_Supplier_Config();
DataSet ds = SqlUtils.SqlUtilsInstance.TextExecuteDataset(strSql.ToString(), para.Para);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
model.Value = ds.Tables[0].Rows[0]["Value"].ToString();
if (ds.Tables[0].Rows[0]["Supplier_id"].ToString() != "")
{
model.Supplier_id = int.Parse(ds.Tables[0].Rows[0]["Supplier_id"].ToString());
}
return(model);
}
else
{
return(null);
}
}
public bool SaveConfig(BaseConfig_Supplier model, int Supplier_id)
{
//return SerializationHelper.Save(model, this.xmlpath);
Type type = model.GetType();
Lebi_Supplier_Config cf;
foreach (System.Reflection.PropertyInfo p in type.GetProperties())
{
if (p.GetValue(model, null) == null)
{
continue;
}
cf = B_Lebi_Supplier_Config.GetModel("Supplier_id = " + Supplier_id + " and Name='" + p.Name + "'");
if (cf == null)
{
cf = new Lebi_Supplier_Config();
cf.Name = p.Name;
cf.Value = p.GetValue(model, null).ToString();
cf.Supplier_id = Supplier_id;
B_Lebi_Supplier_Config.Add(cf);
}
else
{
cf.Name = p.Name;
cf.Value = p.GetValue(model, null).ToString();
B_Lebi_Supplier_Config.Update(cf);
}
}
ShopCache.SetBaseConfig(Supplier_id);//更新缓存
return(true);
}
/// <summary>
/// 得到一个对象实体 by id
/// </summary>
public Lebi_Supplier_Config GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from [Lebi_Supplier_Config] ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Lebi_Supplier_Config model = new Lebi_Supplier_Config();
DataSet ds = SqlUtils.SqlUtilsInstance.TextExecuteDataset(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
model.Value = ds.Tables[0].Rows[0]["Value"].ToString();
if (ds.Tables[0].Rows[0]["Supplier_id"].ToString() != "")
{
model.Supplier_id = int.Parse(ds.Tables[0].Rows[0]["Supplier_id"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Lebi_Supplier_Config model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Lebi_Supplier_Config](");
strSql.Append("Name,Value,Supplier_id)");
strSql.Append(" values (");
strSql.Append("@Name,@Value,@Supplier_id)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", model.Name),
new SqlParameter("@Value", model.Value),
new SqlParameter("@Supplier_id", model.Supplier_id)
};
object obj = SqlUtils.SqlUtilsInstance.TextExecuteNonQuery(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 获取一个设置值
/// </summary>
/// <param name="key"></param>
/// <returns></returns>
public static string Get(string key)
{
Lebi_Supplier_Config conf = B_Lebi_Supplier_Config.GetModel("Name='" + key + "'");
if (conf == null)
{
return("");
}
return(conf.Value);
}
/// <summary>
/// 安全方式绑定对象表单
/// </summary>
public Lebi_Supplier_Config SafeBindForm(Lebi_Supplier_Config model)
{
if (HttpContext.Current.Request["Name"] != null)
{
model.Name = Shop.Tools.RequestTool.RequestSafeString("Name");
}
if (HttpContext.Current.Request["Value"] != null)
{
model.Value = Shop.Tools.RequestTool.RequestSafeString("Value");
}
if (HttpContext.Current.Request["Supplier_id"] != null)
{
model.Supplier_id = Shop.Tools.RequestTool.RequestInt("Supplier_id", 0);
}
return(model);
}
/// <summary>
/// 设置一个设置值
/// </summary>
/// <param name="key"></param>
/// <param name="value"></param>
public static void Set(string key, string value)
{
Lebi_Supplier_Config conf = B_Lebi_Supplier_Config.GetModel("Name='" + key + "'");
if (conf == null)
{
conf = new Lebi_Supplier_Config();
conf.Name = key;
conf.Value = value;
B_Lebi_Supplier_Config.Add(conf);
}
else
{
conf.Value = value;
B_Lebi_Supplier_Config.Update(conf);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Lebi_Supplier_Config model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [Lebi_Supplier_Config] set ");
strSql.Append("[Name]=@Name,");
strSql.Append("[Value]=@Value,");
strSql.Append("[Supplier_id]=@Supplier_id");
strSql.Append(" where id=" + model.id);
OleDbParameter[] parameters =
{
new OleDbParameter("@Name", model.Name),
new OleDbParameter("@Value", model.Value),
new OleDbParameter("@Supplier_id", model.Supplier_id)
};
AccessUtils.Instance.TextExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Lebi_Supplier_Config model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Lebi_Supplier_Config](");
strSql.Append("[Name],[Value],[Supplier_id])");
strSql.Append(" values (");
strSql.Append("@Name,@Value,@Supplier_id)");
OleDbParameter[] parameters =
{
new OleDbParameter("@Name", model.Name),
new OleDbParameter("@Value", model.Value),
new OleDbParameter("@Supplier_id", model.Supplier_id)
};
AccessUtils.Instance.TextExecuteNonQuery(strSql.ToString(), parameters);
return(1);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public Lebi_Supplier_Config ReaderBind(IDataReader dataReader)
{
Lebi_Supplier_Config model = new Lebi_Supplier_Config();
object ojb;
ojb = dataReader["id"];
if (ojb != null && ojb != DBNull.Value)
{
model.id = (int)ojb;
}
model.Name = dataReader["Name"].ToString();
model.Value = dataReader["Value"].ToString();
ojb = dataReader["Supplier_id"];
if (ojb != null && ojb != DBNull.Value)
{
model.Supplier_id = (int)ojb;
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Lebi_Supplier_Config model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [Lebi_Supplier_Config] set ");
strSql.Append("Name= @Name,");
strSql.Append("Value= @Value,");
strSql.Append("Supplier_id= @Supplier_id");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Value", SqlDbType.NText),
new SqlParameter("@Supplier_id", SqlDbType.Int, 4)
};
parameters[0].Value = model.id;
parameters[1].Value = model.Name;
parameters[2].Value = model.Value;
parameters[3].Value = model.Supplier_id;
SqlUtils.SqlUtilsInstance.TextExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static void Update(Lebi_Supplier_Config model)
{
D_Lebi_Supplier_Config.Instance.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(Lebi_Supplier_Config model)
{
return(D_Lebi_Supplier_Config.Instance.Add(model));
}
/// <summary>
/// 安全方式绑定表单数据
/// </summary>
public static Lebi_Supplier_Config SafeBindForm(Lebi_Supplier_Config model)
{
return(D_Lebi_Supplier_Config.Instance.SafeBindForm(model));
}
