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