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