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