public void LoadFromObj(COTransmittalReleaseDrwg oOrg)
{
miID = oOrg.ID;
miReleaseID = oOrg.ReleaseID;
miDrawingID = oOrg.DrawingID;
msHGANumber = oOrg.HGANumber;
msCADNumber = oOrg.CADNumber;
msTitleDesc = oOrg.TitleDesc;
msRevision = oOrg.Revision;
mdtDateReleased = oOrg.DateReleased;
}
public void Copy(COTransmittalReleaseDrwg oNew)
{
oNew.ID = miID;
oNew.ReleaseID = miReleaseID;
oNew.DrawingID = miDrawingID;
oNew.HGANumber = msHGANumber;
oNew.CADNumber = msCADNumber;
oNew.TitleDesc = msTitleDesc;
oNew.Revision = msRevision;
oNew.DateReleased = mdtDateReleased;
}
private void LoadVals(string strXml)
{
XmlSerializer s;
StringReader sr;
s = new XmlSerializer(typeof(COTransmittalReleaseDrwg));
sr = new System.IO.StringReader(strXml);
oVar = new COTransmittalReleaseDrwg();
oVar = (COTransmittalReleaseDrwg)s.Deserialize(sr);
sr.Close();
sr = null;
s = null;
}
public void LoadVals(string strXml)
{
XmlSerializer s;
StringReader sr;
COTransmittalReleaseDrwg o;
s = new XmlSerializer(typeof(COTransmittalReleaseDrwg));
sr = new System.IO.StringReader(strXml);
o = new COTransmittalReleaseDrwg();
o = (COTransmittalReleaseDrwg)s.Deserialize(sr);
base.LoadFromObj(o);
o = null;
sr.Close();
sr = null;
s = null;
}
public string GetByID(int iID)
{
SqlDataReader dr;
RSLib.CDbConnection cnn;
SqlCommand cmd;
SqlParameter prm;
string tmpStr = "";
cnn = new RSLib.CDbConnection();
cmd = new SqlCommand("spTransmittalReleaseDrwg_ByID", cnn.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
prm = cmd.Parameters.Add("@ID", SqlDbType.Int);
prm.Value = iID;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oVar = new COTransmittalReleaseDrwg();
oVar.ID = Convert.ToInt32(dr["ID"]);
oVar.ReleaseID = Convert.ToInt32(dr["ReleaseID"]);
oVar.DrawingID = Convert.ToInt32(dr["DrawingID"]);
oVar.HGANumber = dr["HGANumber"].ToString();
oVar.CADNumber = dr["CADNumber"].ToString();
oVar.TitleDesc = dr["TitleDesc"].ToString();
oVar.Revision = dr["Revision"].ToString();
oVar.DateReleased = Convert.ToDateTime(dr["DateReleased"]);
tmpStr = GetDataString();
}
dr.Close();
dr = null;
prm = null;
cmd = null;
cnn.CloseConnection();
cnn = null;
return(tmpStr);
}
public string GetDataString()
{
string tmpStr;
COTransmittalReleaseDrwg o;
XmlSerializer s;
StringWriter sw;
o = new COTransmittalReleaseDrwg();
s = new XmlSerializer(typeof(COTransmittalReleaseDrwg));
sw = new StringWriter();
base.Copy(o);
s.Serialize(sw, o);
tmpStr = sw.ToString();
o = null;
s = null;
sw = null;
return(tmpStr);
}
