/// <summary> /// 根据表,获取一个OleDbParameter数组 /// </summary> /// <returns>OleDbParameter[]</returns> public static OleDbParameter[] GetOleDbParameter(shuadan_names shuadan_namesExample) { List <OleDbParameter> list_param = new List <OleDbParameter>(); if (!string.IsNullOrEmpty(shuadan_namesExample.ncount)) { list_param.Add(new OleDbParameter("@ncount", shuadan_namesExample.ncount)); } else { list_param.Add(new OleDbParameter("@ncount", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_namesExample.nname)) { list_param.Add(new OleDbParameter("@nname", shuadan_namesExample.nname)); } else { list_param.Add(new OleDbParameter("@nname", DBNull.Value)); } OleDbParameter[] param = new OleDbParameter[list_param.Count]; int index = 0; foreach (OleDbParameter p in list_param) { param[index] = p; index++; } return(param); }
protected void btn_save2_Click(object sender, EventArgs e) { try { string data = txt_data.Text.Trim(); string[] ss = data.Split(new char[] { '\n', '\r' }, StringSplitOptions.RemoveEmptyEntries); int count_ok = 0; int count_no = 0; foreach (string s in ss) { string[] arry = Regex.Split(s, "\\s+", RegexOptions.IgnoreCase); string name2 = ""; foreach (string temp in arry) { shuadan_names sn = new shuadan_names(); sn.ncount = "0"; if (temp.Length == 1) { name2 = name2 + temp; if (name2.Length == 2) { sn.nname = name2; if (BLL.shuadan_namesManager.Search(1, 100, sn.nname).Count == 0) { if (BLL.shuadan_namesManager.Insert(sn) == 1) { count_ok++; } else { count_no++; } } } } if (temp.Length == 3) { sn.nname = temp; if (BLL.shuadan_namesManager.Search(1, 100, sn.nname).Count == 0) { if (BLL.shuadan_namesManager.Insert(sn) == 1) { count_ok++; } else { count_no++; } } } } } Manager.Alert("批处理操作完成:\\n成功添加 " + count_ok.ToString() + " 条信息" + (count_no == 0 ? "" : "\\n添加失败" + count_no.ToString() + "条信息!请注意核实!"), Page); } catch (Exception ex) { Manager.Alert(ex.ToString(), Page); } Manager.page_href_reload(Page); }
/// <summary> /// 从一个OleDbDataReader里读数据 /// </summary> /// <param name="Reader">OleDbDataReader</param> /// <returns>shuadan_namesExample</returns> public static shuadan_names GetByReader(OleDbDataReader Reader) { shuadan_names shuadan_namesExample = new shuadan_names(); shuadan_namesExample.ncount = Reader["ncount"] == DBNull.Value ? null : Reader["ncount"].ToString(); shuadan_namesExample.nid = Reader["nid"] == DBNull.Value ? 0 : (int)Reader["nid"]; shuadan_namesExample.nname = Reader["nname"] == DBNull.Value ? null : Reader["nname"].ToString(); return(shuadan_namesExample); }
/// <summary> /// 查询全部数据 /// </summary> /// <returns>IList</returns> /*查看是否为视图*/ public IList <shuadan_names> SearchAll() { Access.DBHelper.sqlstr = "select * from shuadan_names "; List <shuadan_names> list = new List <shuadan_names>(); OleDbDataReader reader = Access.DBHelper.ExecuteReader(); while (reader.Read()) { shuadan_names Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
/// <summary> /// 随机查询名字 /// </summary> /// <returns>IList</returns> /*查看是否为视图*/ public IList <shuadan_names> SearchRnd(int num) { Access.DBHelper.sqlstr = "SELECT top " + num.ToString() + " * FROM shuadan_names order by ncount asc, Rnd(nid) "; List <shuadan_names> list = new List <shuadan_names>(); OleDbDataReader reader = Access.DBHelper.ExecuteReader(); while (reader.Read()) { shuadan_names Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
/// <summary> /// 根据nid,查询一条数据 /// </summary> /// <param name="nid">编号</param> /// <returns></returns> public shuadan_names SearchBynid(int nid) { Access.DBHelper.sqlstr = "select * from shuadan_names where nid = @nid"; OleDbParameter[] param = new OleDbParameter[] { new OleDbParameter("@nid", nid) }; OleDbDataReader reader = Access.DBHelper.ExecuteReader(param); shuadan_names Obj = null; if (reader.Read()) { Obj = GetByReader(reader); } reader.Close(); return(Obj); }
protected void btn_save_Click(object sender, EventArgs e) { try { string name = txt_name.Text.Trim(); shuadan_names sn = new shuadan_names(); if (!string.IsNullOrEmpty(id)) { sn = BLL.shuadan_namesManager.SearchBynid(Convert.ToInt32(id)); } else { sn.ncount = "0"; } sn.nname = name; int res = 0; if (string.IsNullOrEmpty(id)) { if (BLL.shuadan_namesManager.Search(1, 100, sn.nname).Count == 0) { res = BLL.shuadan_namesManager.Insert(sn); } } else { res = BLL.shuadan_namesManager.Update(sn); } if (res == 1) { Manager.Alert("保存成功", Page); } else { Manager.Alert("保存失败", Page); } } catch (Exception ex) { Manager.Alert(ex.ToString(), Page); } Manager.page_href_reload(Page); }
/// <summary> /// 模糊搜索(高效率分页查询) /// </summary> /// <param name="key">关键词</param> /// <returns></returns> public IList <shuadan_names> Search(int s, int e, string key) { string sql1 = "select top " + e.ToString() + " * from shuadan_names where "; string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( nname like '%" + key + "%' ) "; string sql3 = " order by ncount desc,nid desc "; DBHelper.sqlstr = "select top " + (e - s + 1).ToString() + " * from " + "( " + sql1 + sql2 + " order by ncount asc,nid asc ) " + sql3; List <shuadan_names> list = new List <shuadan_names>(); OleDbDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { shuadan_names Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txt_account = GridView1.Rows[e.RowIndex].FindControl("txt_account") as TextBox; TextBox txt_count = GridView1.Rows[e.RowIndex].FindControl("txt_count") as TextBox; int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["nid"]); shuadan_names sa = BLL.shuadan_namesManager.SearchBynid(id); sa.nname = txt_account.Text.Trim(); sa.ncount = txt_count.Text.Trim(); if (BLL.shuadan_namesManager.Update(sa) != 1) { AJAXManager.Alert(this.UpdatePanel1, "修改失败"); } else { GridView1.EditIndex = -1; bind(); } }
void bind() { if (!string.IsNullOrEmpty(id)) { int temp = 0; if (int.TryParse(id, out temp)) { shuadan_names sn = BLL.shuadan_namesManager.SearchBynid(temp); if (sn != null) { try { txt_name.Text = sn.nname; liter_count.Text = sn.ncount.ToString(); } catch { } } } } }
/// <summary> /// 更新 /// </summary> /// <param name="shuadan_names">shuadan_names表实例</param> /// <returns>int</returns> public int Update(shuadan_names shuadan_namesExample) { Access.DBHelper.sqlstr = "update shuadan_names set ncount=@ncount,nname=@nname where nid=" + shuadan_namesExample.nid; return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(shuadan_namesExample))); }
/// <summary> /// 插入方法 /// </summary> /// <param name="shuadan_names">shuadan_names表实例</param> /// <returns>int</returns> public int Insert(shuadan_names shuadan_namesExample) { Access.DBHelper.sqlstr = "insert into shuadan_names (ncount,nname)values(@ncount,@nname)"; return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(shuadan_namesExample))); }
/// <summary> /// 更新 /// </summary> /// <param name="shuadan_names">shuadan_names表实例</param> /// <returns>int</returns> public static int Update(shuadan_names shuadan_namesExample) { return(Service.Update(shuadan_namesExample)); }
/// <summary> /// 插入方法 /// </summary> /// <param name="shuadan_names">shuadan_names表实例</param> /// <returns>int</returns> public static int Insert(shuadan_names shuadan_namesExample) { return(Service.Insert(shuadan_namesExample)); }