/// <summary> /// 查询全部数据 /// </summary> /// <returns>IList</returns> /*查看是否为视图*/ public IList <shuadan_record> SearchAll() { Access.DBHelper.sqlstr = "select * from shuadan_record "; List <shuadan_record> list = new List <shuadan_record>(); OleDbDataReader reader = Access.DBHelper.ExecuteReader(); while (reader.Read()) { shuadan_record Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
protected void btn_out_Click(object sender, EventArgs e) { int _temp = 0; if (!int.TryParse(txt_num2.Text.Trim(), out _temp)) { Manager.Alert("请输入要到处的数据条数", Page); txt_num2.Focus(); return; } List <string> list = BLL.shuadan_pingjiaManager.GetPingjia(_temp, 2, 9, new DateTime(), new DateTime()); //开始写入txt ////手机号导入完毕,开始存储为txt文件 Random ran = new Random(); string filename = DateTime.Now.ToString("yyyy年MM月dd日HHmmss") + ran.Next(999, 9999).ToString() + ".txt"; string filepath = Request.PhysicalApplicationPath + "OA\\upload\\shuadan\\pingjia\\"; if (!System.IO.Directory.Exists(filepath)) { System.IO.Directory.CreateDirectory(filepath); } FileStream fs_write = new FileStream(filepath + filename, FileMode.Create, FileAccess.ReadWrite); StreamWriter strmWriter = new StreamWriter(fs_write, System.Text.Encoding.Default); foreach (string s in list) { string str_write = s; strmWriter.Write(str_write); strmWriter.WriteLine(); //换行 } strmWriter.Flush(); strmWriter.Close(); Entity.shuadan_record sr = new shuadan_record(); sr.srcount = 1; sr.srdate = DateTime.Now; sr.srname = filename; sr.srnum = _temp.ToString(); sr.srpath = "~/OA/upload/shuadan/pingjia/" + filename; sr.srremark = ""; sr.srstate = "1"; sr.srtype = "4"; Manager.FileDownload("~/OA/upload/shuadan/pingjia/" + filename, filename, sr); bind(); }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { string state = e.CommandName; if (state == "state") { int id = Convert.ToInt32(GridView1.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["srid"].ToString()); if (id != 0) { shuadan_record sr = BLL.shuadan_recordManager.SearchBysrid(id); sr.srstate = sr.srstate == "1" ? "2" : "1"; if (BLL.shuadan_recordManager.Update(sr) != 1) { Manager.Alert("修改失败", Page); } else { GridView1.EditIndex = -1; bind(); } } } else if (state == "type") { int id = Convert.ToInt32(GridView1.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["srid"].ToString()); if (id != 0) { shuadan_record sr = BLL.shuadan_recordManager.SearchBysrid(id); sr.srtype = sr.srtype == "1" ? "2" : (sr.srtype == "2" ? "3" : (sr.srtype == "3" ? "4" : "1")); if (BLL.shuadan_recordManager.Update(sr) != 1) { Manager.Alert("修改失败", Page); } else { GridView1.EditIndex = -1; bind(); } } } else if (state == "Download") { int index = ((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex; int id = Convert.ToInt32(GridView1.DataKeys[index].Values["srid"].ToString()); shuadan_record sr = BLL.shuadan_recordManager.SearchBysrid(id); sr.srcount = sr.srcount + 1; Manager.FileDownload(sr.srpath, sr.srname, sr); } }
/// <summary> /// 从一个OleDbDataReader里读数据 /// </summary> /// <param name="Reader">OleDbDataReader</param> /// <returns>shuadan_recordExample</returns> public static shuadan_record GetByReader(OleDbDataReader Reader) { shuadan_record shuadan_recordExample = new shuadan_record(); shuadan_recordExample.srcount = Reader["srcount"] == DBNull.Value ? 0 : (int)Reader["srcount"]; shuadan_recordExample.srdate = Reader["srdate"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["srdate"]); shuadan_recordExample.srid = Reader["srid"] == DBNull.Value ? 0 : (int)Reader["srid"]; shuadan_recordExample.srname = Reader["srname"] == DBNull.Value ? null : Reader["srname"].ToString(); shuadan_recordExample.srnum = Reader["srnum"] == DBNull.Value ? null : Reader["srnum"].ToString(); shuadan_recordExample.srpath = Reader["srpath"] == DBNull.Value ? null : Reader["srpath"].ToString(); shuadan_recordExample.srremark = Reader["srremark"] == DBNull.Value ? null : Reader["srremark"].ToString(); shuadan_recordExample.srstate = Reader["srstate"] == DBNull.Value ? null : Reader["srstate"].ToString(); shuadan_recordExample.srtype = Reader["srtype"] == DBNull.Value ? null : Reader["srtype"].ToString(); return(shuadan_recordExample); }
/// <summary> /// 根据srid,查询一条数据 /// </summary> /// <param name="srid">编号</param> /// <returns></returns> public shuadan_record SearchBysrid(int srid) { Access.DBHelper.sqlstr = "select * from shuadan_record where srid = @srid"; OleDbParameter[] param = new OleDbParameter[] { new OleDbParameter("@srid", srid) }; OleDbDataReader reader = Access.DBHelper.ExecuteReader(param); shuadan_record Obj = null; if (reader.Read()) { Obj = GetByReader(reader); } reader.Close(); return(Obj); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txt_name = GridView1.Rows[e.RowIndex].FindControl("txt_name") as TextBox; TextBox txt_num = GridView1.Rows[e.RowIndex].FindControl("txt_num") as TextBox; TextBox txt_remark = GridView1.Rows[e.RowIndex].FindControl("txt_remark") as TextBox; int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["srid"]); shuadan_record sr = BLL.shuadan_recordManager.SearchBysrid(id); sr.srname = txt_name.Text.Trim(); sr.srnum = txt_num.Text.Trim(); sr.srremark = txt_remark.Text.Trim(); if (BLL.shuadan_recordManager.Update(sr) != 1) { Manager.Alert("修改失败", Page); } else { GridView1.EditIndex = -1; bind(); } }
/// <summary> /// 根据条件查询全部数据 /// </summary> /// <param name="s">起始位置</param> /// <param name="e">结束位置</param> /// <param name="key">关键词</param> /// <param name="state">状态</param> /// <param name="date1">起始时间</param> /// <param name="date2">结束时间</param> /// <returns>IList<shuadan_record></returns> public IList <shuadan_record> Search(int s, int e, string key, string state, string _type, DateTime date1, DateTime date2) { string sql1 = "select top " + e.ToString() + " * from shuadan_record where "; string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( srname like '%" + key + "%' or srpath like '%" + key + "%' or srremark like '%" + key + "%' ) "; string sql3 = string.IsNullOrEmpty(state) ? "" : " and srstate= '" + state + "' "; string sql4 = string.IsNullOrEmpty(_type) ? "" : " and srtype= '" + _type + "' "; string sql5 = date1 == new DateTime() ? "" : " and datediff('d','" + date1.ToString() + "',srdate)>=0 "; string sql6 = date2 == new DateTime() ? "" : " and datediff('d','" + date2.ToString() + "',srdate)<=0 "; string sql7 = " order by srdate asc,srid desc ";//排序两个字段,否则数据容易错误 DBHelper.sqlstr = "select * from(select top " + (e - s + 1).ToString() + " * from ( " + sql1 + sql2 + sql3 + sql4 + sql5 + sql6 + " order by srdate desc,srid asc ) " + sql7 + ") order by srdate desc,srid asc "; List <shuadan_record> list = new List <shuadan_record>(); OleDbDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { shuadan_record Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
/// <summary> /// 更新 /// </summary> /// <param name="shuadan_record">shuadan_record表实例</param> /// <returns>int</returns> public static int Update(shuadan_record shuadan_recordExample) { return(Service.Update(shuadan_recordExample)); }
/// <summary> /// 插入方法 /// </summary> /// <param name="shuadan_record">shuadan_record表实例</param> /// <returns>int</returns> public static int Insert(shuadan_record shuadan_recordExample) { return(Service.Insert(shuadan_recordExample)); }
void convert_str(FileUpload FileUpload1, Page page) { try { string _name = ""; if (!FileUpload1.HasFile) { //AJAXManager.Alert(UpdatePanel1, "请选择文件"); Manager.Alert("请选择文件", page); return; } else { string path = System.Web.HttpContext.Current.Request.PhysicalApplicationPath + "OA\\upload\\shuadan\\convert\\"; string[] strs = { ".txt" }; if (!BLL.Manager.UpFile(FileUpload1, strs, path, "")) { //AJAXManager.Alert(UpdatePanel1, "文件上传错误"); Manager.Alert("文件上传错误", page); return; } else { HttpCookie cookie = System.Web.HttpContext.Current.Request.Cookies[Manager.decl_UploadFileName]; _name = cookie.Value; FileStream fs = new FileStream(path + _name, FileMode.Open, FileAccess.Read, FileShare.None); StreamReader sr = new StreamReader(fs, System.Text.Encoding.Default); List <string> list = new List <string>(); //手机号导入完毕,开始存储为txt文件 Random ran = new Random(); string filename = DateTime.Now.ToString("yyyy年MM月dd日HHmmss") + ran.Next(999, 9999).ToString() + ".txt"; string filepath = System.Web.HttpContext.Current.Request.PhysicalApplicationPath + "OA\\upload\\shuadan\\convert\\" + filename; FileStream fs_write = new FileStream(filepath, FileMode.Create, FileAccess.ReadWrite); StreamWriter strmWriter = new StreamWriter(fs_write, System.Text.Encoding.Default); string convert_yuan = ""; string convert_new = ""; convert_new = txt_new.Text.Trim(); convert_yuan = txt_yuan.Text.Trim(); string str = ""; string s = Console.ReadLine(); int j = 0; while (str != null) { str = sr.ReadLine(); if (str == null) { break; } j++; if (j == 1) { continue; } //string[] xu = new String[2]; str = str.Replace(convert_yuan, convert_new); //xu = str.Split('-'); //if (xu[0] == "") //{ // break; //} //Entity.shuadan sd = new Entity.shuadan(); //sd.sddate = DateTime.Now; //sd.sdinfofrom = "4"; //sd.sdname = xu[0]; //sd.sdphone = xu[1]; //sd.sdprovince = xu[2]; //sd.scity = xu[3]; //sd.sdistrict = xu[4]; //sd.sdaddress = xu[5]; //list.Add(sd); strmWriter.Write(str); strmWriter.WriteLine(); //换行 } sr.Close(); //strmWriter.Write(dt.Columns[i].ColumnName + " "); // strmWriter.WriteLine(); //换行 //foreach (shuadan sd_temp in list) //{ // //插入刷单数据 // //BLL.shuadanManager.Insert(sd_temp); // string str_write = sd_temp.sdname + "," + sd_temp.sdphone + "," + sd_temp.sdprovince + " " + sd_temp.scity + " " + sd_temp.sdistrict + " " + sd_temp.sdaddress + ",100000"; // strmWriter.Write(str_write); // strmWriter.WriteLine(); //换行 //} strmWriter.Flush(); strmWriter.Close(); Entity.shuadan_record srr = new shuadan_record(); srr.srcount = 1; srr.srdate = DateTime.Now; srr.srname = filename; srr.srnum = list.Count.ToString(); srr.srpath = "~/OA/upload/shuadan/convert/" + filename; srr.srremark = ""; srr.srstate = "1"; srr.srtype = "6"; Manager.FileDownload("~/OA/upload/shuadan/convert/" + filename, filename, srr); } } } catch (Exception ex) { Manager.Alert(ex.ToString(), page); } }
protected void btn_saveMLS_Click(object sender, EventArgs e) { try { string _name = ""; if (!FileUpload1.HasFile) { //AJAXManager.Alert(UpdatePanel1, "请选择文件"); Manager.Alert("请选择文件", Page); return; } else { string path = System.Web.HttpContext.Current.Request.PhysicalApplicationPath + "OA\\upload\\shuadan\\convert\\"; string[] strs = { ".txt" }; if (!BLL.Manager.UpFile(FileUpload1, strs, path, "")) { //AJAXManager.Alert(UpdatePanel1, "文件上传错误"); Manager.Alert("文件上传错误", Page); return; } else { HttpCookie cookie = System.Web.HttpContext.Current.Request.Cookies[Manager.decl_UploadFileName]; _name = cookie.Value; FileStream fs = new FileStream(path + _name, FileMode.Open, FileAccess.Read, FileShare.None); StreamReader sr = new StreamReader(fs, System.Text.Encoding.Default); List <string> list = new List <string>(); //手机号导入完毕,开始存储为txt文件 Random ran = new Random(); string filename = DateTime.Now.ToString("yyyy年MM月dd日HHmmss") + ran.Next(999, 9999).ToString() + ".txt"; string filepath = System.Web.HttpContext.Current.Request.PhysicalApplicationPath + "OA\\upload\\shuadan\\convert\\" + filename; FileStream fs_write = new FileStream(filepath, FileMode.Create, FileAccess.ReadWrite); StreamWriter strmWriter = new StreamWriter(fs_write, System.Text.Encoding.Default); string str = ""; string s = Console.ReadLine(); int j = 0; while (str != null) { str = sr.ReadLine(); if (str == null) { break; } j++; if (j == 1) { continue; } str = str.Replace("省", ""); str = str.Replace("市", ""); strmWriter.Write(str); strmWriter.WriteLine(); //换行 } sr.Close(); strmWriter.Flush(); strmWriter.Close(); Entity.shuadan_record srr = new shuadan_record(); srr.srcount = 1; srr.srdate = DateTime.Now; srr.srname = filename; srr.srnum = list.Count.ToString(); srr.srpath = "~/OA/upload/shuadan/convert/" + filename; srr.srremark = ""; srr.srstate = "1"; srr.srtype = "6"; Manager.FileDownload("~/OA/upload/shuadan/convert/" + filename, filename, srr); } } } catch (Exception ex) { Manager.Alert(ex.ToString(), Page); } }
protected void btn_out_Click(object sender, EventArgs e) { string _temp = txt_num.Text.Trim(); IList <shuadan_account> list = new List <shuadan_account>(); //根据数量导出 if (!string.IsNullOrEmpty(_temp)) { int _num = 0; if (!int.TryParse(_temp, out _num)) { AJAXManager.Alert(UpdatePanel1, "请输入正确的数量"); return; } else { //开始导出 date1 = txt_date1.Text.Trim(); date2 = txt_date2.Text.Trim(); state_phone = ddl_state_phone.SelectedValue; state = ddl_state.SelectedValue; key = txt_key.Text.Trim(); num = txt_num.Text.Trim(); DateTime temp_date1 = new DateTime(); DateTime temp_date2 = new DateTime(); DateTime.TryParse(date1, out temp_date1); DateTime.TryParse(date2, out temp_date2); list = BLL.shuadan_accountManager.Search(1, _num, key, state, state_phone, temp_date1, temp_date2, num); } } else { //根据多选导出 string temp_ckname = Request.Form.Get("checkboxname"); if (string.IsNullOrEmpty(temp_ckname)) { AJAXManager.Alert(UpdatePanel1, "请输入正确的数量"); return; } string[] temp_id = temp_ckname.Split(new char[] { ',' }); if (temp_id.Length == 0) { AJAXManager.Alert(UpdatePanel1, "请输入正确的数量"); return; } foreach (string temp in temp_id) { int id = 0; if (int.TryParse(temp, out id)) { list.Add(BLL.shuadan_accountManager.SearchBysdaid(id)); } } } if (list.Count < 1) { AJAXManager.Alert(UpdatePanel1, "请输入正确的数量"); return; } //开始写入txt ////手机号导入完毕,开始存储为txt文件 Random ran = new Random(); string filename = DateTime.Now.ToString("yyyy年MM月dd日HHmmss") + ran.Next(999, 9999).ToString() + ".txt"; string filepath = Request.PhysicalApplicationPath + "OA\\upload\\shuadan\\account\\"; if (!System.IO.Directory.Exists(filepath)) { System.IO.Directory.CreateDirectory(filepath); } FileStream fs_write = new FileStream(filepath + filename, FileMode.Create, FileAccess.ReadWrite); StreamWriter strmWriter = new StreamWriter(fs_write, System.Text.Encoding.Default); //strmWriter.Write(dt.Columns[i].ColumnName + " "); // strmWriter.WriteLine(); //换行 foreach (shuadan_account sda in list) { sda.sdastate = "1"; BLL.shuadan_accountManager.Update(sda); string info = sda.sdaccount + "----" + sda.sdapwd + "----恭喜您,上传成功"; string str_write = info; strmWriter.Write(str_write); strmWriter.WriteLine(); //换行 } strmWriter.Flush(); strmWriter.Close(); Entity.shuadan_record sr = new shuadan_record(); sr.srcount = 1; sr.srdate = DateTime.Now; sr.srname = filename; sr.srnum = _temp.ToString(); sr.srpath = "~/OA/upload/shuadan/account/" + filename; sr.srremark = ""; sr.srstate = "1"; sr.srtype = "1"; Manager.FileDownload("~/OA/upload/shuadan/account/" + filename, filename, sr); bind(); }
/// <summary> /// 更新 /// </summary> /// <param name="shuadan_record">shuadan_record表实例</param> /// <returns>int</returns> public int Update(shuadan_record shuadan_recordExample) { Access.DBHelper.sqlstr = "update shuadan_record set srcount=@srcount,srdate='" + shuadan_recordExample.srdate.ToString() + "',srname=@srname,srnum=@srnum,srpath=@srpath,srremark=@srremark,srstate=@srstate,srtype=@srtype where srid=" + shuadan_recordExample.srid; return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(shuadan_recordExample))); }
/// <summary> /// 插入方法 /// </summary> /// <param name="shuadan_record">shuadan_record表实例</param> /// <returns>int</returns> public int Insert(shuadan_record shuadan_recordExample) { Access.DBHelper.sqlstr = "insert into shuadan_record (srcount,srdate,srname,srnum,srpath,srremark,srstate,srtype)values(@srcount,'" + shuadan_recordExample.srdate.ToString() + "',@srname,@srnum,@srpath,@srremark,@srstate,@srtype)"; return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(shuadan_recordExample))); }
/// <summary> /// 根据表,获取一个OleDbParameter数组 /// </summary> /// <returns>OleDbParameter[]</returns> public static OleDbParameter[] GetOleDbParameter(shuadan_record shuadan_recordExample) { List <OleDbParameter> list_param = new List <OleDbParameter>(); if (shuadan_recordExample.srcount != 0) { list_param.Add(new OleDbParameter("@srcount", shuadan_recordExample.srcount)); } else { list_param.Add(new OleDbParameter("@srcount", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordExample.srname)) { list_param.Add(new OleDbParameter("@srname", shuadan_recordExample.srname)); } else { list_param.Add(new OleDbParameter("@srname", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordExample.srnum)) { list_param.Add(new OleDbParameter("@srnum", shuadan_recordExample.srnum)); } else { list_param.Add(new OleDbParameter("@srnum", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordExample.srpath)) { list_param.Add(new OleDbParameter("@srpath", shuadan_recordExample.srpath)); } else { list_param.Add(new OleDbParameter("@srpath", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordExample.srremark)) { list_param.Add(new OleDbParameter("@srremark", shuadan_recordExample.srremark)); } else { list_param.Add(new OleDbParameter("@srremark", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordExample.srstate)) { list_param.Add(new OleDbParameter("@srstate", shuadan_recordExample.srstate)); } else { list_param.Add(new OleDbParameter("@srstate", DBNull.Value)); } if (!string.IsNullOrEmpty(shuadan_recordExample.srtype)) { list_param.Add(new OleDbParameter("@srtype", shuadan_recordExample.srtype)); } else { list_param.Add(new OleDbParameter("@srtype", DBNull.Value)); } OleDbParameter[] param = new OleDbParameter[list_param.Count]; int index = 0; foreach (OleDbParameter p in list_param) { param[index] = p; index++; } return(param); }