private DataSet vDsThongKeWithRadCap() { _vDsThongKeCapGCN = new BcChungChi(); object vDateCapChungChi; if (radCapDoi.SelectedIndex == 0) { vLoadDataThongKeWithRadCap(1); } else if (radCapDoi.SelectedIndex == 1) { vLoadDataThongKeWithRadCap(2); } else { vLoadDataThongKeWithRadCap(3); } if (tbl.Rows.Count > 0) { for (int i = 0; i < tbl.Rows.Count; i++) { vRow = _vDsThongKeCapGCN.TkCapGCN.NewRow(); vRow["STT"] = i + 1; vRow["CHC_Name"] = tbl.Rows[i]["CHC_Name"]; vRow["HOV_FirstName"] = tbl.Rows[i]["HOV_FullName"]; vRow["HOV_LastName"] = tbl.Rows[i]["HOV_LastName"]; vRow["HOV_BirthDay"] = tbl.Rows[i]["HOV_BirthDay"]; vRow["TIN_Name"] = tbl.Rows[i]["TIN_Name"]; vRow["CCC_SoCC"] = tbl.Rows[i]["CCC_SoCC"]; vRow["IMG_Image"] = tbl.Rows[i]["IMG_Image"]; if (int.Parse(tbl.Rows[i]["CCC_LOPID"].ToString()) > -1) { vRow["LOP_ShortName"] = tbl.Rows[i]["LOP_ShortName"]; } else { vRow["LOP_ShortName"] = tbl.Rows[i]["CCC_SoHieuDoi"]; } if (int.Parse(tbl.Rows[i]["CCC_Status"].ToString()) == 1) { vRow["CCC_StatusCap"] = "Cấp mới"; } else if (int.Parse(tbl.Rows[i]["CCC_Status"].ToString()) == 2) { vRow["CCC_StatusCap"] = "Cấp lại"; } else { vRow["CCC_StatusCap"] = "Cấp đổi"; } vDateCapChungChi = DateTime.Parse(tbl.Rows[i]["CCC_NgayCap"].ToString()); vRow["CCC_NgayCap"] = string.Format("{0:dd/MM/yyyy}", vDateCapChungChi).ToString().Substring(0, 10); vRow["fromDate"] = dateFrom.DateTime.ToShortDateString(); vRow["toDate"] = dateEnd.DateTime.ToShortDateString(); _vDsThongKeCapGCN.TkCapGCN.Rows.Add(vRow); } } return(_vDsThongKeCapGCN); }
private DataSet vDsThongKeCapGCN() { boCapChungChi = new BO_CAP_CHUNGCHI(); tbl = new DataTable(); _vDsThongKeCapGCN = new BcChungChi(); object vDateCapChungChi; if (lookKhoaHoc_InGCN.ItemIndex > -1 && lookKhoaHoc_InGCN.Enabled == true) { vChcID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString()); tbl = boCapChungChi.vLoadDataCapChungChiByCHCID(vChcID, dateFrom.DateTime, dateEnd.DateTime); } else { tbl = boCapChungChi.vLoadDataCapChungChiByDate(dateFrom.DateTime, dateEnd.DateTime); } if (tbl.Rows.Count > 0) { for (int i = 0; i < tbl.Rows.Count; i++) { vRow = _vDsThongKeCapGCN.TkCapGCN.NewRow(); vRow["STT"] = i + 1; vRow["CHC_Name"] = tbl.Rows[i]["CHC_Name"]; vRow["HOV_FirstName"] = tbl.Rows[i]["HOV_FullName"]; vRow["HOV_LastName"] = tbl.Rows[i]["HOV_LastName"]; vRow["HOV_BirthDay"] = tbl.Rows[i]["HOV_BirthDay"]; vRow["TIN_Name"] = tbl.Rows[i]["TIN_Name"]; vRow["CCC_SoCC"] = tbl.Rows[i]["CCC_SoCC"]; vRow["IMG_Image"] = tbl.Rows[i]["IMG_Image"]; if (int.Parse(tbl.Rows[i]["CCC_LOPID"].ToString()) > -1) { vRow["LOP_ShortName"] = tbl.Rows[i]["LOP_ShortName"]; } else { vRow["LOP_ShortName"] = tbl.Rows[i]["CCC_SoHieuDoi"]; } if (int.Parse(tbl.Rows[i]["CCC_Status"].ToString()) == 1) { vRow["CCC_StatusCap"] = "Cấp mới"; } else if (int.Parse(tbl.Rows[i]["CCC_Status"].ToString()) == 2) { vRow["CCC_StatusCap"] = "Cấp lại"; } else { vRow["CCC_StatusCap"] = "Cấp đổi"; } vDateCapChungChi = DateTime.Parse(tbl.Rows[i]["CCC_NgayCap"].ToString()); vRow["CCC_NgayCap"] = string.Format("{0:dd/MM/yyyy}", vDateCapChungChi).ToString().Substring(0, 10); vRow["fromDate"] = dateFrom.DateTime.ToShortDateString(); vRow["toDate"] = dateEnd.DateTime.ToShortDateString(); _vDsThongKeCapGCN.TkCapGCN.Rows.Add(vRow); } } return(_vDsThongKeCapGCN); }
public override global::System.Data.DataSet Clone() { BcChungChi cln = ((BcChungChi)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { BcChungChi ds = new BcChungChi(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
private void initThongKe() { int _nhomCcID = 0; string _nhomCcName = string.Empty; DataTable tblChungChi = new DataTable(); lop = new BO_LOP(); boCapChungChi = new BO_CAP_CHUNGCHI(); _vDsThongKeCapGCN = new BcChungChi(); int _ChcID = -1; if (lookupNhomCc.ItemIndex > -1 && lookupNhomCc.Enabled == true) { _nhomCcID = int.Parse(lookupNhomCc.GetColumnValue("LOA_ID").ToString()); _nhomCcName = lookupNhomCc.Text; if (lookChungChiTK.ItemIndex > -1 && lookChungChiTK.Enabled == true) { _ChcID = int.Parse(lookChungChiTK.GetColumnValue("CHC_ID").ToString()); tblChungChi = lop.getChungChiThongKeWithCcID(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID, _ChcID); initDataSetThongKeCapGCN(tblChungChi, _nhomCcName); } else { tblChungChi = lop.getChungChiThongKe(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID); initDataSetThongKeCapGCN(tblChungChi, _nhomCcName); } } else { for (int iNhomCc = 0; iNhomCc < tblNhomChungChi.Rows.Count; iNhomCc++) { _nhomCcID = int.Parse(tblNhomChungChi.Rows[iNhomCc]["LOA_ID"].ToString()); _nhomCcName = tblNhomChungChi.Rows[iNhomCc]["LOA_Name"].ToString(); tblChungChi = lop.getChungChiThongKe(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID); initDataSetThongKeCapGCN(tblChungChi, _nhomCcName); } } rpThongKeCapGCN rpt = new rpThongKeCapGCN(); rpt.SetDataSource(_vDsThongKeCapGCN.Tables["ThongKeCapChungChi"]); rpt.SetParameterValue("_fromDate", dateFrom.Text); rpt.SetParameterValue("_toDate", dateEnd.Text); rpt.SetParameterValue("_SumCapDoi", _SumCapDoi.ToString("#,##0")); rpt.SetParameterValue("_SumCapMoi", _SumCapMoi.ToString("#,##0")); rpt.SetParameterValue("_SumCapLai", _SumCapLai.ToString("#,##0")); rpt.SetParameterValue("_SumTotal", _SumTotal.ToString("#,##0")); crytalThongKe.ReportSource = rpt; crytalThongKe.ToolPanelView = ToolPanelViewType.None; _SumCapDoi = 0; _SumCapMoi = 0; _SumCapLai = 0; _SumTotal = 0; }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) { global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); BcChungChi ds = new BcChungChi(); global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "CapChungChiDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }