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