private void LoadReport(dsInsurance ds)
{
//ReportDocument rptDoc = new ReportDocument();
//rptDoc.SetDataSource(ds);
frmReport frm = new frmReport();
//frm.SetReportDocument = rptDoc;
frm.ShowInsuranceC47(ds, dtIDate.Value.Month, dtIDate.Value.Year);
}
private dsInsurance SendToDataSet()
{
dsInsurance DS_Insurance = new dsInsurance();
DS_Insurance.tblInsuranceC47P1.Rows.Clear();
for (int i = 0; i < tblmdlP1.Rows.Count; i++)
{
object[] RowObj = new object[15];
RowObj[0] = tblmdlP1.Rows[i].Cells[0].Text;
RowObj[1] = tblmdlP1.Rows[i].Cells[1].Text;
RowObj[2] = tblmdlP1.Rows[i].Cells[2].Text;
RowObj[3] = tblmdlP1.Rows[i].Cells[3].Data;
RowObj[4] = tblmdlP1.Rows[i].Cells[4].Data;
RowObj[5] = tblmdlP1.Rows[i].Cells[5].Data;
RowObj[6] = tblmdlP1.Rows[i].Cells[6].Data;
RowObj[7] = tblmdlP1.Rows[i].Cells[7].Data;
RowObj[8] = tblmdlP1.Rows[i].Cells[8].Data;
RowObj[9] = tblmdlP1.Rows[i].Cells[9].Text;
RowObj[10] = tblmdlP1.Rows[i].Cells[10].Text;
RowObj[11] = tblmdlP1.Rows[i].Cells[11].Text;
//RowObj[12] = tblmdlP1.Rows[i].Cells[12].Data;
//RowObj[13] = tblmdlP1.Rows[i].Cells[13].Data;
RowObj[12] = tblmdlP1.Rows[i].Cells[12].Data;
RowObj[13] = tblmdlP1.Rows[i].Cells[13].Data;
RowObj[14] = tblmdlP1.Rows[i].Cells[14].Text;
DS_Insurance.tblInsuranceC47P1.Rows.Add(RowObj);
}
DS_Insurance.tblInsuranceC47P2.Rows.Clear();
for (int i = 0; i < tblmdlP2.Rows.Count; i++)
{
object[] RowObj = new object[5];
RowObj[0] = tblmdlP2.Rows[i].Cells[0].Text;
RowObj[1] = tblmdlP2.Rows[i].Cells[1].Text;
RowObj[2] = tblmdlP2.Rows[i].Cells[2].Data;
RowObj[3] = tblmdlP2.Rows[i].Cells[5].Data;
if (i < 5)
{
if (Convert.ToDecimal(tblmdlP2.Rows[i].Cells[3].Data) > 0)
{
RowObj[4] = 1;//tang
}
else
{
RowObj[4] = 2;//giam
}
}
else
{
RowObj[4] = 0;//ko the hien tren cot tang va giam
}
DS_Insurance.tblInsuranceC47P2.Rows.Add(RowObj);
}
return(DS_Insurance);
}
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();
dsInsurance ds = new dsInsurance();
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 = "tblInsuranceC47P2DataTable";
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;
}
private void btnPrint_Click(object sender, EventArgs e)
{
dsInsurance dtsValue = SendToDataSet();
LoadReport(dtsValue);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
dsInsurance ds = new dsInsurance();
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;
}