/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Lebi_Language_Tag_Version model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Lebi_Language_Tag_Version](");
strSql.Append("Version,Language_Code,Time_Update,Content)");
strSql.Append(" values (");
strSql.Append("@Version,@Language_Code,@Time_Update,@Content)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Version", model.Version),
new SqlParameter("@Language_Code", model.Language_Code),
new SqlParameter("@Time_Update", model.Time_Update),
new SqlParameter("@Content", model.Content)
};
object obj = SqlUtils.SqlUtilsInstance.TextExecuteNonQuery(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体 by SQLpara
/// </summary>
public Lebi_Language_Tag_Version GetModel(SQLPara para)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from [Lebi_Language_Tag_Version] ");
if (para.Where != "")
{
strSql.Append(" where " + para.Where + "");
}
Lebi_Language_Tag_Version model = new Lebi_Language_Tag_Version();
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());
}
if (ds.Tables[0].Rows[0]["Version"].ToString() != "")
{
model.Version = int.Parse(ds.Tables[0].Rows[0]["Version"].ToString());
}
model.Language_Code = ds.Tables[0].Rows[0]["Language_Code"].ToString();
if (ds.Tables[0].Rows[0]["Time_Update"].ToString() != "")
{
model.Time_Update = DateTime.Parse(ds.Tables[0].Rows[0]["Time_Update"].ToString());
}
model.Content = ds.Tables[0].Rows[0]["Content"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Lebi_Language_Tag_Version model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [Lebi_Language_Tag_Version] set ");
strSql.Append("Version= @Version,");
strSql.Append("Language_Code= @Language_Code,");
strSql.Append("Time_Update= @Time_Update,");
strSql.Append("Content= @Content");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@Version", SqlDbType.Int, 4),
new SqlParameter("@Language_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Time_Update", SqlDbType.DateTime),
new SqlParameter("@Content", SqlDbType.NText)
};
parameters[0].Value = model.id;
parameters[1].Value = model.Version;
parameters[2].Value = model.Language_Code;
parameters[3].Value = model.Time_Update;
parameters[4].Value = model.Content;
SqlUtils.SqlUtilsInstance.TextExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 检测词条库最新版本
/// </summary>
public void LanguageTagVersion()
{
string lang = RequestTool.RequestString("lang");
Lebi_Language_Tag_Version model = Shop.LebiAPI.Service.Instanse.LanguageTagVersion(lang);
//model.Content = model.Content.Replace("<br>","\r\n");
string b = "<div class=\\\"tools tools-m\\\"><ul>";
b += "<li class=\\\"submit\\\"><a href=\\\"javascript:void(0);\\\" onclick=\\\"TagUpdateDO('" + lang + "');\\\"><b></b><span>" + Tag("立即更新") + "</span></a></li>";
b += "</ul></div>";
model.Content += b;
Response.Write("{\"msg\":\"OK\",\"version\":\"" + model.Version + "\",\"content\":\"" + model.Content + "\"}");
}
/// <summary>
/// 更新一个语种的词条
/// </summary>
public void LanguageTagUpdate()
{
string lang = RequestTool.RequestString("lang");
int version = RequestTool.RequestInt("version");
Shop.LebiAPI.Service.Instanse.LanguageTagUpdate(lang);
//更新本地词条版本号
Lebi_Language_Tag_Version ver = new Lebi_Language_Tag_Version();
ver.Version = version;
ver.Language_Code = lang;
B_Lebi_Language_Tag_Version.Add(ver);
Response.Write("{\"msg\":\"OK\"}");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Lebi_Language_Tag_Version model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Lebi_Language_Tag_Version](");
strSql.Append("[Version],[Language_Code],[Time_Update],[Content])");
strSql.Append(" values (");
strSql.Append("@Version,@Language_Code,@Time_Update,@Content)");
OleDbParameter[] parameters =
{
new OleDbParameter("@Version", model.Version),
new OleDbParameter("@Language_Code", model.Language_Code),
new OleDbParameter("@Time_Update", model.Time_Update.ToString("yyyy-MM-dd HH:mm:ss")),
new OleDbParameter("@Content", model.Content)
};
AccessUtils.Instance.TextExecuteNonQuery(strSql.ToString(), parameters);
return(1);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Lebi_Language_Tag_Version model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [Lebi_Language_Tag_Version] set ");
strSql.Append("[Version]=@Version,");
strSql.Append("[Language_Code]=@Language_Code,");
strSql.Append("[Time_Update]=@Time_Update,");
strSql.Append("[Content]=@Content");
strSql.Append(" where id=" + model.id);
OleDbParameter[] parameters =
{
new OleDbParameter("@Version", model.Version),
new OleDbParameter("@Language_Code", model.Language_Code),
new OleDbParameter("@Time_Update", model.Time_Update.ToString("yyyy-MM-dd HH:mm:ss")),
new OleDbParameter("@Content", model.Content)
};
AccessUtils.Instance.TextExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 安全方式绑定对象表单
/// </summary>
public Lebi_Language_Tag_Version SafeBindForm(Lebi_Language_Tag_Version model)
{
if (HttpContext.Current.Request["Version"] != null)
{
model.Version = Shop.Tools.RequestTool.RequestInt("Version", 0);
}
if (HttpContext.Current.Request["Language_Code"] != null)
{
model.Language_Code = Shop.Tools.RequestTool.RequestSafeString("Language_Code");
}
if (HttpContext.Current.Request["Time_Update"] != null)
{
model.Time_Update = Shop.Tools.RequestTool.RequestTime("Time_Update", System.DateTime.Now);
}
if (HttpContext.Current.Request["Content"] != null)
{
model.Content = Shop.Tools.RequestTool.RequestSafeString("Content");
}
return(model);
}
/// <summary>
/// 得到一个对象实体 by id
/// </summary>
public Lebi_Language_Tag_Version GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from [Lebi_Language_Tag_Version] ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Lebi_Language_Tag_Version model = new Lebi_Language_Tag_Version();
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());
}
if (ds.Tables[0].Rows[0]["Version"].ToString() != "")
{
model.Version = int.Parse(ds.Tables[0].Rows[0]["Version"].ToString());
}
model.Language_Code = ds.Tables[0].Rows[0]["Language_Code"].ToString();
if (ds.Tables[0].Rows[0]["Time_Update"].ToString() != "")
{
model.Time_Update = DateTime.Parse(ds.Tables[0].Rows[0]["Time_Update"].ToString());
}
model.Content = ds.Tables[0].Rows[0]["Content"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public Lebi_Language_Tag_Version ReaderBind(IDataReader dataReader)
{
Lebi_Language_Tag_Version model = new Lebi_Language_Tag_Version();
object ojb;
ojb = dataReader["id"];
if (ojb != null && ojb != DBNull.Value)
{
model.id = (int)ojb;
}
ojb = dataReader["Version"];
if (ojb != null && ojb != DBNull.Value)
{
model.Version = (int)ojb;
}
model.Language_Code = dataReader["Language_Code"].ToString();
ojb = dataReader["Time_Update"];
if (ojb != null && ojb != DBNull.Value)
{
model.Time_Update = (DateTime)ojb;
}
model.Content = dataReader["Content"].ToString();
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static void Update(Lebi_Language_Tag_Version model)
{
D_Lebi_Language_Tag_Version.Instance.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(Lebi_Language_Tag_Version model)
{
return(D_Lebi_Language_Tag_Version.Instance.Add(model));
}
/// <summary>
/// 安全方式绑定表单数据
/// </summary>
public static Lebi_Language_Tag_Version SafeBindForm(Lebi_Language_Tag_Version model)
{
return(D_Lebi_Language_Tag_Version.Instance.SafeBindForm(model));
}
