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