/// <summary> /// 从一个OleDbDataReader里读数据 /// </summary> /// <param name="Reader">OleDbDataReader</param> /// <returns>dianpuExample</returns> public static dianpu GetByReader(OleDbDataReader Reader) { dianpu dianpuExample = new dianpu(); dianpuExample.dpid = Reader["dpid"] == DBNull.Value ? 0 : (int)Reader["dpid"]; dianpuExample.dpname = Reader["dpname"] == DBNull.Value ? null : Reader["dpname"].ToString(); dianpuExample.dpremark = Reader["dpremark"] == DBNull.Value ? null : Reader["dpremark"].ToString(); dianpuExample.dpsort = Reader["dpsort"] == DBNull.Value ? 0 : (int)Reader["dpsort"]; dianpuExample.dpstate = Reader["dpstate"] == DBNull.Value ? null : Reader["dpstate"].ToString(); return(dianpuExample); }
void bind_dianpu() { IList <dianpu> list_dp = BLL2.dianpuManager.SearchAll(); cb_dianpu.DataSource = list_dp; IList <dianpu> list_dp2 = BLL2.dianpuManager.SearchAll(); dianpu dp = new dianpu(); dp.dpname = "请选择"; dp.dpid = 0; list_dp2.Insert(0, dp); cb_dianpu2.DataSource = list_dp2; }
void bind() { IList <dianpu> list = BLL2.dianpuManager.SearchAll(true); //cb_dianpu.DataSource = list; dianpu dp = new dianpu(); dp.dpname = "请选择"; dp.dpid = 0; list.Insert(0, dp); cb_dianpu.DataSource = list; cb_dianpu.DisplayMember = "dpname";//绑定泛型中类的属性 cb_dianpu.ValueMember = "dpid"; }
/// <summary> /// 绑定店铺 /// </summary> /// <param name="cb_dianpu">ComboBox控件</param> /// <param name="has">是否添加‘请选择’选项</param> public static void bind_dianpu(ComboBox cb_dianpu, bool has) { IList <dianpu> list_dp2 = BLL2.dianpuManager.SearchAll(); if (has) { dianpu dp = new dianpu(); dp.dpname = "请选择"; dp.dpid = 0; list_dp2.Insert(0, dp); } cb_dianpu.DataSource = list_dp2; }
/// <summary> /// 查询全部数据 /// </summary> /// <returns>IList</returns> /*查看是否为视图*/ public IList <dianpu> SearchAll() { DBHelper.sqlstr = "select * from dianpu order by dpsort asc "; List <dianpu> list = new List <dianpu>(); SqlDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { dianpu Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
/// <summary> /// 查询全部数据 /// </summary> /// <returns>IList</returns> /*查看是否为视图*/ public IList <dianpu> SearchAll(bool isState) { DBHelper.sqlstr = "select * from dianpu " + (isState ? " where dpstate = '1' " : "") + " order by dpsort asc "; List <dianpu> list = new List <dianpu>(); OleDbDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { dianpu Obj = GetByReader(reader); list.Add(Obj); } reader.Close(); return(list); }
/// <summary> /// 根据表,获取一个OleDbParameter数组 /// </summary> /// <returns>OleDbParameter[]</returns> public static OleDbParameter[] GetOleDbParameter(dianpu dianpuExample) { List <OleDbParameter> list_param = new List <OleDbParameter>(); if (!string.IsNullOrEmpty(dianpuExample.dpname)) { list_param.Add(new OleDbParameter("@dpname", dianpuExample.dpname)); } else { list_param.Add(new OleDbParameter("@dpname", DBNull.Value)); } if (!string.IsNullOrEmpty(dianpuExample.dpremark)) { list_param.Add(new OleDbParameter("@dpremark", dianpuExample.dpremark)); } else { list_param.Add(new OleDbParameter("@dpremark", DBNull.Value)); } if (dianpuExample.dpsort != 0) { list_param.Add(new OleDbParameter("@dpsort", dianpuExample.dpsort)); } else { list_param.Add(new OleDbParameter("@dpsort", DBNull.Value)); } if (!string.IsNullOrEmpty(dianpuExample.dpstate)) { list_param.Add(new OleDbParameter("@dpstate", dianpuExample.dpstate)); } else { list_param.Add(new OleDbParameter("@dpstate", DBNull.Value)); } OleDbParameter[] param = new OleDbParameter[list_param.Count]; int index = 0; foreach (OleDbParameter p in list_param) { param[index] = p; index++; } return(param); }
/// <summary> /// 根据编号获取补单方案 /// </summary> /// <param name="opid"></param> /// <returns></returns> public static dianpu GetInList(string opid) { dianpu op = null; IList <dianpu> list = GetList(false); foreach (dianpu dp in list) { if (dp.dpid.ToString() == opid) { op = dp; break; } } return(op); }
/// <summary> /// 根据dpid,查询一条数据 /// </summary> /// <param name="dpid"></param> /// <returns></returns> public dianpu SearchBydpid(int dpid) { Access.DBHelper.sqlstr = "select * from dianpu where dpid = @dpid"; OleDbParameter[] param = new OleDbParameter[] { new OleDbParameter("@dpid", dpid) }; OleDbDataReader reader = Access.DBHelper.ExecuteReader(param); dianpu 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(); string remark = txt_remark.Text.Trim(); string state = ddl_state.SelectedValue.ToString(); string sort = txt_sort.Text.Trim(); dianpu dp = new dianpu(); if (!string.IsNullOrEmpty(id)) { dp = BLL.dianpuManager.SearchBydpid(Convert.ToInt32(id)); } int sort2 = 0; int.TryParse(sort, out sort2); dp.dpname = name; dp.dpremark = remark; dp.dpsort = sort2; dp.dpstate = state; int res; if (string.IsNullOrEmpty(id)) { res = BLL.dianpuManager.Insert(dp); } else { res = BLL.dianpuManager.Update(dp); } if (res == 1) { Manager.Alert("保存成功", Page); } else { Manager.Alert("保存失败", Page); } } catch (Exception ex) { Manager.Alert(ex.ToString(), Page); } Manager.page_href_reload(Page); }
/// <summary> /// 从一个SqlDataReader里读数据 /// </summary> /// <param name="Reader">SqlDataReader</param> /// <returns>dianpuExample</returns> public static dianpu GetByReader(SqlDataReader Reader) { dianpu dianpuExample = new dianpu(); dianpuExample.dpid = Reader["dpid"] == DBNull.Value ? 0 : (int)Reader["dpid"]; dianpuExample.dpname = Reader["dpname"] == DBNull.Value ? null : Reader["dpname"].ToString(); dianpuExample.dpremark = Reader["dpremark"] == DBNull.Value ? null : Reader["dpremark"].ToString(); dianpuExample.dpstate = Reader["dpstate"] == DBNull.Value ? null : Reader["dpstate"].ToString(); dianpuExample.dpsort = Reader["dpsort"] == DBNull.Value ? 0 : (int)Reader["dpsort"]; dianpuExample.dpaccount = Reader["dpaccount"] == DBNull.Value ? null : Reader["dpaccount"].ToString(); dianpuExample.dppwd = Reader["dppwd"] == DBNull.Value ? null : Reader["dppwd"].ToString(); dianpuExample.dpremark1 = Reader["dpremark1"] == DBNull.Value ? null : Reader["dpremark1"].ToString(); dianpuExample.dpremark2 = Reader["dpremark2"] == DBNull.Value ? null : Reader["dpremark2"].ToString(); dianpuExample.dpremark3 = Reader["dpremark3"] == DBNull.Value ? null : Reader["dpremark3"].ToString(); dianpuExample.dpremark4 = Reader["dpremark4"] == DBNull.Value ? null : Reader["dpremark4"].ToString(); return(dianpuExample); }
private void dataGridView1_CellParsing(object sender, DataGridViewCellParsingEventArgs e) { try { //int i = dgv_title.CurrentCell.ColumnIndex; string colname = dataGridView1.Columns[dataGridView1.CurrentCell.ColumnIndex].Name; string dataname = dataGridView1.Columns[dataGridView1.CurrentCell.ColumnIndex].DataPropertyName; if (dataname.Equals("dpname") || dataname.Equals("dpremark") || dataname.Equals("dpaccount") || dataname.Equals("dppwd") || dataname.Equals("dpremark1") || dataname.Equals("dpremark2") || dataname.Equals("dpsort")) { dianpu dp = (dianpu)dataGridView1.CurrentRow.DataBoundItem; if (dp != null) { string c_name = dataGridView1["c_name", e.RowIndex].EditedFormattedValue == null ? "" : dataGridView1["c_name", e.RowIndex].EditedFormattedValue.ToString(); string col_account = dataGridView1["col_account", e.RowIndex].EditedFormattedValue == null ? "" : dataGridView1["col_account", e.RowIndex].EditedFormattedValue.ToString(); string col_pwd = dataGridView1["col_pwd", e.RowIndex].EditedFormattedValue == null ? "" : dataGridView1["col_pwd", e.RowIndex].EditedFormattedValue.ToString(); string col_phone = dataGridView1["col_phone", e.RowIndex].EditedFormattedValue == null ? "" : dataGridView1["col_phone", e.RowIndex].EditedFormattedValue.ToString(); string col_remark = dataGridView1["col_remark", e.RowIndex].EditedFormattedValue == null ? "" : dataGridView1["col_remark", e.RowIndex].EditedFormattedValue.ToString(); string c_remark = dataGridView1["c_remark", e.RowIndex].EditedFormattedValue == null ? "" : dataGridView1["c_remark", e.RowIndex].EditedFormattedValue.ToString(); string col_sort = dataGridView1["col_sort", e.RowIndex].EditedFormattedValue == null ? "" : dataGridView1["col_sort", e.RowIndex].EditedFormattedValue.ToString(); dp.dpaccount = col_account; dp.dpname = c_name; dp.dppwd = col_pwd; dp.dpremark1 = col_phone; dp.dpremark2 = col_remark; dp.dpremark = c_remark; int temp = 0; int.TryParse(col_sort, out temp); dp.dpsort = temp; BLL2.dianpuManager.Update(dp); } } } catch (Exception ex) { Debug.WriteLine("修改信息失败 " + ex.Message); } }
/// <summary> /// 模糊搜索 /// </summary> /// <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<dianpu></returns> public IList <dianpu> Search(int s, int e, string key, string state, string orderby) { string sql1 = "select top " + (e - s + 1).ToString() + " * from dianpu where "; string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( dpname like '%" + key + "%' or dpremark like '%" + key + "%' or dpstate like '%" + key + "%' or dpaccount like '%" + key + "%' or dppwd like '%" + key + "%' or dpremark1 like '%" + key + "%' or dpremark2 like '%" + key + "%' or dpremark3 like '%" + key + "%' or dpremark4 like '%" + key + "%' )"; //删除无用字段,删除最后一个or string sql3 = string.IsNullOrEmpty(state) ? "" : " and dpstate= '" + state + "' "; //状态字段,无用删除 string sql7 = string.IsNullOrEmpty(orderby) ? " order by dpid desc " : " order by " + orderby; string sql8 = s == 1 ? "" : " and dpid not in ( select top " + (s - 1).ToString() + " dpid from dianpu where " + sql2 + sql3 + sql7 + " ) "; DBHelper.sqlstr = sql1 + sql2 + sql3 + sql8 + sql7; List <dianpu> list = new List <dianpu>(); OleDbDataReader reader = DBHelper.ExecuteReader(); while (reader.Read()) { dianpu 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)) { dianpu dp = dianpuManager.SearchBydpid(temp); if (dp != null) { try { txt_name.Text = dp.dpname; txt_remark.Text = dp.dpremark; txt_sort.Text = dp.dpsort.ToString(); ddl_state.SelectedValue = dp.dpstate; } catch { } } } } }
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["dpid"].ToString()); if (id != 0) { dianpu dp = BLL.dianpuManager.SearchBydpid(id); dp.dpstate = dp.dpstate == "1" ? "2" : "1"; if (BLL.dianpuManager.Update(dp) != 1) { AJAXManager.Alert(this.UpdatePanel1, "修改失败"); } else { bind(); } } } }
private void cb_dianpu_SelectedIndexChanged(object sender, EventArgs e) { string dpid_temp = cb_dianpu.SelectedValue.ToString(); int dpid = 0; if (dpid_temp != "0") { if (int.TryParse(dpid_temp, out dpid)) { dianpu dp = BLL2.dianpuManager.SearchBydpid(dpid); if (dp != null) { dpname = dp.dpname; //if (dp.dpname == "蘑菇街") //{ // //CS.Mogujie.Login(dp.dpaccount, dp.dppwd, webBrowser1); //} //else if (dp.dpname == "美丽说") //{ //} //else //{ //CS.Taobao.Login(dp.dpaccount, dp.dppwd, webBrowser1); try { account = dp.dpaccount; pwd = dp.dppwd; } catch { } //} //鼠标移动到按钮上 //Auto.MoveMouseToPoint(btn_logined.PointToScreen(new Point(90, 15))); Auto.MoveMouseToPoint(btn_account.PointToScreen(new Point(90, 15))); } } } }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txt_name = GridView1.Rows[e.RowIndex].FindControl("txt_name") as TextBox; TextBox txt_remark = GridView1.Rows[e.RowIndex].FindControl("txt_remark") as TextBox; TextBox txt_sort = GridView1.Rows[e.RowIndex].FindControl("txt_sort") as TextBox; int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["dpid"]); dianpu dp = BLL.dianpuManager.SearchBydpid(id); dp.dpname = string.IsNullOrEmpty(txt_name.Text) ? "" : txt_name.Text.Trim(); dp.dpremark = string.IsNullOrEmpty(txt_name.Text) ? "" : txt_remark.Text.Trim(); //dp.dpsort = string.IsNullOrEmpty(txt_sort.Text) ? "" : txt_sort.Text.Trim(); if (BLL.dianpuManager.Update(dp) != 1) { AJAXManager.Alert(this.UpdatePanel1, "修改失败"); } else { GridView1.EditIndex = -1; bind(); } }
/// <summary> /// 插入方法 /// </summary> /// <param name="dianpu">dianpu表实例</param> /// <returns>int</returns> public int Insert(dianpu dianpuExample) { DBHelper.sqlstr = "insert into dianpu (dpname,dpremark,dpstate,dpsort,dpaccount,dppwd,dpremark1,dpremark2,dpremark3,dpremark4)values(@dpname,@dpremark,@dpstate,@dpsort,@dpaccount,@dppwd,@dpremark1,@dpremark2,@dpremark3,@dpremark4)"; return(DBHelper.ExecuteNonQuery(GetSqlParameters(dianpuExample))); }
/// <summary> /// 插入方法 /// </summary> /// <param name="dianpu">dianpu表实例</param> /// <returns>int</returns> public int Insert(dianpu dianpuExample) { Access.DBHelper.sqlstr = "insert into dianpu (dpname,dpremark,dpsort,dpstate)values(@dpname,@dpremark,@dpsort,@dpstate)"; return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(dianpuExample))); }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { try { //如果不是首行 if (e.RowIndex > -1) { string colname = dataGridView1.Columns[e.ColumnIndex].Name; dianpu dp = (dianpu)dataGridView1.CurrentRow.DataBoundItem; txt_name.Text = dp.dpname; txt_remark.Text = dp.dpremark; lbl_id.Text = dp.dpid.ToString(); lbl_db.Text = dp.dpstate; if (colname == "col_state") { #region 修改状态 dp.dpstate = dp.dpstate == "1" ? "0" : "1"; BLL2.dianpuManager.Update(dp); //取消选中 //dgv1.Columns[e.ColumnIndex].Selected = false; dataGridView1.CurrentCell = null; //DataGridView.CurrentCell = null; dataGridView1.Refresh(); #endregion } else if (colname == "test2") { } } //else if (e.RowIndex == -1) //{ // //如果是首行 // #region 全选 // //如果是全选 // if (e.ColumnIndex == 0) // { // foreach (DataGridViewRow row in dgv1.Rows) // { // if (row.Index != -1) // { // DataGridViewCheckBoxCell cbx = (DataGridViewCheckBoxCell)row.Cells[0]; // cbx.Value = allselect == 0 ? true : false; // } // } // allselect = allselect == 1 ? 0 : 1; // } // #endregion //} } catch (Exception ex) { MessageBox.Show(ex.Message); } //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)) // { // Entity.dianpu dp = dianpuManager.SearchBydpid(idid); // dp.dpstate = dp.dpstate == "1" ? "0" : "1"; // dianpuManager.Update(dp); // bind(); // } // } // if (temp == 3) // { // if (e.RowIndex != 0) // { // string id2 = dataGridView1.Rows[e.RowIndex - 1].Cells[0].Value.ToString(); // int temp_id2; // if (int.TryParse(id, out idid) && int.TryParse(id2, out temp_id2)) // { // Entity.dianpu dp1 = dianpuManager.SearchBydpid(idid); // Entity.dianpu dp2 = dianpuManager.SearchBydpid(temp_id2); // string temp_sort = dp1.dpsort; // dp1.dpsort = dp2.dpsort; // dp2.dpsort = temp_sort; // dianpuManager.Update(dp1); // dianpuManager.Update(dp2); // bind(); // } // } // } // else // { // if (int.TryParse(id, out idid)) // { // Entity.dianpu dp = dianpuManager.SearchBydpid(idid); // txt_name.Text = dp.dpname; // txt_remark.Text = dp.dpremark; // lbl_id.Text = dp.dpid.ToString(); // lbl_db.Text = dp.dpstate; // } // } //} }
/// <summary> /// 插入方法 /// </summary> /// <param name="dianpu">dianpu表实例</param> /// <returns>int</returns> public static int Insert(dianpu dianpuExample) { return(Service.Insert(dianpuExample)); }
/// <summary> /// 更新 /// </summary> /// <param name="dianpu">dianpu表实例</param> /// <returns>int</returns> public int Update(dianpu dianpuExample) { DBHelper.sqlstr = "update dianpu set dpname=@dpname,dpremark=@dpremark,dpstate=@dpstate,dpsort=@dpsort,dpaccount=@dpaccount,dppwd=@dppwd,dpremark1=@dpremark1,dpremark2=@dpremark2,dpremark3=@dpremark3,dpremark4=@dpremark4 where dpid=" + dianpuExample.dpid; return(DBHelper.ExecuteNonQuery(GetSqlParameters(dianpuExample))); }
/// <summary> /// 根据表,获取一个SqlParameter数组 /// </summary> /// <returns>SqlParameter[]</returns> public static SqlParameter[] GetSqlParameters(dianpu dianpuExample) { List <SqlParameter> list_param = new List <SqlParameter>(); if (!string.IsNullOrEmpty(dianpuExample.dpname)) { list_param.Add(new SqlParameter("@dpname", dianpuExample.dpname)); } else { list_param.Add(new SqlParameter("@dpname", DBNull.Value)); } if (!string.IsNullOrEmpty(dianpuExample.dpremark)) { list_param.Add(new SqlParameter("@dpremark", dianpuExample.dpremark)); } else { list_param.Add(new SqlParameter("@dpremark", DBNull.Value)); } if (!string.IsNullOrEmpty(dianpuExample.dpstate)) { list_param.Add(new SqlParameter("@dpstate", dianpuExample.dpstate)); } else { list_param.Add(new SqlParameter("@dpstate", DBNull.Value)); } if (dianpuExample.dpsort != 0) { list_param.Add(new SqlParameter("@dpsort", dianpuExample.dpsort)); } else { list_param.Add(new SqlParameter("@dpsort", DBNull.Value)); } if (!string.IsNullOrEmpty(dianpuExample.dpaccount)) { list_param.Add(new SqlParameter("@dpaccount", dianpuExample.dpaccount)); } else { list_param.Add(new SqlParameter("@dpaccount", DBNull.Value)); } if (!string.IsNullOrEmpty(dianpuExample.dppwd)) { list_param.Add(new SqlParameter("@dppwd", dianpuExample.dppwd)); } else { list_param.Add(new SqlParameter("@dppwd", DBNull.Value)); } if (!string.IsNullOrEmpty(dianpuExample.dpremark1)) { list_param.Add(new SqlParameter("@dpremark1", dianpuExample.dpremark1)); } else { list_param.Add(new SqlParameter("@dpremark1", DBNull.Value)); } if (!string.IsNullOrEmpty(dianpuExample.dpremark2)) { list_param.Add(new SqlParameter("@dpremark2", dianpuExample.dpremark2)); } else { list_param.Add(new SqlParameter("@dpremark2", DBNull.Value)); } if (!string.IsNullOrEmpty(dianpuExample.dpremark3)) { list_param.Add(new SqlParameter("@dpremark3", dianpuExample.dpremark3)); } else { list_param.Add(new SqlParameter("@dpremark3", DBNull.Value)); } if (!string.IsNullOrEmpty(dianpuExample.dpremark4)) { list_param.Add(new SqlParameter("@dpremark4", dianpuExample.dpremark4)); } else { list_param.Add(new SqlParameter("@dpremark4", DBNull.Value)); } SqlParameter[] param = new SqlParameter[list_param.Count]; int index = 0; foreach (SqlParameter p in list_param) { param[index] = p; index++; } return(param); }
/// <summary> /// 更新 /// </summary> /// <param name="dianpu">dianpu表实例</param> /// <returns>int</returns> public int Update(dianpu dianpuExample) { Access.DBHelper.sqlstr = "update dianpu set dpname=@dpname,dpremark=@dpremark,dpsort=@dpsort,dpstate=@dpstate where dpid=" + dianpuExample.dpid; return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(dianpuExample))); }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (AJAXManager.GridView_ondblclick(e)) { try { string State = GridView1.DataKeys[e.Row.RowIndex].Values["orprepare1"].ToString(); string dianpu = GridView1.DataKeys[e.Row.RowIndex].Values["dpid"].ToString(); //string orid = GridView1.DataKeys[e.Row.RowIndex].Values["orid"].ToString(); //string bgid = GridView1.DataKeys[e.Row.RowIndex].Values["bgid"].ToString(); string ormaijiaxiu = GridView1.DataKeys[e.Row.RowIndex].Values["ormaijiaxiu"].ToString(); //string orqq = GridView1.DataKeys[e.Row.RowIndex].Values["orqq"].ToString(); //string orwangwang = GridView1.DataKeys[e.Row.RowIndex].Values["orwangwang"].ToString(); LinkButton lb_state = e.Row.FindControl("lb_state") as LinkButton; LinkButton lb_maijiaxiu = e.Row.FindControl("lb_maijiaxiu") as LinkButton; Label lbl_dianpu = e.Row.FindControl("lbl_dianpu") as Label; //状态 if (State == "1") { lb_state.Text = "已评价"; lb_state.ForeColor = System.Drawing.Color.Blue; } else if (State == "2") { lb_state.Text = "未评价"; lb_state.ForeColor = System.Drawing.Color.Red; lb_state.Font.Bold = true; } //买家秀 if (ormaijiaxiu == "1") { lb_maijiaxiu.Text = "是"; lb_maijiaxiu.ForeColor = System.Drawing.Color.Red; lb_maijiaxiu.Font.Bold = true; } else if (ormaijiaxiu == "2") { lb_maijiaxiu.Text = "否"; lb_maijiaxiu.ForeColor = System.Drawing.Color.Blue; } //店铺 dianpu dp = dianpuManager.GetInList(dianpu); if (dp != null) { lbl_dianpu.Text = dp.dpname; lbl_dianpu.ForeColor = System.Drawing.Color.Green; } //判断是否是编辑状态 if (GridView1.EditIndex != e.Row.RowIndex) { HyperLink lb_wangwang = e.Row.FindControl("lb_wangwang") as HyperLink; lb_wangwang.NavigateUrl = "http://www.taobao.com/webww/ww.php?ver=3&touid=" + lb_wangwang.Text + "&siteid=cntaobao&status=1&charset=utf-8"; lb_wangwang.ForeColor = System.Drawing.Color.Blue; HyperLink lb_qq = e.Row.FindControl("lb_qq") as HyperLink; lb_qq.NavigateUrl = "tencent://message/?uin=" + lb_qq.Text + "&Site=我的网站&Menu=yes"; lb_qq.ForeColor = System.Drawing.Color.Blue; } } catch (Exception ex) { Common.ErrorLog.WriteEntry(ex); } } }
protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e) { //try //{ if (AJAXManager.GridView_ondblclick(e)) { try { string State = GridView2.DataKeys[e.Row.RowIndex].Values["bgstate"].ToString(); string dpid = GridView2.DataKeys[e.Row.RowIndex].Values["dpid"].ToString(); string bgid = GridView2.DataKeys[e.Row.RowIndex].Values["bgid"].ToString(); string hdid = GridView2.DataKeys[e.Row.RowIndex].Values["hdid"].ToString(); string bgkey = GridView2.DataKeys[e.Row.RowIndex].Values["bgkey"].ToString(); string opid = GridView2.DataKeys[e.Row.RowIndex].Values["opid"].ToString(); string bgupdate = GridView2.DataKeys[e.Row.RowIndex].Values["bgupdate"].ToString(); DateTime up_date = new DateTime(); DateTime.TryParse(bgupdate, out up_date); LinkButton lb_state = e.Row.FindControl("lb_state") as LinkButton; LinkButton lb_key = e.Row.FindControl("lb_key") as LinkButton; Label lbl_dianpu = e.Row.FindControl("lbl_dianpu") as Label; Label lbl_order = e.Row.FindControl("lbl_order") as Label; Label lbl_huodong = e.Row.FindControl("lbl_huodong") as Label; //补单 int temp_order = basic_order_planManager.GetNumInPlan(up_date, Convert.ToInt32(opid)); int _order_count = BLL.basic_order_recordManager.SearchNum("", Convert.ToInt32(bgid), 0, 0, "", "", DateTime.Now, DateTime.Now); int res_count = temp_order - _order_count; if (res_count > 0) { lbl_order.Text = "需补 " + (temp_order - _order_count).ToString() + " 单"; lbl_order.ForeColor = System.Drawing.Color.Red; lbl_order.Font.Bold = true; } else { lbl_order.Text = "无"; lbl_order.ForeColor = System.Drawing.Color.Black; } //活动提示 basic_huodong hd = basic_huodongManager.SearchByID(Convert.ToInt32(hdid)); int temp_huodong = Manager.DateDiff_GetInt(DateTime.Now, up_date) + 1; if (temp_huodong == hd.hdone || temp_huodong == hd.hdtwo) { lbl_huodong.Text = "今日" + hd.hddate1.ToString("HH:mm") + "报名"; lbl_huodong.ForeColor = System.Drawing.Color.Red; lbl_huodong.Font.Bold = true; } else { lbl_huodong.Text = "无"; lbl_huodong.ForeColor = System.Drawing.Color.Black; } //状态 if (State == "1") { lb_state.Text = "启用"; lb_state.ForeColor = System.Drawing.Color.Red; //lb_state.Font.Bold = true; } else if (State == "2") { lb_state.Text = "禁用"; lb_state.ForeColor = System.Drawing.Color.Blue; } //是否重点 if (bgkey == "1") { lb_key.Text = "是"; lb_key.ForeColor = System.Drawing.Color.Red; lb_key.Font.Bold = true; } else if (bgkey == "2") { lb_key.Text = "否"; lb_key.ForeColor = System.Drawing.Color.Blue; } //店铺 dianpu dp = BLL.dianpuManager.GetInList(dpid); if (dp != null) { lbl_dianpu.Text = dp.dpname; lbl_dianpu.ForeColor = System.Drawing.Color.Green; // lb_account.NavigateUrl = "http://www.taobao.com/webww/ww.php?ver=3&touid=" + lb_account.Text + "&siteid=cntaobao&status=1&charset=utf-8"; } //判断是否是编辑状态 if (GridView2.EditIndex != e.Row.RowIndex) { //LinkButton lb_zhifubao = e.Row.FindControl("lb_zhifubao") as LinkButton; //HyperLink lb_account = e.Row.FindControl("lb_account") as HyperLink; //lb_account.NavigateUrl = "http://www.taobao.com/webww/ww.php?ver=3&touid=" + lb_account.Text + "&siteid=cntaobao&status=1&charset=utf-8"; //lb_account.ForeColor = System.Drawing.Color.Blue; } } catch (Exception ex) { Common.ErrorLog.WriteEntry(ex); } } }
/// <summary> /// 更新 /// </summary> /// <param name="dianpu">dianpu表实例</param> /// <returns>int</returns> public static int Update(dianpu dianpuExample) { return(Service.Update(dianpuExample)); }