public US_CM_DM_LOAI_TD(decimal i_dbID) { pm_objDS = new DS_CM_DM_LOAI_TD(); pm_strTableName = c_TableName; this.FillDataset(pm_objDS, "Where ID = " + Conversion.Str(i_dbID)); pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]); }
public US_CM_DM_LOAI_TD(string i_strMaLoaiTD) { pm_objDS = new DS_CM_DM_LOAI_TD(); pm_strTableName = c_TableName; System.Data.SqlClient.SqlCommand v_cmd = default(System.Data.SqlClient.SqlCommand); IMakeSelectCmd v_MakeSelCommand = default(IMakeSelectCmd); v_MakeSelCommand = new CMakeAndSelectCmd(pm_objDS, c_TableName); v_MakeSelCommand.AddCondition("MA_LOAI", i_strMaLoaiTD, eKieuDuLieu.KieuString, eKieuSoSanh.Bang); v_cmd = v_MakeSelCommand.getSelectCmd(); this.FillDatasetByCommand(pm_objDS, v_cmd); pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]); }
private void load_cbo_loai_tu_dien_grv() { US_CM_DM_LOAI_TD v_us_loai_tu_dien = new US_CM_DM_LOAI_TD(); DS_CM_DM_LOAI_TD v_ds_loai_tu_dien = new DS_CM_DM_LOAI_TD(); v_us_loai_tu_dien.FillDataset(v_ds_loai_tu_dien); m_cbo_loai_tu_dien_grv.DataSource = v_ds_loai_tu_dien.CM_DM_LOAI_TD; m_cbo_loai_tu_dien_grv.DataTextField = CM_DM_LOAI_TD.TEN_LOAI; m_cbo_loai_tu_dien_grv.DataValueField = CM_DM_LOAI_TD.MA_LOAI; m_cbo_loai_tu_dien_grv.DataBind(); }
global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.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(); DS_CM_DM_LOAI_TD ds = new DS_CM_DM_LOAI_TD(); 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 = "CM_DM_LOAI_TDDataTable"; 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); global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); while (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; while ((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; }
global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { DS_CM_DM_LOAI_TD ds = new DS_CM_DM_LOAI_TD(); 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); global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); while (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; while ((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; }
public US_CM_DM_LOAI_TD() { pm_objDS = new DS_CM_DM_LOAI_TD(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
private void load_cbo_loai_tu_dien() { US_CM_DM_LOAI_TD v_us_loai_tu_dien = new US_CM_DM_LOAI_TD(); DS_CM_DM_LOAI_TD v_ds_loai_tu_dien = new DS_CM_DM_LOAI_TD(); v_us_loai_tu_dien.FillDataset(v_ds_loai_tu_dien," order by "+CM_DM_LOAI_TD.TEN_LOAI); m_cbo_loai_tu_dien.DataSource = v_ds_loai_tu_dien.CM_DM_LOAI_TD; m_cbo_loai_tu_dien.DataTextField = CM_DM_LOAI_TD.TEN_LOAI; m_cbo_loai_tu_dien.DataValueField = CM_DM_LOAI_TD.ID; m_cbo_loai_tu_dien.DataBind(); }
private void loadData_fromDB_toDatasets() { US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN(); try { v_us_tu_dien.BeginTransaction(); this.m_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_tu_dien.FillDataset(m_ds_tu_dien); US_CM_DM_LOAI_TD v_us_loai_tu_dien = new US_CM_DM_LOAI_TD(); v_us_loai_tu_dien.UseTransOfUSObject(v_us_tu_dien); this.m_ds_loai_tu_dien = new DS_CM_DM_LOAI_TD(); v_us_loai_tu_dien.FillDataset(m_ds_loai_tu_dien); v_us_tu_dien.CommitTransaction(); } catch (Exception v_e) { v_us_tu_dien.Rollback(); CDBExceptionHandler v_handler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret()); v_handler.showErrorMessage(); } }