/// <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)); }