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