コード例 #1
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();
     zmaindataset ds = new zmaindataset();
     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 = "zbillDataTable";
     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;
 }
コード例 #2
0
 public virtual int Fill(zmaindataset.billrcvPaymentDetDataTable dataTable, global::System.Nullable<int> mnbillid) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((mnbillid.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(mnbillid.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #3
0
 public virtual int Fill(zmaindataset.insertintopartpaymentDataTable dataTable, global::System.Nullable<int> mnbillid, string chequeno, global::System.Nullable<global::System.DateTime> chequedate, global::System.Nullable<decimal> chequeamount, global::System.Nullable<decimal> tds, global::System.Nullable<decimal> otherexpense, global::System.Nullable<decimal> total) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((mnbillid.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(mnbillid.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((chequeno == null)) {
         this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = ((string)(chequeno));
     }
     if ((chequedate.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[3].Value = ((System.DateTime)(chequedate.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
     }
     if ((chequeamount.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[4].Value = ((decimal)(chequeamount.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
     }
     if ((tds.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[5].Value = ((decimal)(tds.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
     }
     if ((otherexpense.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[6].Value = ((decimal)(otherexpense.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value;
     }
     if ((total.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[7].Value = ((decimal)(total.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #4
0
 public virtual int FillByBillRcvAll(zmaindataset.billRcvDataTable dataTable) {
     this.Adapter.SelectCommand = this.CommandCollection[2];
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #5
0
 public virtual int FillBySearchPartPayment(zmaindataset.billRcvDataTable dataTable, global::System.Nullable<int> debitbillno) {
     this.Adapter.SelectCommand = this.CommandCollection[3];
     if ((debitbillno.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(debitbillno.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #6
0
 public virtual int Update(zmaindataset.zmainbillDataTable dataTable) {
     return this.Adapter.Update(dataTable);
 }
コード例 #7
0
 public virtual int Update(zmaindataset dataSet) {
     return this.Adapter.Update(dataSet, "zmainbill");
 }
コード例 #8
0
 public virtual int FillByPaymentRecieved(zmaindataset.zmainbillDataTable dataTable, global::System.Nullable<int> debitbillno, global::System.Nullable<global::System.DateTime> paymentdate, global::System.Nullable<bool> billrecieved) {
     this.Adapter.SelectCommand = this.CommandCollection[9];
     if ((debitbillno.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(debitbillno.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((paymentdate.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[2].Value = ((System.DateTime)(paymentdate.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
     }
     if ((billrecieved.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[3].Value = ((bool)(billrecieved.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #9
0
 public virtual int FillMainSearchByBillDate(zmaindataset.zmainbillDataTable dataTable, global::System.Nullable<global::System.DateTime> billdate) {
     this.Adapter.SelectCommand = this.CommandCollection[11];
     if ((billdate.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(billdate.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #10
0
 public virtual int FillByMainSearchPartyStationAndDbno(zmaindataset.zmainbillDataTable dataTable, string partyname, string station, global::System.Nullable<int> dbno) {
     this.Adapter.SelectCommand = this.CommandCollection[7];
     if ((partyname == null)) {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = ((string)(partyname));
     }
     if ((station == null)) {
         this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = ((string)(station));
     }
     if ((dbno.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[3].Value = ((int)(dbno.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #11
0
 public virtual int FillByMainSearchStation(zmaindataset.zmainbillDataTable dataTable, string station) {
     this.Adapter.SelectCommand = this.CommandCollection[8];
     if ((station == null)) {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = ((string)(station));
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #12
0
 public virtual int FillByMainSearchDebitBillNo(zmaindataset.zmainbillDataTable dataTable, global::System.Nullable<int> dbno) {
     this.Adapter.SelectCommand = this.CommandCollection[4];
     if ((dbno.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(dbno.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #13
0
 public virtual int FillBy(
             zmaindataset.zmainbillDataTable dataTable, 
             global::System.Nullable<int> userid, 
             global::System.Nullable<int> billid, 
             global::System.Nullable<int> debitBillNo, 
             global::System.Nullable<global::System.DateTime> billdate, 
             string partyName, 
             string station, 
             global::System.Nullable<decimal> total, 
             global::System.Nullable<decimal> serviceCharge, 
             global::System.Nullable<decimal> surcharge, 
             global::System.Nullable<decimal> hsServiceCharge, 
             global::System.Nullable<decimal> tax, 
             string totalinwords, 
             string totalbags, 
             string totaltones, 
             global::System.Nullable<int> mnbillId) {
     this.Adapter.SelectCommand = this.CommandCollection[1];
     if ((userid.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(userid.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((billid.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[2].Value = ((int)(billid.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
     }
     if ((debitBillNo.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[3].Value = ((int)(debitBillNo.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
     }
     if ((billdate.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[4].Value = ((System.DateTime)(billdate.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
     }
     if ((partyName == null)) {
         this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[5].Value = ((string)(partyName));
     }
     if ((station == null)) {
         this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[6].Value = ((string)(station));
     }
     if ((total.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[7].Value = ((decimal)(total.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value;
     }
     if ((serviceCharge.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[8].Value = ((decimal)(serviceCharge.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[8].Value = global::System.DBNull.Value;
     }
     if ((surcharge.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[9].Value = ((decimal)(surcharge.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[9].Value = global::System.DBNull.Value;
     }
     if ((hsServiceCharge.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[10].Value = ((decimal)(hsServiceCharge.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[10].Value = global::System.DBNull.Value;
     }
     if ((tax.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[11].Value = ((decimal)(tax.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[11].Value = global::System.DBNull.Value;
     }
     if ((totalinwords == null)) {
         this.Adapter.SelectCommand.Parameters[12].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[12].Value = ((string)(totalinwords));
     }
     if ((totalbags == null)) {
         this.Adapter.SelectCommand.Parameters[13].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[13].Value = ((string)(totalbags));
     }
     if ((totaltones == null)) {
         this.Adapter.SelectCommand.Parameters[14].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[14].Value = ((string)(totaltones));
     }
     if ((mnbillId.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[15].Value = ((int)(mnbillId.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[15].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #14
0
 public virtual int FillByBill(zmaindataset.zbillDataTable dataTable, global::System.Nullable<int> billid, global::System.Nullable<int> userid, global::System.Nullable<int> mnbillId, global::System.Nullable<global::System.DateTime> billdate, string gcnumber, string chalannumber, string trucknumber, string goods, string bags, string tone, global::System.Nullable<decimal> rate, global::System.Nullable<decimal> amount, global::System.Nullable<global::System.DateTime> unloading, global::System.Nullable<decimal> expense) {
     this.Adapter.SelectCommand = this.CommandCollection[2];
     if ((billid.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(billid.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((userid.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[2].Value = ((int)(userid.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
     }
     if ((mnbillId.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[3].Value = ((int)(mnbillId.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
     }
     if ((billdate.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[4].Value = ((System.DateTime)(billdate.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
     }
     if ((gcnumber == null)) {
         this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[5].Value = ((string)(gcnumber));
     }
     if ((chalannumber == null)) {
         this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[6].Value = ((string)(chalannumber));
     }
     if ((trucknumber == null)) {
         this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[7].Value = ((string)(trucknumber));
     }
     if ((goods == null)) {
         this.Adapter.SelectCommand.Parameters[8].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[8].Value = ((string)(goods));
     }
     if ((bags == null)) {
         this.Adapter.SelectCommand.Parameters[9].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[9].Value = ((string)(bags));
     }
     if ((tone == null)) {
         this.Adapter.SelectCommand.Parameters[10].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[10].Value = ((string)(tone));
     }
     if ((rate.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[11].Value = ((decimal)(rate.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[11].Value = global::System.DBNull.Value;
     }
     if ((amount.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[12].Value = ((decimal)(amount.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[12].Value = global::System.DBNull.Value;
     }
     if ((unloading.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[13].Value = ((System.DateTime)(unloading.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[13].Value = global::System.DBNull.Value;
     }
     if ((expense.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[14].Value = ((decimal)(expense.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[14].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #15
0
 public virtual int FillBy(zmaindataset.zbillDataTable dataTable, global::System.Nullable<int> Param1) {
     this.Adapter.SelectCommand = this.CommandCollection[1];
     if ((Param1.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[0].Value = ((int)(Param1.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #16
0
 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
     zmaindataset ds = new zmaindataset();
     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;
 }