public void Copy(COScheduleHour oNew) { oNew.ID = miID; oNew.DepartmentID = miDepartmentID; oNew.ProjectID = miProjectID; oNew.EmployeeID = miEmployeeID; oNew.WeekID = miWeekID; oNew.PHrs = mdPHrs; oNew.FHrs = mdFHrs; oNew.AHrs = mdAHrs; }
public void LoadFromObj(COScheduleHour oOrg) { miID = oOrg.ID; miDepartmentID = oOrg.DepartmentID; miProjectID = oOrg.ProjectID; miEmployeeID = oOrg.EmployeeID; miWeekID = oOrg.WeekID; mdPHrs = oOrg.PHrs; mdFHrs = oOrg.FHrs; mdAHrs = oOrg.AHrs; }
private void LoadVals(string strXml) { XmlSerializer s; StringReader sr; s = new XmlSerializer(typeof(COScheduleHour)); sr = new System.IO.StringReader(strXml); oVar = new COScheduleHour(); oVar = (COScheduleHour)s.Deserialize(sr); sr.Close(); sr = null; s = null; }
public string GetByID(int lID) { SqlDataReader dr; RSLib.CDbConnection cnn; SqlCommand cmd; SqlParameter prm; string tmpStr = ""; cnn = new RSLib.CDbConnection(); cmd = new SqlCommand("spScheduleHour_ByID", cnn.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; prm = cmd.Parameters.Add("@ID", SqlDbType.Int); prm.Value = lID; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { oVar = new COScheduleHour(); oVar.ID = Convert.ToInt32(dr["ID"]); oVar.DepartmentID = Convert.ToInt32(dr["DepartmentID"]); oVar.ProjectID = Convert.ToInt32(dr["ProjectID"]); oVar.EmployeeID = Convert.ToInt32(dr["EmployeeID"]); oVar.WeekID = Convert.ToInt32(dr["WeekID"]); oVar.PHrs = Convert.ToDecimal(dr["PHrs"]); oVar.FHrs = Convert.ToDecimal(dr["FHrs"]); oVar.AHrs = Convert.ToDecimal(dr["AHrs"]); tmpStr = GetDataString(); } dr.Close(); dr = null; prm = null; cmd = null; cnn.CloseConnection(); cnn = null; return(tmpStr); }
public void LoadVals(string strXml) { XmlSerializer s; StringReader sr; COScheduleHour o; s = new XmlSerializer(typeof(COScheduleHour)); sr = new System.IO.StringReader(strXml); o = new COScheduleHour(); o = (COScheduleHour)s.Deserialize(sr); base.LoadFromObj(o); o = null; sr.Close(); sr = null; s = null; }
public string GetDataString() { string tmpStr; COScheduleHour o; XmlSerializer s; StringWriter sw; o = new COScheduleHour(); s = new XmlSerializer(typeof(COScheduleHour)); sw = new StringWriter(); base.Copy(o); s.Serialize(sw, o); tmpStr = sw.ToString(); o = null; s = null; sw = null; return(tmpStr); }