/// <summary> /// 给定报表类型和类型字符串(Service或Customer)返回报表 /// </summary> /// <typeparam name="T">报表类型</typeparam> /// <param name="strType">类型字符串</param> /// <returns></returns> public ReportClass GetReport <T>(string strType, string where) where T : new() { Type type = typeof(T); ReportClass rpt; if (type.IsSubclassOf(typeof(ReportClass))) { rpt = new T() as ReportClass; } else { throw new Exception("所给类型不是ReportClass的子类"); } string tblName = "V_Customer"; string fldName = "客户编号"; if (strType != "Customer") { tblName = "V_Service"; fldName = "服务编号"; } if (where == "") { where = "1 = 1"; } BLL.ViewOperator bll = new BLL.ViewOperator(); DataSet dst = bll.GetList(tblName, where + " ORDER BY " + fldName); dst.Tables[0].TableName = tblName; BLL.Argument bllArgument = new BLL.Argument(); DataTable dtbl = bllArgument.GetList("type = '" + fldName + "'").Tables[0]; string strNO = dtbl.Rows[0][1].ToString(); for (int i = 0; i < dst.Tables[0].Rows.Count; i++) { dst.Tables[0].Rows[i][1] = strNO + dst.Tables[0].Rows[i][1]; } rpt.SetDataSource(dst); return(rpt); }
public void GetData() { List <string> lst = new List <string>(); string where = ""; if (GUID != Guid.Empty) { GetWhere(ref lst, GUID); where = string.Format("parentGUID in ({0})", string.Join(",", lst.ToArray())); } BLL.ViewOperator bll = new BLL.ViewOperator(); DataTable dt = bll.GetList( "V_Customer", "客户编号", winFormPager1.PageSize, winFormPager1.PageIndex, where).Tables[0]; winFormPager1.RecordCount = bll.GetListCount("V_Customer", where); BLL.Argument bllArgument = new BLL.Argument(); DataTable dtbl = bllArgument.GetList("type = '客户编号'").Tables[0]; string strNO = dtbl.Rows[0][1].ToString(); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i][1] = strNO + dt.Rows[i][1]; } this.dataGridView1.DataSource = dt; this.dataGridView1.Columns[0].Visible = false; this.dataGridView1.Columns[9].Visible = false; this.dataGridView1.Columns[10].Visible = false; }
public void GetData() { List<string> lst = new List<string>(); string where = ""; if (GUID != Guid.Empty) { GetWhere(ref lst, GUID); where = string.Format("parentGUID in ({0})", string.Join(",", lst.ToArray())); } BLL.ViewOperator bll = new BLL.ViewOperator(); DataTable dt = bll.GetList( "V_Customer", "客户编号", winFormPager1.PageSize, winFormPager1.PageIndex, where).Tables[0]; winFormPager1.RecordCount = bll.GetListCount("V_Customer", where); BLL.Argument bllArgument = new BLL.Argument(); DataTable dtbl = bllArgument.GetList("type = '客户编号'").Tables[0]; string strNO = dtbl.Rows[0][1].ToString(); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i][1] = strNO + dt.Rows[i][1]; } this.dataGridView1.DataSource = dt; this.dataGridView1.Columns[0].Visible = false; this.dataGridView1.Columns[9].Visible = false; this.dataGridView1.Columns[10].Visible = false; }
private void cbxCustomerGroup_Leave(object sender, EventArgs e) { List <string> lst = new List <string>(); string where = ""; if (cbxCustomerGroup.SelectedNode.Name != Guid.Empty.ToString() && cbxCustomerGroup.SelectedNode.Name != null) { GetWhere(ref lst, new Guid(cbxCustomerGroup.SelectedNode.Name)); where = string.Format("parentGUID in ({0})", string.Join(",", lst.ToArray())); } BLL.ViewOperator bll = new BLL.ViewOperator(); DataTable dt = bll.GetList("V_Customer", where).Tables[0]; cbxName.DataSource = dt; cbxName.DisplayMember = "客户名称"; cbxName.ValueMember = "GUID"; }
public void GetData() { string where = ""; if (!(GUID == Guid.Empty)) { where= "customerGUID = '" + GUID + "'"; } BLL.ViewOperator bll = new BLL.ViewOperator(); DataTable dt = bll.GetList( "V_Service", "服务编号", winFormPager1.PageSize, winFormPager1.PageIndex, where).Tables[0]; winFormPager1.RecordCount = bll.GetListCount("V_Service", where); BLL.Argument bllArgument = new BLL.Argument(); DataTable dtbl = bllArgument.GetList("type = '服务编号'").Tables[0]; string strNO = dtbl.Rows[0][1].ToString(); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i][1] = strNO + dt.Rows[i][1]; } this.dataGridView1.DataSource = dt; this.dataGridView1.Columns[0].Visible = false; this.dataGridView1.Columns[8].Visible = false; this.dataGridView1.Columns[9].Visible = false; this.dataGridView1.Columns[10].Visible = false; }
public void GetData() { string where = ""; if (!(GUID == Guid.Empty)) { where = "customerGUID = '" + GUID + "'"; } BLL.ViewOperator bll = new BLL.ViewOperator(); DataTable dt = bll.GetList( "V_Service", "服务编号", winFormPager1.PageSize, winFormPager1.PageIndex, where).Tables[0]; winFormPager1.RecordCount = bll.GetListCount("V_Service", where); BLL.Argument bllArgument = new BLL.Argument(); DataTable dtbl = bllArgument.GetList("type = '服务编号'").Tables[0]; string strNO = dtbl.Rows[0][1].ToString(); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i][1] = strNO + dt.Rows[i][1]; } this.dataGridView1.DataSource = dt; this.dataGridView1.Columns[0].Visible = false; this.dataGridView1.Columns[8].Visible = false; this.dataGridView1.Columns[9].Visible = false; this.dataGridView1.Columns[10].Visible = false; }
private void cbxCustomerGroup_Leave(object sender, EventArgs e) { List<string> lst = new List<string>(); string where = ""; if (cbxCustomerGroup.SelectedNode.Name != Guid.Empty.ToString() && cbxCustomerGroup.SelectedNode.Name != null) { GetWhere(ref lst, new Guid(cbxCustomerGroup.SelectedNode.Name)); where = string.Format("parentGUID in ({0})", string.Join(",", lst.ToArray())); } BLL.ViewOperator bll = new BLL.ViewOperator(); DataTable dt = bll.GetList("V_Customer", where).Tables[0]; cbxName.DataSource = dt; cbxName.DisplayMember = "客户名称"; cbxName.ValueMember = "GUID"; }