protected void GridView3_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txt_account = GridView3.Rows[e.RowIndex].FindControl("txt_account") as TextBox; TextBox txt_zhifubao = GridView3.Rows[e.RowIndex].FindControl("txt_zhifubao") as TextBox; TextBox txt_num = GridView3.Rows[e.RowIndex].FindControl("txt_num") as TextBox; TextBox txt_remark = GridView3.Rows[e.RowIndex].FindControl("txt_remark") as TextBox; int id = Convert.ToInt32(GridView3.DataKeys[e.RowIndex].Values["fx_id"]); fanxian fx = BLL.fanxianManager.SearchByfx_id(id); fx.fx_num = Convert.ToDecimal(txt_num.Text.Trim()); fx.fx_remark = txt_remark.Text.Trim(); fx.fx_zhifubao = txt_zhifubao.Text.Trim(); fx.fx_account = txt_account.Text.Trim(); if (BLL.fanxianManager.Update(fx) != 1) { AJAXManager.Alert(this.UpdatePanel1, "修改失败"); } else { GridView3.EditIndex = -1; bind_fanxian(); } }
/// <summary> /// 模糊搜索 /// </summary> /// <param name="key">关键词</param> /// <param name="state">状态</param> /// <param name="startdate">起始时间</param> /// <param name="enddate">结束时间</param> /// <param name="orderby">排序</param> /// <returns></returns> public IList <fanxian> Search(int s, int e, string key, string state, int dpid, DateTime startdate, DateTime enddate, DateTime startdate2, DateTime enddate2, string orderby) { string sql1 = "select top " + (e - s + 1).ToString() + " * from fanxian where "; string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( fx_account like '%" + key + "%' or fx_remark like '%" + key + "%' or fx_zhifubao like '%" + key + "%' or fx_num like '" + key + "' ) "; string sql3 = string.IsNullOrEmpty(state) ? "" : " and fx_state= '" + state + "' "; string sql9 = dpid == 0 ? "" : " and dpid='" + dpid.ToString() + "' "; string sql4 = startdate == new DateTime() ? "" : " and datediff(d,'" + startdate.ToString() + "',fx_date)>=0 "; string sql5 = enddate == new DateTime() ? "" : " and datediff(d,'" + enddate.ToString() + "',fx_date)<=0 "; string sql6 = startdate2 == new DateTime() ? "" : " and datediff(d,'" + startdate2.ToString() + "',fx_date2)>=0 "; string sql7 = enddate2 == new DateTime() ? "" : " and datediff(d,'" + enddate2.ToString() + "',fx_date2)<=0 "; string sql8 = string.IsNullOrEmpty(orderby) ? " order by fx_date desc " : " order by " + orderby; string sql10 = s == 1 ? "" : " and fx_id not in ( select top " + (s - 1).ToString() + " fx_id from fanxian where " + sql2 + sql3 + sql4 + sql5 + sql7 + sql9 + sql8 + " ) "; DBHelper.sqlstr = sql1 + sql2 + sql3 + sql9 + sql4 + sql5 + sql6 + sql7 + sql9 + sql10 + sql8; List <fanxian> list = new List <fanxian>(); SqlDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { fanxian Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
protected void btn_do_Click(object sender, EventArgs e) { string key = txt_key.Text.Trim(); if (string.IsNullOrEmpty(key)) { AJAXManager.Alert(UpdatePanel1, "请输入关键词"); txt_key.Focus(); return; } IList <fanxian> list = BLL.fanxianManager.Search(1, 1, key, "", 0, new DateTime(), new DateTime(), new DateTime(), new DateTime(), ""); if (list.Count > 0) { fanxian fx = (fanxian)list[0]; if (fx != null) { fx.fx_remark = "支付宝打款失败"; fx.fx_state = "3"; if (BLL.fanxianManager.Update(fx) == 1) { AJAXManager.Alert(UpdatePanel1, "处理成功"); return; } else { AJAXManager.Alert(UpdatePanel1, "处理失败"); return; } } } AJAXManager.Alert(UpdatePanel1, "没有找到数据"); }
/// <summary> /// 模糊搜索 /// </summary> /// <param name="startindex">开始查询位置</param> /// <param name="searchnum">需要查询的条数</param> /// <param name="key">关键词</param> /// <param name="state">状态</param> /// <param name="id">int字段</param> /// <param name="startdate">起始时间</param> /// <param name="enddate">结束时间</param> /// <param name="orderby">排序</param> /// <returns>IList<fanxian></returns> public IList <fanxian> Search(int startindex, int searchnum, string key, string state, int dpid, DateTime startdate, DateTime enddate, DateTime startdate2, DateTime enddate2, string orderby) { string sql1 = "select * from fanxian where "; string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( fx_account like '%" + key + "%' or fx_remark like '%" + key + "%' or fx_zhifubao like '%" + key + "%' or fx_num like '" + key + "' ) "; string sql3 = string.IsNullOrEmpty(state) ? "" : " and fx_state= '" + state + "' "; //状态字段,无用删除 string sql4 = dpid == 0 ? "" : " and dpid='" + dpid.ToString() + "' "; //Int字段,无用删除 string sql5 = startdate == new DateTime() ? "" : " and datediff('" + startdate.ToString() + "',fx_date)>=0 "; string sql6 = enddate == new DateTime() ? "" : " and datediff('" + enddate.ToString() + "',fx_date)<=0 "; string sql7 = startdate2 == new DateTime() ? "" : " and datediff('" + startdate2.ToString() + "',fx_date2)>=0 "; string sql8 = enddate2 == new DateTime() ? "" : " and datediff('" + enddate2.ToString() + "',fx_date2)<=0 "; string sql9 = string.IsNullOrEmpty(orderby) ? " order by fx_date desc " : " order by " + orderby; string sql10 = searchnum == 0 ? " " : " limit " + startindex + "," + searchnum; DBHelper.sqlstr = sql1 + sql2 + sql3 + sql4 + sql5 + sql6 + sql7 + sql8 + sql9 + sql10; List <fanxian> list = new List <fanxian>(); MySqlDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { fanxian Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
void bind() { if (!string.IsNullOrEmpty(id)) { int temp = 0; if (int.TryParse(id, out temp)) { fanxian fx = fanxianManager.SearchByfx_id(temp); if (fx != null) { try { txt_account.Text = fx.fx_account; txt_remark.Text = fx.fx_remark; txt_num.Text = fx.fx_num.ToString(); txt_zhifubao.Text = fx.fx_zhifubao; lbl_date1.Text = fx.fx_date.ToString(); lbl_date2.Text = fx.fx_date2.ToString(); ddl_dianpu.SelectedValue = fx.dpid.ToString(); ddl_state.SelectedValue = fx.fx_state; } catch { } } } } }
/// <summary> /// 查询全部数据 /// </summary> /// <returns>IList</returns> /*查看是否为视图*/ public IList <fanxian> SearchAll() { DBHelper.sqlstr = "select * from fanxian where fx_state='1' order by fx_date desc,fx_id asc "; List <fanxian> list = new List <fanxian>(); OleDbDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { fanxian Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
/// <summary> /// 模糊搜索 /// </summary> /// <param name="key">关键词</param> /// <param name="state">状态</param> /// <param name="startdate">起始时间</param> /// <param name="enddate">结束时间</param> /// <param name="orderby">排序</param> /// <returns></returns> public fanxian SearchLast_FanxianDate() { string sql1 = "SELECT top 1 * FROM fanxian order by fx_date2 desc "; DBHelper.sqlstr = sql1; OleDbDataReader reader = DBHelper.ExecuteReader(); fanxian Obj = null; while (reader.Read()) { Obj = GetByReader(reader); } reader.Close(); return(Obj); }
/// <summary> /// 从一个OleDbDataReader里读数据 /// </summary> /// <param name="Reader">OleDbDataReader</param> /// <returns>fanxianExample</returns> public static fanxian GetByReader(OleDbDataReader Reader) { fanxian fanxianExample = new fanxian(); fanxianExample.dpid = Reader["dpid"] == DBNull.Value ? null : Reader["dpid"].ToString(); fanxianExample.fx_account = Reader["fx_account"] == DBNull.Value ? null : Reader["fx_account"].ToString(); fanxianExample.fx_date = Reader["fx_date"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["fx_date"]); fanxianExample.fx_date2 = Reader["fx_date2"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["fx_date2"]); fanxianExample.fx_id = Reader["fx_id"] == DBNull.Value ? 0 : (int)Reader["fx_id"]; fanxianExample.fx_num = Reader["fx_num"] == DBNull.Value ? 0 : Convert.ToDecimal(Reader["fx_num"]); fanxianExample.fx_remark = Reader["fx_remark"] == DBNull.Value ? null : Reader["fx_remark"].ToString(); fanxianExample.fx_state = Reader["fx_state"] == DBNull.Value ? null : Reader["fx_state"].ToString(); fanxianExample.fx_zhifubao = Reader["fx_zhifubao"] == DBNull.Value ? null : Reader["fx_zhifubao"].ToString(); return(fanxianExample); }
/// <summary> /// 根据fx_id,查询一条数据 /// </summary> /// <param name="fx_id"></param> /// <returns></returns> public fanxian SearchByfx_id(int fx_id) { DBHelper.sqlstr = "select * from fanxian where fx_id = @fx_id"; OleDbParameter[] param = new OleDbParameter[] { new OleDbParameter("@fx_id", fx_id) }; OleDbDataReader reader = DBHelper.ExecuteReader(param); fanxian Obj = null; if (reader.Read()) { Obj = GetByReader(reader); } reader.Close(); return(Obj); }
protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e) { string state = e.CommandName; if (state == "state") { int id = Convert.ToInt32(GridView3.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["fx_id"].ToString()); if (id != 0) { fanxian fx = BLL.fanxianManager.SearchByfx_id(id); fx.fx_state = fx.fx_state == "1" ? "2" : (fx.fx_state == "2" ? "3" : "1"); if (fx.fx_state == "2") { fx.fx_date2 = DateTime.Now; } if (BLL.fanxianManager.Update(fx) != 1) { AJAXManager.Alert(this.UpdatePanel1, "修改失败"); } else { bind_fanxian(); } } } else if (state == "fanxian") { int id = Convert.ToInt32(GridView3.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["fx_id"].ToString()); if (id != 0) { fanxian fx = BLL.fanxianManager.SearchByfx_id(id); fx.fx_state = "2"; fx.fx_date2 = DateTime.Now; if (BLL.fanxianManager.Update(fx) != 1) { AJAXManager.Alert(this.UpdatePanel1, "修改失败"); } else { bind_fanxian(); } //AJAXManager.Alert(UpdatePanel1, "test"); //AJAXManager.Js(UpdatePanel1, "to_zhifubao('" + fx.fx_zhifubao + "','" + fx.fx_num + "')"); } } }
protected void btn_save_Click(object sender, EventArgs e) { try { DateTime dt = DateTime.Now; string num = txt_num.Text.Trim(); string remark = txt_remark.Text.Trim(); string state = ddl_state.SelectedValue.ToString(); string dianpu = ddl_dianpu.SelectedValue != null?ddl_dianpu.SelectedValue.ToString() : ""; string data = txt_data.Text; //data=data.Replace("\t",""); fanxian fx = new fanxian(); fx.fx_date = DateTime.Now; int res1 = 0; int res2 = 0; decimal temp_num; if (!decimal.TryParse(num, out temp_num)) { Manager.Alert("请输入正确的金额", Page); Manager.TextBox_Select(txt_num); return; } fx.dpid = dianpu; fx.fx_num = temp_num; fx.fx_remark = remark; fx.fx_state = state; //批量数据处理 string[] ss = data.Split(new char[2] { '\n', '\r' }, StringSplitOptions.RemoveEmptyEntries); foreach (string s in ss) { string[] arry = Regex.Split(s, "\\s+", RegexOptions.IgnoreCase); int i = 1; List <string> arry2 = new List <string>(); foreach (string temp in arry) { if (!string.IsNullOrEmpty(temp)) { arry2.Add(temp); } } foreach (string temp in arry2) { if (i == 1) { fx.fx_account = temp; } else if (i == 2) { fx.fx_zhifubao = temp; } i++; } if (string.IsNullOrEmpty(fx.fx_account) || string.IsNullOrEmpty(fx.fx_zhifubao)) { continue; } if (BLL.fanxianManager.Insert(fx) == 1) { res1++; } else { res2++; } fx.fx_account = ""; fx.fx_zhifubao = ""; } Manager.Alert("批处理操作完成:\\n成功添加 " + res1.ToString() + " 条信息" + (res2 == 0 ? "" : "\\n添加失败" + res2.ToString() + "条信息!请注意核实!"), Page); } catch (Exception ex) { Manager.Alert(ex.ToString(), Page); } Manager.page_href_reload(Page); }
/// <summary> /// 插入方法 /// </summary> /// <param name="fanxian">fanxian表实例</param> /// <returns>int</returns> public static int Insert(fanxian fanxianExample) { return(Service.Insert(fanxianExample)); }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1) { int temp = e.ColumnIndex; string id = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); int idid; if (temp == 4) { if (int.TryParse(id, out idid)) { fanxian fx = BLL2.fanxianManager.SearchByfx_id(idid); if (fx.fx_state == "1") { fx.fx_state = fx.fx_state == "1" ? "2" : "1"; fx.fx_date2 = DateTime.Now; if (BLL2.fanxianManager.Update(fx) == 1) { if (fx.fx_state == "1") { dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "未返现"; } else if (fx.fx_state == "2") { dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "已返现"; } } else { MessageBox.Show("系统出错,请联系我"); } } else { MessageBox.Show("该返现已经处理,请慎重操作!"); } } } else if (temp == 0) { //object kdcode = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value; //if (kdcode != null) //{ // if (!string.IsNullOrEmpty(kdcode.ToString())) // { // System.Diagnostics.Process.Start("http://www.kiees.cn/yto.php?wen=" + kdcode); // } //} } else { if (int.TryParse(id, out idid)) { Entity.fanxian sh = BLL2.fanxianManager.SearchByfx_id(idid); txt_account.Text = sh.fx_account; txt_remark.Text = sh.fx_remark; lbl_id.Text = sh.fx_id.ToString(); lbl_date1.Text = sh.fx_date.ToString(); lbl_date2.Text = sh.fx_date2.ToString(); lbl_CellIndex.Text = e.ColumnIndex.ToString(); lbl_RowIndex.Text = e.RowIndex.ToString(); txt_zhifubao.Text = sh.fx_zhifubao; try { int i = 1; int.TryParse(sh.dpid, out i); cb_dianpu.SelectedValue = i; cb_state.Text = sh.fx_state == "1" ? "未返现" : "已返现"; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } } }
private void btn_save_Click(object sender, EventArgs e) { try { string id = lbl_id.Text.Trim(); string account = txt_account.Text.Trim(); string num = txt_num.Text.Trim(); string zhifubao = txt_zhifubao.Text.Trim(); string remark = txt_remark.Text.Trim(); string dianpu = cb_dianpu.SelectedValue != null?cb_dianpu.SelectedValue.ToString() : ""; string state = cb_state.Text == "未返现" ? "1" : "2"; int num_temp = 2; fanxian fx = new fanxian(); if (!string.IsNullOrEmpty(id)) { fx = BLL2.fanxianManager.SearchByfx_id(Convert.ToInt32(id)); } if (string.IsNullOrEmpty(zhifubao)) { MessageBox.Show("请输入支付宝账号!"); txt_zhifubao.Focus(); return; } if (string.IsNullOrEmpty(num)) { MessageBox.Show("请输入返现金额!"); txt_num.Focus(); return; } else if (!int.TryParse(num, out num_temp)) { MessageBox.Show("请输入正确的返现金额!"); txt_num.Focus(); txt_num.SelectAll(); return; } if (string.IsNullOrEmpty(dianpu)) { MessageBox.Show("请选择店铺!"); cb_dianpu.Focus(); return; } fx.dpid = dianpu; fx.fx_account = account; fx.fx_num = num_temp; fx.fx_remark = remark; fx.fx_state = state; fx.fx_zhifubao = zhifubao; int res = 0; if (string.IsNullOrEmpty(lbl_id.Text.Trim())) { fx.fx_date = DateTime.Now; res = BLL2.fanxianManager.Insert(fx); bind(); } else { string rIndex = lbl_RowIndex.Text.Trim(); string cIndex = lbl_CellIndex.Text.Trim(); int ci; int ri; if (int.TryParse(cIndex, out ci) && int.TryParse(rIndex, out ri)) { string temp_state = dataGridView1.Rows[ri].Cells[4].Value.ToString(); if (temp_state == "1" && fx.fx_state == "2") { fx.fx_date2 = DateTime.Now; } res = BLL2.fanxianManager.Update(fx); if (res == 1) { dataGridView1.Rows[ri].Cells[0].Value = fx.fx_id; dataGridView1.Rows[ri].Cells[1].Value = fx.fx_account; dataGridView1.Rows[ri].Cells[2].Value = fx.fx_zhifubao; dataGridView1.Rows[ri].Cells[3].Value = fx.fx_num; dataGridView1.Rows[ri].Cells[4].Value = fx.fx_state == "1" ? "未返现" : "已返现"; dataGridView1.Rows[ri].Cells[5].Value = fx.fx_remark; dataGridView1.Rows[ri].Cells[6].Value = fx.fx_date.ToString(); } } } if (res == 1) { MessageBox.Show("保存成功"); } else { MessageBox.Show("保存失败"); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } clears(); }
/// <summary> /// 根据表,获取一个OleDbParameter数组 /// </summary> /// <returns>OleDbParameter[]</returns> public static OleDbParameter[] GetOleDbParameter(fanxian fanxianExample) { List <OleDbParameter> list_param = new List <OleDbParameter>(); if (!string.IsNullOrEmpty(fanxianExample.dpid)) { list_param.Add(new OleDbParameter("@dpid", fanxianExample.dpid)); } else { list_param.Add(new OleDbParameter("@dpid", DBNull.Value)); } if (!string.IsNullOrEmpty(fanxianExample.fx_account)) { list_param.Add(new OleDbParameter("@fx_account", fanxianExample.fx_account)); } else { list_param.Add(new OleDbParameter("@fx_account", DBNull.Value)); } if (fanxianExample.fx_date != new DateTime() && fanxianExample.fx_date != null) { list_param.Add(new OleDbParameter("@fx_date", fanxianExample.fx_date.ToString("yyyy-MM-dd"))); } else { list_param.Add(new OleDbParameter("@fx_date", DBNull.Value)); } if (fanxianExample.fx_date2 != new DateTime() && fanxianExample.fx_date2 != null) { list_param.Add(new OleDbParameter("@fx_date2", fanxianExample.fx_date2.ToString("yyyy-MM-dd"))); } else { list_param.Add(new OleDbParameter("@fx_date2", DBNull.Value)); } if (fanxianExample.fx_num != new decimal()) { list_param.Add(new OleDbParameter("@fx_num", fanxianExample.fx_num)); } else { list_param.Add(new OleDbParameter("@fx_num", DBNull.Value)); } if (!string.IsNullOrEmpty(fanxianExample.fx_remark)) { list_param.Add(new OleDbParameter("@fx_remark", fanxianExample.fx_remark)); } else { list_param.Add(new OleDbParameter("@fx_remark", DBNull.Value)); } if (!string.IsNullOrEmpty(fanxianExample.fx_state)) { list_param.Add(new OleDbParameter("@fx_state", fanxianExample.fx_state)); } else { list_param.Add(new OleDbParameter("@fx_state", DBNull.Value)); } if (!string.IsNullOrEmpty(fanxianExample.fx_zhifubao)) { list_param.Add(new OleDbParameter("@fx_zhifubao", fanxianExample.fx_zhifubao)); } else { list_param.Add(new OleDbParameter("@fx_zhifubao", 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_save_Click(object sender, EventArgs e) { try { DateTime dt = DateTime.Now; string account = txt_account.Text.Trim(); string zhifubao = txt_zhifubao.Text.Trim(); string num = txt_num.Text.Trim(); string remark = txt_remark.Text.Trim(); string state = ddl_state.SelectedValue.ToString(); string dianpu = ddl_dianpu.SelectedValue != null?ddl_dianpu.SelectedValue.ToString() : ""; fanxian fx = new fanxian(); if (!string.IsNullOrEmpty(id)) { fx = BLL.fanxianManager.SearchByfx_id(Convert.ToInt32(id)); if (state == "2") { fx.fx_date2 = DateTime.Now; } } else { fx.fx_date = DateTime.Now; } decimal temp_num; if (!decimal.TryParse(num, out temp_num)) { AJAXManager.Alert(UpdatePanel1, "请输入正确的金额"); Manager.TextBox_Select(txt_num); return; } fx.dpid = dianpu; fx.fx_account = account; fx.fx_num = temp_num; fx.fx_remark = remark; fx.fx_state = state; fx.fx_zhifubao = zhifubao; int res; if (string.IsNullOrEmpty(id)) { res = BLL.fanxianManager.Insert(fx); } else { res = BLL.fanxianManager.Update(fx); } if (res == 1) { AJAXManager.Alert(UpdatePanel1, "保存成功"); if (string.IsNullOrEmpty(id)) { txt_account.Text = ""; txt_num.Text = ""; txt_remark.Text = ""; txt_zhifubao.Text = ""; } } else { AJAXManager.Alert(UpdatePanel1, "保存失败"); } } catch (Exception ex) { AJAXManager.Alert(UpdatePanel1, ex.ToString()); } }
/// <summary> /// 更新 /// </summary> /// <param name="fanxian">fanxian表实例</param> /// <returns>int</returns> public int Update(fanxian fanxianExample) { DBHelper.sqlstr = "update fanxian set dpid=@dpid,fx_account=@fx_account,fx_date='" + fanxianExample.fx_date.ToString() + "',fx_date2='" + fanxianExample.fx_date2.ToString() + "',fx_num=@fx_num,fx_remark=@fx_remark,fx_state=@fx_state,fx_zhifubao=@fx_zhifubao where fx_id=" + fanxianExample.fx_id; return(DBHelper.ExecuteNonQuery(GetOleDbParameter(fanxianExample))); }
/// <summary> /// 插入方法 /// </summary> /// <param name="fanxian">fanxian表实例</param> /// <returns>int</returns> public int Insert(fanxian fanxianExample) { DBHelper.sqlstr = "insert into fanxian (dpid,fx_account,fx_date,fx_date2,fx_num,fx_remark,fx_state,fx_zhifubao)values(@dpid,@fx_account,'" + fanxianExample.fx_date.ToString() + "','" + fanxianExample.fx_date2.ToString() + "',fx_num,@fx_remark,@fx_state,@fx_zhifubao)"; return(DBHelper.ExecuteNonQuery(GetOleDbParameter(fanxianExample))); }
/// <summary> /// 更新 /// </summary> /// <param name="fanxian">fanxian表实例</param> /// <returns>int</returns> public static int Update(fanxian fanxianExample) { return(Service.Update(fanxianExample)); }