public void LoadFromObj(COBudgetExpenseLine oOrg) { miID = oOrg.ID; miBudgetID = oOrg.BudgetID; miDeptGroup = oOrg.DeptGroup; miEntryLevel = oOrg.EntryLevel; msCode = oOrg.Code; msDescription = oOrg.Description; mdMarkUp = oOrg.MarkUp; miUOMID = oOrg.UOMID; mdDollarsEach = oOrg.DollarsEach; miQuantity = oOrg.Quantity; mdMarkupDollars = oOrg.MarkupDollars; mdTotalDollars = oOrg.TotalDollars; }
public void Copy(COBudgetExpenseLine oNew) { oNew.ID = miID; oNew.BudgetID = miBudgetID; oNew.DeptGroup = miDeptGroup; oNew.EntryLevel = miEntryLevel; oNew.Code = msCode; oNew.Description = msDescription; oNew.MarkUp = mdMarkUp; oNew.UOMID = miUOMID; oNew.DollarsEach = mdDollarsEach; oNew.Quantity = miQuantity; oNew.MarkupDollars = mdMarkupDollars; oNew.TotalDollars = mdTotalDollars; }
private void LoadVals(string strXml) { XmlSerializer s; StringReader sr; s = new XmlSerializer(typeof(COBudgetExpenseLine)); sr = new System.IO.StringReader(strXml); oVar = new COBudgetExpenseLine(); oVar = (COBudgetExpenseLine)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("spBudgetExpenseLine_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 COBudgetExpenseLine(); oVar.ID = Convert.ToInt32(dr["ID"]); oVar.BudgetID = Convert.ToInt32(dr["BudgetID"]); oVar.DeptGroup = Convert.ToInt32(dr["DeptGroup"]); oVar.EntryLevel = Convert.ToInt32(dr["EntryLevel"]); oVar.Code = dr["Code"].ToString(); oVar.Description = dr["Description"].ToString(); oVar.MarkUp = Convert.ToDecimal(dr["MarkUp"]); oVar.UOMID = Convert.ToInt32(dr["UOMID"]); oVar.DollarsEach = Convert.ToDecimal(dr["DollarsEach"]); oVar.Quantity = Convert.ToInt32(dr["Quantity"]); oVar.MarkupDollars = Convert.ToDecimal(dr["MarkupDollars"]); oVar.TotalDollars = Convert.ToDecimal(dr["TotalDollars"]); tmpStr = GetDataString(); } dr = null; prm = null; cmd = null; cnn.CloseConnection(); cnn = null; return(tmpStr); }
public void LoadVals(string strXml) { XmlSerializer s; StringReader sr; COBudgetExpenseLine o; s = new XmlSerializer(typeof(COBudgetExpenseLine)); sr = new System.IO.StringReader(strXml); o = new COBudgetExpenseLine(); o = (COBudgetExpenseLine)s.Deserialize(sr); base.LoadFromObj(o); o = null; sr.Close(); sr = null; s = null; }
public string GetDataString() { string tmpStr; COBudgetExpenseLine o; XmlSerializer s; StringWriter sw; o = new COBudgetExpenseLine(); s = new XmlSerializer(typeof(COBudgetExpenseLine)); sw = new StringWriter(); base.Copy(o); s.Serialize(sw, o); tmpStr = sw.ToString(); o = null; s = null; sw = null; return(tmpStr); }