protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txt_ordercode = GridView1.Rows[e.RowIndex].FindControl("txt_ordercode") as TextBox; TextBox txt_name = GridView1.Rows[e.RowIndex].FindControl("txt_name") as TextBox; TextBox txt_account = GridView1.Rows[e.RowIndex].FindControl("txt_account") as TextBox; TextBox txt_yuanyin = GridView1.Rows[e.RowIndex].FindControl("txt_yuanyin") as TextBox; TextBox txt_kdcode = GridView1.Rows[e.RowIndex].FindControl("txt_kdcode") as TextBox; int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["shid"]); shouhou sh = BLL.shouhouManager.SearchByshid(id); sh.shordercode = txt_ordercode.Text.Trim(); sh.shname = txt_name.Text.Trim(); sh.shaccount = txt_account.Text.Trim(); sh.shkdcode = txt_kdcode.Text.Trim(); sh.shyuanyin = txt_yuanyin.Text.Trim(); if (BLL.shouhouManager.Update(sh) != 1) { AJAXManager.Alert(this.UpdatePanel1, "修改失败"); } else { GridView1.EditIndex = -1; bind_shouhou(); } }
void bind() { if (!string.IsNullOrEmpty(id)) { int temp = 0; if (int.TryParse(id, out temp)) { shouhou sh = shouhouManager.SearchByshid(temp); if (sh != null) { try { txt_account.Text = sh.shaccount; txt_kdcode.Text = sh.shkdcode; txt_kdphone.Text = sh.shytphone; txt_name.Text = sh.shname; txt_ordercode.Text = sh.shordercode; txt_phone.Text = sh.shphone; txt_remark.Text = sh.shremark; txt_yuanyin.Text = sh.shyuanyin; lbl_date.Text = sh.shdate.ToString(); ddl_dianpu.SelectedValue = sh.dpid.ToString(); ddl_state.SelectedValue = sh.shstate; } catch { } } } } }
/// <summary> /// 查询全部数据 /// </summary> /// <returns>IList</returns> /*查看是否为视图*/ public IList <shouhou> SearchAll() { DBHelper.sqlstr = "select * from shouhou order by shdate desc "; List <shouhou> list = new List <shouhou>(); MySqlDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { shouhou Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
/// <summary> /// 根据shid,查询一条数据 /// </summary> /// <param name="shid"></param> /// <returns></returns> public shouhou SearchByshid(int shid) { DBHelper.sqlstr = "select * from shouhou where shid = @shid"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("@shid", shid) }; MySqlDataReader reader = DBHelper.ExecuteReader(param); shouhou Obj = null; if (reader.Read()) { Obj = GetByReader(reader); } reader.Close(); return(Obj); }
/// <summary> /// 从一个MySqlDataReader里读数据 /// </summary> /// <param name="Reader">MySqlDataReader</param> /// <returns>shouhouExample</returns> public static shouhou GetByReader(MySqlDataReader Reader) { shouhou shouhouExample = new shouhou(); shouhouExample.dpid = Reader["dpid"] == DBNull.Value ? 0 : (int)Reader["dpid"]; shouhouExample.shaccount = Reader["shaccount"] == DBNull.Value ? null : Reader["shaccount"].ToString(); shouhouExample.shdate = Reader["shdate"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["shdate"]); shouhouExample.shid = Reader["shid"] == DBNull.Value ? 0 : (int)Reader["shid"]; shouhouExample.shkdcode = Reader["shkdcode"] == DBNull.Value ? null : Reader["shkdcode"].ToString(); shouhouExample.shname = Reader["shname"] == DBNull.Value ? null : Reader["shname"].ToString(); shouhouExample.shordercode = Reader["shordercode"] == DBNull.Value ? null : Reader["shordercode"].ToString(); shouhouExample.shphone = Reader["shphone"] == DBNull.Value ? null : Reader["shphone"].ToString(); shouhouExample.shremark = Reader["shremark"] == DBNull.Value ? null : Reader["shremark"].ToString(); shouhouExample.shstate = Reader["shstate"] == DBNull.Value ? null : Reader["shstate"].ToString(); shouhouExample.shytphone = Reader["shytphone"] == DBNull.Value ? null : Reader["shytphone"].ToString(); shouhouExample.shyuanyin = Reader["shyuanyin"] == DBNull.Value ? null : Reader["shyuanyin"].ToString(); return(shouhouExample); }
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["shid"].ToString()); if (id != 0) { shouhou sh = BLL.shouhouManager.SearchByshid(id); sh.shstate = (sh.shstate == "1" ? "2" : (sh.shstate == "2" ? "3" : "1")); if (BLL.shouhouManager.Update(sh) != 1) { AJAXManager.Alert(this.UpdatePanel1, "修改失败"); } else { GridView1.EditIndex = -1; bind_shouhou(); } } } }
/// <summary> /// 模糊查询 /// </summary> /// <param name="key">关键词</param> /// <param name="dpid">店铺ID</param> /// <param name="start">开始时间</param> /// <param name="end">结束时间</param> /// <param name="state">状态</param> /// <param name="orderby">排序</param> /// <returns></returns> public IList <shouhou> Search(int s, int e, string key, int dpid, DateTime start, DateTime end, string state, string orderby) { string sql = "select top " + (e - s + 1).ToString() + " * from shouhou where "; string sql1 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( shaccount like '%" + key + "%' or shname like '%" + key + "%' or shordercode like '%" + key + "%' or shphone like '%" + key + "%' or shremark like '%" + key + "%' or shyuanyin like '%" + key + "%' or shytphone like '%" + key + "%' or shkdcode like '%" + key + "%' ) "; string sql2 = dpid == 0 ? "" : " and dpid=" + dpid.ToString() + " "; string sql3 = string.IsNullOrEmpty(state) ? "" : " and shstate= '" + state + "' "; string sql4 = start == (new DateTime()) ? "" : " and datediff(d,'" + start.ToString() + "',shdate)>=0 "; string sql5 = end == (new DateTime()) ? "" : " and datediff(d,'" + end.ToString() + "',shdate)<=0 "; string sql7 = string.IsNullOrEmpty(orderby) ? " order by shdate desc " : " order by " + orderby; string sql6 = s == 1 ? "" : " and shid not in ( select top " + (s - 1).ToString() + " shid from shouhou where " + sql1 + sql2 + sql3 + sql4 + sql5 + sql7 + " ) "; DBHelper.sqlstr = sql + sql1 + sql2 + sql3 + sql4 + sql5 + sql6 + sql7; List <shouhou> list = new List <shouhou>(); SqlDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { shouhou Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
private void btn_save_Click(object sender, EventArgs e) { try { string id = lbl_id.Text.Trim(); DateTime dt = DateTime.Now; string account = txt_account.Text.Trim(); string because = txt_because.Text.Trim(); string name = txt_name.Text.Trim(); string phone = txt_phone.Text.Trim(); string remark = txt_remark.Text.Trim(); string state = cb_state.Text == "未处理" ? "0" : (cb_state.Text == "已投诉" ? "2" : "1"); string dianpu = cb_dianpu.SelectedValue != null?cb_dianpu.SelectedValue.ToString() : ""; string code = txt_code.Text.Trim(); string ytphone = txt_ytphone.Text.Trim(); string kdcode = txt_kdcode.Text.Trim(); shouhou sh = new shouhou(); if (!string.IsNullOrEmpty(id)) { sh = BLL2.shouhouManager.SearchByshid(Convert.ToInt32(id)); } if (string.IsNullOrEmpty(name)) { MessageBox.Show("请输入买家姓名"); txt_name.Focus(); return; } if (string.IsNullOrEmpty(account)) { MessageBox.Show("请输入买家账号"); txt_account.Focus(); return; } if (string.IsNullOrEmpty(phone)) { MessageBox.Show("请输入买家电话号码"); txt_phone.Focus(); return; } if (string.IsNullOrEmpty(code)) { MessageBox.Show("请输入订单号码"); txt_code.Focus(); return; } if (string.IsNullOrEmpty(dianpu)) { MessageBox.Show("请选择店铺"); cb_dianpu.Show(); return; } sh.shaccount = account; sh.dpid = Convert.ToInt32(dianpu); sh.shname = name; sh.shordercode = code; sh.shphone = phone; sh.shremark = remark; sh.shstate = state; sh.shyuanyin = because; sh.shdate = dt; sh.shytphone = ytphone; sh.shkdcode = kdcode; int res; if (string.IsNullOrEmpty(lbl_id.Text.Trim())) { res = BLL2.shouhouManager.Insert(sh); bind(); } else { res = BLL2.shouhouManager.Update(sh); if (res == 1) { 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)) { dataGridView1.Rows[ri].Cells[1].Value = sh.shordercode; dataGridView1.Rows[ri].Cells[2].Value = sh.shaccount; dataGridView1.Rows[ri].Cells[3].Value = sh.shname; dataGridView1.Rows[ri].Cells[4].Value = sh.shphone; dataGridView1.Rows[ri].Cells[5].Value = sh.shytphone; dataGridView1.Rows[ri].Cells[6].Value = sh.shstate == "0" ? "未处理" : (sh.shstate == "1" ? "已处理" : "已投诉"); dataGridView1.Rows[ri].Cells[7].Value = sh.shyuanyin; dataGridView1.Rows[ri].Cells[8].Value = sh.shdate.ToString(); } } } if (res == 1) { MessageBox.Show("保存成功"); } else { MessageBox.Show("保存失败"); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } //bind(); clears(); }
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 == 7) { if (int.TryParse(id, out idid)) { shouhou sh = BLL2.shouhouManager.SearchByshid(idid); sh.shstate = sh.shstate == "0" ? "2" : (sh.shstate == "2" ? "1" : "0"); if (BLL2.shouhouManager.Update(sh) == 1) { //bind(); if (sh.shstate == "0") { dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "未处理"; } else if (sh.shstate == "1") { dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "已处理"; } else if (sh.shstate == "2") { dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "已投诉"; } } else { MessageBox.Show("系统出错,请联系我"); } } } else if (temp == 6) { 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.shouhou sh = BLL2.shouhouManager.SearchByshid(idid); txt_name.Text = sh.shname; txt_remark.Text = sh.shremark; lbl_id.Text = sh.shid.ToString(); txt_account.Text = sh.shaccount; txt_because.Text = sh.shyuanyin; txt_code.Text = sh.shordercode; txt_phone.Text = sh.shphone; txt_remark.Text = sh.shremark; lbl_date.Text = sh.shdate.ToString(); txt_ytphone.Text = sh.shytphone; lbl_CellIndex.Text = e.ColumnIndex.ToString(); lbl_RowIndex.Text = e.RowIndex.ToString(); txt_kdcode.Text = sh.shkdcode; try { cb_dianpu.SelectedValue = sh.dpid; cb_state.Text = sh.shstate == "0" ? "未处理" : (sh.shstate == "1" ? "已处理" : "已投诉"); } catch { } } } } }
/// <summary> /// 更新 /// </summary> /// <param name="shouhou">shouhou表实例</param> /// <returns>int</returns> public static int Update(shouhou shouhouExample) { return(Service.Update(shouhouExample)); }
/// <summary> /// 插入方法 /// </summary> /// <param name="shouhou">shouhou表实例</param> /// <returns>int</returns> public static int Insert(shouhou shouhouExample) { return(Service.Insert(shouhouExample)); }
/// <summary> /// 更新 /// </summary> /// <param name="shouhou">shouhou表实例</param> /// <returns>int</returns> public int Update(shouhou shouhouExample) { DBHelper.sqlstr = "update shouhou set dpid=@dpid,shaccount=@shaccount,shdate='" + shouhouExample.shdate.ToString() + "',shkdcode=@shkdcode,shname=@shname,shordercode=@shordercode,shphone=@shphone,shremark=@shremark,shstate=@shstate,shytphone=@shytphone,shyuanyin=@shyuanyin where shid=" + shouhouExample.shid; return(DBHelper.ExecuteNonQuery(GetSqlParameter(shouhouExample))); }
/// <summary> /// 插入方法 /// </summary> /// <param name="shouhou">shouhou表实例</param> /// <returns>int</returns> public int Insert(shouhou shouhouExample) { DBHelper.sqlstr = "insert into shouhou (dpid,shaccount,shdate,shkdcode,shname,shordercode,shphone,shremark,shstate,shytphone,shyuanyin)values(@dpid,@shaccount,'" + shouhouExample.shdate.ToString() + "',@shkdcode,@shname,@shordercode,@shphone,@shremark,@shstate,@shytphone,@shyuanyin)"; return(DBHelper.ExecuteNonQuery(GetSqlParameter(shouhouExample))); }
/// <summary> /// 根据表,获取一个MySqlParameter数组 /// </summary> /// <returns>MySqlParameter[]</returns> public static MySqlParameter[] GetSqlParameter(shouhou shouhouExample) { List <MySqlParameter> list_param = new List <MySqlParameter>(); if (shouhouExample.dpid != 0) { list_param.Add(new MySqlParameter("@dpid", shouhouExample.dpid)); } else { list_param.Add(new MySqlParameter("@dpid", DBNull.Value)); } if (!string.IsNullOrEmpty(shouhouExample.shaccount)) { list_param.Add(new MySqlParameter("@shaccount", shouhouExample.shaccount)); } else { list_param.Add(new MySqlParameter("@shaccount", DBNull.Value)); } if (shouhouExample.shdate != new DateTime() && shouhouExample.shdate != null) { list_param.Add(new MySqlParameter("@shdate", shouhouExample.shdate.ToString("yyyy-MM-dd"))); } else { list_param.Add(new MySqlParameter("@shdate", DBNull.Value)); } if (!string.IsNullOrEmpty(shouhouExample.shkdcode)) { list_param.Add(new MySqlParameter("@shkdcode", shouhouExample.shkdcode)); } else { list_param.Add(new MySqlParameter("@shkdcode", DBNull.Value)); } if (!string.IsNullOrEmpty(shouhouExample.shname)) { list_param.Add(new MySqlParameter("@shname", shouhouExample.shname)); } else { list_param.Add(new MySqlParameter("@shname", DBNull.Value)); } if (!string.IsNullOrEmpty(shouhouExample.shordercode)) { list_param.Add(new MySqlParameter("@shordercode", shouhouExample.shordercode)); } else { list_param.Add(new MySqlParameter("@shordercode", DBNull.Value)); } if (!string.IsNullOrEmpty(shouhouExample.shphone)) { list_param.Add(new MySqlParameter("@shphone", shouhouExample.shphone)); } else { list_param.Add(new MySqlParameter("@shphone", DBNull.Value)); } if (!string.IsNullOrEmpty(shouhouExample.shremark)) { list_param.Add(new MySqlParameter("@shremark", shouhouExample.shremark)); } else { list_param.Add(new MySqlParameter("@shremark", DBNull.Value)); } if (!string.IsNullOrEmpty(shouhouExample.shstate)) { list_param.Add(new MySqlParameter("@shstate", shouhouExample.shstate)); } else { list_param.Add(new MySqlParameter("@shstate", DBNull.Value)); } if (!string.IsNullOrEmpty(shouhouExample.shytphone)) { list_param.Add(new MySqlParameter("@shytphone", shouhouExample.shytphone)); } else { list_param.Add(new MySqlParameter("@shytphone", DBNull.Value)); } if (!string.IsNullOrEmpty(shouhouExample.shyuanyin)) { list_param.Add(new MySqlParameter("@shyuanyin", shouhouExample.shyuanyin)); } else { list_param.Add(new MySqlParameter("@shyuanyin", DBNull.Value)); } MySqlParameter[] param = new MySqlParameter[list_param.Count]; int index = 0; foreach (MySqlParameter 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 because = txt_yuanyin.Text.Trim(); string name = txt_name.Text.Trim(); string phone = txt_phone.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 code = txt_ordercode.Text.Trim(); string ytphone = txt_kdphone.Text.Trim(); string kdcode = txt_kdcode.Text.Trim(); shouhou sh = new shouhou(); if (!string.IsNullOrEmpty(id)) { sh = BLL.shouhouManager.SearchByshid(Convert.ToInt32(id)); } //if (string.IsNullOrEmpty(name)) //{ // Manager.Alert("请输入买家姓名"); // Manager.TextBox_Select(txt_name); // return; //} if (string.IsNullOrEmpty(account)) { AJAXManager.Alert(UpdatePanel1, "请输入买家账号"); Manager.TextBox_Select(txt_account); return; } //if (string.IsNullOrEmpty(phone)) //{ // Manager.Alert("请输入买家电话号码"); // Manager.TextBox_Select(txt_phone); // return; //} //if (string.IsNullOrEmpty(code)) //{ // Manager.Alert("请输入订单号码"); // Manager.TextBox_Select(txt_ordercode); // return; //} if (string.IsNullOrEmpty(dianpu)) { AJAXManager.Alert(UpdatePanel1, "请选择店铺"); ddl_dianpu.Focus(); return; } sh.shaccount = account; sh.dpid = Convert.ToInt32(dianpu); sh.shname = name; sh.shordercode = code; sh.shphone = phone; sh.shremark = remark; sh.shstate = state; sh.shyuanyin = because; sh.shdate = dt; sh.shytphone = ytphone; sh.shkdcode = kdcode; int res; if (string.IsNullOrEmpty(id)) { res = BLL.shouhouManager.Insert(sh); bind(); } else { res = BLL.shouhouManager.Update(sh); } if (res == 1) { AJAXManager.Alert(UpdatePanel1, "保存成功"); if (string.IsNullOrEmpty(id)) { clear(); } } else { AJAXManager.Alert(UpdatePanel1, "保存失败"); } } catch (Exception ex) { AJAXManager.Alert(UpdatePanel1, ex.ToString()); } }