public string GetByProjectID(int projID)
{
SqlDataReader dr;
RSLib.CDbConnection cnn;
SqlCommand cmd;
SqlParameter prm;
string tmpStr = "";
cnn = new RSLib.CDbConnection();
cmd = new SqlCommand("spBudget_ByProjectID", cnn.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
prm = cmd.Parameters.Add("@ProjectID", SqlDbType.Int);
prm.Value = projID;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oVar = new COBudget();
oVar.ID = Convert.ToInt32(dr["ID"]);
oVar.ProjectID = Convert.ToInt32(dr["ProjectID"]);
oVar.Revision = Convert.ToInt32(dr["Revision"]);
oVar.PCNID = Convert.ToInt32(dr["PCNID"]);
oVar.IsDefault = Convert.ToBoolean(dr["IsDefault"]);
oVar.IsActive = Convert.ToBoolean(dr["IsActive"]);
oVar.IsLocked = Convert.ToBoolean(dr["IsLocked"]);
oVar.Description = dr["Description"].ToString();
oVar.PreparedBy = dr["PreparedBy"].ToString();
oVar.Contingency = Convert.ToDecimal(dr["Contingency"]);
oVar.Clarification11000 = dr["Clarification11000"].ToString();
oVar.Clarification12000 = dr["Clarification12000"].ToString();
oVar.Clarification13000 = dr["Clarification13000"].ToString();
oVar.Clarification14000 = dr["Clarification14000"].ToString();
oVar.Clarification15000 = dr["Clarification15000"].ToString();
oVar.Clarification16000 = dr["Clarification16000"].ToString();
oVar.Clarification17000 = dr["Clarification17000"].ToString();
oVar.Clarification18000 = dr["Clarification18000"].ToString();
oVar.Clarification50000 = dr["Clarification50000"].ToString();
tmpStr = GetDataString();
}
dr = null;
prm = null;
cmd = null;
cnn.CloseConnection();
cnn = null;
return(tmpStr);
}
private void LoadVals(string strXml)
{
XmlSerializer s;
StringReader sr;
s = new XmlSerializer(typeof(COBudget));
sr = new System.IO.StringReader(strXml);
oVar = new COBudget();
oVar = (COBudget)s.Deserialize(sr);
sr.Close();
sr = null;
s = null;
}
public void LoadVals(string strXml)
{
XmlSerializer s;
StringReader sr;
COBudget o;
s = new XmlSerializer(typeof(COBudget));
sr = new System.IO.StringReader(strXml);
o = new COBudget();
o = (COBudget)s.Deserialize(sr);
base.LoadFromObj(o);
o = null;
sr.Close();
sr = null;
s = null;
}
public void LoadFromObj(COBudget oOrg)
{
miID = oOrg.ID;
miProjectID = oOrg.ProjectID;
miRevision = oOrg.Revision;
miPCNID = oOrg.PCNID;
mbIsDefault = oOrg.IsDefault;
mbIsActive = oOrg.IsActive;
mbIsLocked = oOrg.IsLocked;
msDescription = oOrg.Description;
msPreparedBy = oOrg.PreparedBy;
mdContingency = oOrg.Contingency;
msClarification11000 = oOrg.Clarification11000;
msClarification12000 = oOrg.Clarification12000;
msClarification13000 = oOrg.Clarification13000;
msClarification14000 = oOrg.Clarification14000;
msClarification15000 = oOrg.Clarification15000;
msClarification16000 = oOrg.Clarification16000;
msClarification17000 = oOrg.Clarification17000;
msClarification18000 = oOrg.Clarification18000;
msClarification50000 = oOrg.Clarification50000;
}
public void Copy(COBudget oNew)
{
oNew.ID = miID;
oNew.ProjectID = miProjectID;
oNew.Revision = miRevision;
oNew.PCNID = miPCNID;
oNew.IsDefault = mbIsDefault;
oNew.IsActive = mbIsActive;
oNew.IsLocked = mbIsLocked;
oNew.Description = msDescription;
oNew.PreparedBy = msPreparedBy;
oNew.Contingency = mdContingency;
oNew.Clarification11000 = msClarification11000;
oNew.Clarification12000 = msClarification12000;
oNew.Clarification13000 = msClarification13000;
oNew.Clarification14000 = msClarification14000;
oNew.Clarification15000 = msClarification15000;
oNew.Clarification16000 = msClarification16000;
oNew.Clarification17000 = msClarification17000;
oNew.Clarification18000 = msClarification18000;
oNew.Clarification50000 = msClarification50000;
}
public string GetDataString()
{
string tmpStr;
COBudget o;
XmlSerializer s;
StringWriter sw;
o = new COBudget();
s = new XmlSerializer(typeof(COBudget));
sw = new StringWriter();
base.Copy(o);
s.Serialize(sw, o);
tmpStr = sw.ToString();
o = null;
s = null;
sw = null;
return(tmpStr);
}
