protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (AJAXManager.GridView_ondblclick(e))
{
try
{
string State = GridView1.DataKeys[e.Row.RowIndex].Values["pstate"].ToString();
int ptid = Convert.ToInt32(GridView1.DataKeys[e.Row.RowIndex].Values["ptid"]);
LinkButton lb_state = e.Row.FindControl("lb_state") as LinkButton;
Label lbl_type = e.Row.FindControl("lbl_type") 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;
}
pages_type pt = BLL.pages_typeManager.SearchByID(ptid);
if (pt != null)
{
lbl_type.Text = pt.ptname;
}
}
catch (Exception ex) { Common.ErrorLog.WriteEntry(ex); }
}
}
/// <summary>
/// 从一个OleDbDataReader里读数据
/// </summary>
/// <param name="Reader">OleDbDataReader</param>
/// <returns>pages_typeExample</returns>
public static pages_type GetByReader(OleDbDataReader Reader)
{
pages_type pages_typeExample = new pages_type();
pages_typeExample.ptdate = Reader["ptdate"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["ptdate"]);
pages_typeExample.ptid = Reader["ptid"] == DBNull.Value ? 0 : (int)Reader["ptid"];
pages_typeExample.ptname = Reader["ptname"] == DBNull.Value ? null : Reader["ptname"].ToString();
pages_typeExample.ptremark = Reader["ptremark"] == DBNull.Value ? null : Reader["ptremark"].ToString();
pages_typeExample.ptsort = Reader["ptsort"] == DBNull.Value ? 0 : (int)Reader["ptsort"];
pages_typeExample.ptstate = Reader["ptstate"] == DBNull.Value ? null : Reader["ptstate"].ToString();
return(pages_typeExample);
}
/// <summary>
/// 查询全部数据
/// </summary>
/// <returns>IList</returns>
/*查看是否为视图*/
public IList <pages_type> SearchAll()
{
Access.DBHelper.sqlstr = "select * from pages_type order by ptsort asc ";
List <pages_type> list = new List <pages_type>();
OleDbDataReader reader = Access.DBHelper.ExecuteReader();
while (reader.Read())
{
pages_type Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
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();
pages_type dp = new pages_type();
if (!string.IsNullOrEmpty(id))
{
dp = BLL.pages_typeManager.SearchByID(Convert.ToInt32(id));
}
else
{
dp.ptdate = DateTime.Now;
}
dp.ptname = name;
dp.ptremark = remark;
dp.ptsort = Convert.ToInt32(sort);
dp.ptstate = state;
int res;
if (string.IsNullOrEmpty(id))
{
res = BLL.pages_typeManager.Insert(dp);
}
else
{
res = BLL.pages_typeManager.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>
/// 根据表,获取一个OleDbParameter数组
/// </summary>
/// <returns>OleDbParameter[]</returns>
public static OleDbParameter[] GetOleDbParameter(pages_type pages_typeExample)
{
List <OleDbParameter> list_param = new List <OleDbParameter>();
if (!string.IsNullOrEmpty(pages_typeExample.ptname))
{
list_param.Add(new OleDbParameter("@ptname", pages_typeExample.ptname));
}
else
{
list_param.Add(new OleDbParameter("@ptname", DBNull.Value));
}
if (!string.IsNullOrEmpty(pages_typeExample.ptremark))
{
list_param.Add(new OleDbParameter("@ptremark", pages_typeExample.ptremark));
}
else
{
list_param.Add(new OleDbParameter("@ptremark", DBNull.Value));
}
if (pages_typeExample.ptsort != 0)
{
list_param.Add(new OleDbParameter("@ptsort", pages_typeExample.ptsort));
}
else
{
list_param.Add(new OleDbParameter("@ptsort", DBNull.Value));
}
if (!string.IsNullOrEmpty(pages_typeExample.ptstate))
{
list_param.Add(new OleDbParameter("@ptstate", pages_typeExample.ptstate));
}
else
{
list_param.Add(new OleDbParameter("@ptstate", 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>
/// 根据ptid,查询一条数据
/// </summary>
/// <param name="ptid">编号</param>
/// <returns></returns>
public pages_type SearchByID(int ptid)
{
Access.DBHelper.sqlstr = "select * from pages_type where ptid = @ptid ";
OleDbParameter[] param = new OleDbParameter[] {
new OleDbParameter("@ptid", ptid)
};
OleDbDataReader reader = Access.DBHelper.ExecuteReader(param);
pages_type Obj = null;
if (reader.Read())
{
Obj = GetByReader(reader);
}
reader.Close();
return(Obj);
}
/// <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<pages_type></returns>
public IList <pages_type> Search(int s, int e, string key, string state, DateTime date1, DateTime date2)
{
string sql1 = "select top " + e.ToString() + " * from pages_type where ";
string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( ptname like '%" + key + "%' or ptremark like '%" + key + "%' ) ";
string sql3 = string.IsNullOrEmpty(state) ? "" : " and ptstate= '" + state + "' ";
string sql4 = date1 == new DateTime() ? "" : " and datediff('d','" + date1.ToString() + "',ptdate)>=0 ";
string sql5 = date2 == new DateTime() ? "" : " and datediff('d','" + date2.ToString() + "',ptdate)<=0 ";
string sql6 = " order by ptsort desc,ptdate asc ";//排序两个字段,否则数据容易错误
DBHelper.sqlstr = "select * from(select top " + (e - s + 1).ToString() + " * from ( " + sql1 + sql2 + sql3 + sql4 + sql5 + " order by ptsort asc,ptdate desc ) " + sql6 + ") order by ptsort asc,ptdate desc ";
List <pages_type> list = new List <pages_type>();
OleDbDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
pages_type Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
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["ptid"].ToString());
if (id != 0)
{
pages_type dp = BLL.pages_typeManager.SearchByID(id);
dp.ptstate = dp.ptstate == "1" ? "2" : "1";
if (BLL.pages_typeManager.Update(dp) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
bind();
}
}
}
}
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["ptid"]);
pages_type dp = BLL.pages_typeManager.SearchByID(id);
dp.ptname = string.IsNullOrEmpty(txt_name.Text) ? "" : txt_name.Text.Trim();
dp.ptremark = string.IsNullOrEmpty(txt_name.Text) ? "" : txt_remark.Text.Trim();
dp.ptsort = string.IsNullOrEmpty(txt_sort.Text) ? 0 : Convert.ToInt32(txt_sort.Text.Trim());
if (BLL.pages_typeManager.Update(dp) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
GridView1.EditIndex = -1;
bind();
}
}
void bind()
{
if (!string.IsNullOrEmpty(id))
{
int temp = 0;
if (int.TryParse(id, out temp))
{
pages_type dp = pages_typeManager.SearchByID(temp);
if (dp != null)
{
try
{
txt_name.Text = dp.ptname;
txt_remark.Text = dp.ptremark;
txt_sort.Text = dp.ptsort.ToString();
ddl_state.SelectedValue = dp.ptstate;
liter_date.Text = dp.ptdate.ToString();
}
catch { }
}
}
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pages_type">pages_type表实例</param>
/// <returns>int</returns>
public static int Update(pages_type pages_typeExample)
{
return(Service.Update(pages_typeExample));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="pages_type">pages_type表实例</param>
/// <returns>int</returns>
public static int Insert(pages_type pages_typeExample)
{
return(Service.Insert(pages_typeExample));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pages_type">pages_type表实例</param>
/// <returns>int</returns>
public int Update(pages_type pages_typeExample)
{
Access.DBHelper.sqlstr = "update pages_type set ptdate='" + pages_typeExample.ptdate.ToString() + "',ptname=@ptname,ptremark=@ptremark,ptsort=@ptsort,ptstate=@ptstate where ptid=" + pages_typeExample.ptid;
return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(pages_typeExample)));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="pages_type">pages_type表实例</param>
/// <returns>int</returns>
public int Insert(pages_type pages_typeExample)
{
Access.DBHelper.sqlstr = "insert into pages_type (ptdate,ptname,ptremark,ptsort,ptstate)values('" + pages_typeExample.ptdate.ToString() + "',@ptname,@ptremark,@ptsort,@ptstate)";
return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(pages_typeExample)));
}
