/// <summary>
/// 从一个OleDbDataReader里读数据
/// </summary>
/// <param name="Reader">OleDbDataReader</param>
/// <returns>yh_goodstypeExample</returns>
public static yh_goodstype GetByReader(OleDbDataReader Reader)
{
yh_goodstype yh_goodstypeExample = new yh_goodstype();
yh_goodstypeExample.gtanme = Reader["gtanme"] == DBNull.Value ? null : Reader["gtanme"].ToString();
yh_goodstypeExample.gtdate = Reader["gtdate"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["gtdate"]);
yh_goodstypeExample.gtid = Reader["gtid"] == DBNull.Value ? 0 : (int)Reader["gtid"];
yh_goodstypeExample.gtsort = Reader["gtsort"] == DBNull.Value ? null : Reader["gtsort"].ToString();
yh_goodstypeExample.gtstate = Reader["gtstate"] == DBNull.Value ? null : Reader["gtstate"].ToString();
return(yh_goodstypeExample);
}
/// <summary>
/// 查询全部数据
/// </summary>
/// <returns>IList</returns>
/*查看是否为视图*/
public IList <yh_goodstype> SearchAll(bool isall)
{
Access.DBHelper.sqlstr = "select * from yh_goodstype " + (isall ? "" : " where gtstate='1' ") + " order by gtsort asc ";
List <yh_goodstype> list = new List <yh_goodstype>();
OleDbDataReader reader = Access.DBHelper.ExecuteReader();
while (reader.Read())
{
yh_goodstype Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
protected void btn_save_Click(object sender, EventArgs e)
{
string name;
string sort;
decimal temp;
if (string.IsNullOrEmpty(txt_name.Text))
{
Manager.Alert("请输入名称", Page);
txt_name.Focus();
return;
}
else
{
name = txt_name.Text.Trim();
}
if (string.IsNullOrEmpty(txt_sort.Text))
{
Manager.Alert("请输入排序", Page);
txt_sort.Focus();
return;
}
else
{
sort = txt_sort.Text.Trim();
}
if (!decimal.TryParse(sort, out temp))
{
Manager.Alert("请输入正确的排序", Page);
txt_sort.Focus();
return;
}
yh_goodstype gt = new yh_goodstype();
gt.gtanme = name;
gt.gtsort = sort;
gt.gtdate = DateTime.Now;
gt.gtstate = "1";
if (BLL.yh_goodstypeManager.Insert(gt) != 1)
{
Manager.Alert("添加失败", Page);
}
else
{
Manager.Alert("添加成功", Page);
}
Manager.page_href_reload(Page);
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txt_sort = GridView1.Rows[e.RowIndex].FindControl("txt_sort") as TextBox;
TextBox txt_name = GridView1.Rows[e.RowIndex].FindControl("txt_name") as TextBox;
string name;
string sort;
decimal temp;
if (string.IsNullOrEmpty(txt_name.Text))
{
Manager.Alert("请输入名称", Page);
txt_name.Focus();
return;
}
else
{
name = txt_name.Text.Trim();
}
if (string.IsNullOrEmpty(txt_sort.Text))
{
Manager.Alert("请输入排序", Page);
txt_sort.Focus();
return;
}
else
{
sort = txt_sort.Text.Trim();
}
if (!decimal.TryParse(sort, out temp))
{
Manager.Alert("请输入正确的排序", Page);
txt_sort.Focus();
return;
}
int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["gtid"]);
yh_goodstype gt = BLL.yh_goodstypeManager.SearchBygtid(id);
gt.gtanme = name;
gt.gtsort = sort;
if (BLL.yh_goodstypeManager.Update(gt) != 1)
{
Manager.Alert("修改失败", Page);
}
Manager.page_href_reload(Page);
}
/// <summary>
/// 根据gtid,查询一条数据
/// </summary>
/// <param name="gtid">商品类型</param>
/// <returns></returns>
public yh_goodstype SearchBygtid(int gtid)
{
Access.DBHelper.sqlstr = "select * from yh_goodstype where gtid = @gtid";
OleDbParameter[] param = new OleDbParameter[] {
new OleDbParameter("@gtid", gtid)
};
OleDbDataReader reader = Access.DBHelper.ExecuteReader(param);
yh_goodstype Obj = null;
if (reader.Read())
{
Obj = GetByReader(reader);
}
reader.Close();
return(Obj);
}
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["gtid"].ToString());
if (id != 0)
{
yh_goodstype fx = BLL.yh_goodstypeManager.SearchBygtid(id);
fx.gtstate = fx.gtstate == "1" ? "2" : "1";
if (BLL.yh_goodstypeManager.Update(fx) != 1)
{
Manager.Alert("修改失败", Page);
}
}
Manager.page_href_reload(Page);
}
}
/// <summary>
/// 根据表,获取一个OleDbParameter数组
/// </summary>
/// <returns>OleDbParameter[]</returns>
public static OleDbParameter[] GetOleDbParameter(yh_goodstype yh_goodstypeExample)
{
List <OleDbParameter> list_param = new List <OleDbParameter>();
if (!string.IsNullOrEmpty(yh_goodstypeExample.gtanme))
{
list_param.Add(new OleDbParameter("@gtanme", yh_goodstypeExample.gtanme));
}
else
{
list_param.Add(new OleDbParameter("@gtanme", DBNull.Value));
}
if (!string.IsNullOrEmpty(yh_goodstypeExample.gtsort))
{
list_param.Add(new OleDbParameter("@gtsort", yh_goodstypeExample.gtsort));
}
else
{
list_param.Add(new OleDbParameter("@gtsort", DBNull.Value));
}
if (!string.IsNullOrEmpty(yh_goodstypeExample.gtstate))
{
list_param.Add(new OleDbParameter("@gtstate", yh_goodstypeExample.gtstate));
}
else
{
list_param.Add(new OleDbParameter("@gtstate", 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="yh_goodstype">yh_goodstype表实例</param>
/// <returns>int</returns>
public int Update(yh_goodstype yh_goodstypeExample)
{
Access.DBHelper.sqlstr = "update yh_goodstype set gtanme=@gtanme,gtdate='" + yh_goodstypeExample.gtdate.ToString() + "',gtsort=@gtsort,gtstate=@gtstate where gtid=" + yh_goodstypeExample.gtid;
return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(yh_goodstypeExample)));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="yh_goodstype">yh_goodstype表实例</param>
/// <returns>int</returns>
public int Insert(yh_goodstype yh_goodstypeExample)
{
Access.DBHelper.sqlstr = "insert into yh_goodstype (gtanme,gtdate,gtsort,gtstate)values(@gtanme,'" + yh_goodstypeExample.gtdate.ToString() + "',@gtsort,@gtstate)";
return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(yh_goodstypeExample)));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="yh_goodstype">yh_goodstype表实例</param>
/// <returns>int</returns>
public static int Update(yh_goodstype yh_goodstypeExample)
{
return(Service.Update(yh_goodstypeExample));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="yh_goodstype">yh_goodstype表实例</param>
/// <returns>int</returns>
public static int Insert(yh_goodstype yh_goodstypeExample)
{
return(Service.Insert(yh_goodstypeExample));
}
