CS开发框架提供分类显示数据窗体模板(图)

C# Code:

private void tlCategory_FocusedNodeChanged(object sender, FocusedNodeChangedEventArgs e)
{
   if (e.Node != null)
   {
      object o = e.Node.GetValue("CategoryId");
      this.ShowSummaryByCategory(o.ToString());
   }
}

private void ShowSummaryByCategory(string category)
{
   //调用业务逻辑类的GetSummaryData()方法获取数据
   _BllInstance.GetSummaryByCategory(category, true); 

   DoBindingSummaryGrid(_BLL.SummaryTable); //绑定主表的Grid 

   ShowSummaryPage(true); //显示Summary页面.
}

protected override void ShowSummary()
{
   //屏蔽预设的ShowSummary方法
}

//来源:C/S框架网(www.csframework.com) QQ:1980854898

C# Code:

public object GetProductCategory()
{
   return CommonData.GetDataDict("tb_ProductCategory");
}

C# Code:

[WebMethod]
public byte[] GetProductByCategory(byte[] loginTicket, string category)
{
   Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
   
   dalProduct dal = new dalProduct(loginer);
   DataTable data = dal.GetProductByCategory(category);
   return ZipTools.CompressionObject(ServerLibrary.TableToDataSet(data));
}

C# Code:

public DataTable GetProductByCategory(string category)
{
   string sql = "SELECT * FROM tb_Product WHERE CategoryId=@CategoryId";
   SqlCommandBase cmd = SqlBuilder.BuildSqlCommandBase(sql);
   cmd.AddParam("@CategoryId", SqlDbType.VarChar, category);
   return DataProvider.Instance.GetTable(_Loginer.DBName, cmd.SqlCommand, tb_Product.__TableName);
}

//来源:C/S框架网(www.csframework.com) QQ:1980854898