protected void updateButton_Click(object sender, EventArgs e) { string sName = ShopName_edit.Text.ToString(); string Destr = Description_edit.Text.ToString(); string id = EditID.Text.ToString(); SalesPlatform s = new SalesPlatform(); s.PlatformName = sName; s.Description = Destr; s.PlatformID = int.Parse(id); if (Leyp.SQLServerDAL.Sales.Factory.getSalesPlatformDAL().updateEitity(s)) { HyperLink1.Visible = true; viewPanel.Visible = false; editPanel.Visible = false; } else { HyperLink1.Text = "失败!你可以返回重新试试"; HyperLink1.Visible = true; viewPanel.Visible = false; } }
public bool insertNewEntity(SalesPlatform s) { int rowsAffected = 0; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@PlatformName", SqlDbType.NVarChar), new SqlParameter("@Description", SqlDbType.NVarChar) }; parameters[0].Value = s.PlatformName; parameters[1].Value = s.Description; SQLHelper.RunProcedure("p_SalesPlatform_insertNewEntity", parameters, out rowsAffected); return(1 == rowsAffected); }
/// <summary> /// 页面初始化 /// </summary> public void initDataBand() { string action = Request.QueryString["action"]; if (action == null) { CollectionPager1.DataSource = Leyp.SQLServerDAL.Sales.Factory.getSalesPlatformDAL().getList();//BLL项目中List数据源 CollectionPager1.BindToControl = GridView1; GridView1.DataSource = CollectionPager1.DataSourcePaged; editPanel.Visible = false; } else if (action.Equals("edit")) { int PlatformID = 0; try { PlatformID = int.Parse(Request.QueryString["PlatformID"].ToString()); } catch { Response.Write("参数有误"); Response.End(); } SalesPlatform s = new SalesPlatform(); s = Leyp.SQLServerDAL.Sales.Factory.getSalesPlatformDAL().getByID(PlatformID); ShopName_edit.Text = s.PlatformName; EditID.Text = s.PlatformID.ToString();//保存编辑ID Description_edit.Text = s.Description; editPanel.Visible = true; viewPanel.Visible = false; } else if (action.Equals("del")) { int PlatformID = 0; try { PlatformID = int.Parse(Request.QueryString["PlatformID"].ToString()); } catch { Response.Write("参数有误"); Response.End(); } Leyp.SQLServerDAL.Sales.Factory.getSalesPlatformDAL().deleteEitity(PlatformID); Jscript.AjaxAlert(this, "删除成功"); viewPanel.Visible = false; } }
public List <SalesPlatform> getList() { List <SalesPlatform> list = new List <SalesPlatform>(); SqlDataReader reader = SQLHelper.RunProcedure("p_SalesPlatform_getList", null); while (reader.Read()) { SalesPlatform item = new SalesPlatform(); item.PlatformID = reader.GetInt32(reader.GetOrdinal("PlatformID")); item.PlatformName = reader.GetString(reader.GetOrdinal("PlatformName")); item.Description = reader.GetString(reader.GetOrdinal("Description")); list.Add(item); } reader.Close(); return(list); }
public SalesPlatform getByID(int PlatformID) { SalesPlatform platform = new SalesPlatform(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@PlatformID", SqlDbType.NVarChar) }; parameters[0].Value = PlatformID; SqlDataReader reader = SQLHelper.RunProcedure("p_SalesPlatform_getByID", parameters); if (reader.Read()) { platform.PlatformID = reader.GetInt32(reader.GetOrdinal("PlatformID")); platform.PlatformName = reader.GetString(reader.GetOrdinal("PlatformName")); platform.Description = reader.GetString(reader.GetOrdinal("Description")); } reader.Close(); return(platform); }
protected void submit_Click(object sender, EventArgs e) { string sName = ShopName_New.Text.ToString(); string Destr = Description_new.Text.ToString(); SalesPlatform s = new SalesPlatform(); s.PlatformName = sName; s.Description = Destr; if (Leyp.SQLServerDAL.Sales.Factory.getSalesPlatformDAL().insertNewEntity(s)) { HyperLink1.Visible = true; viewPanel.Visible = false; } else { HyperLink1.Text = "添加失败!可能是名称重复了!你可以返回重新试试"; HyperLink1.Visible = true; viewPanel.Visible = false; } }