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);
}
