public int CreateFOrderDetails(FOD2018 ent) { int createid = 0; FOrderDetails2018DAO entDAO = new FOrderDetails2018DAO(); sc = new SqlCommand("CreateFOrderDetails2018"); sc.CommandType = CommandType.StoredProcedure; addParameters(ent); createid = (entDAO.createEntity(sc)); return(createid); }
void AddParametersToSqlCommand(FOD2018 ent, ref SqlCommand sc) { sc.Parameters.Add("@FOrderID", ent.FOrderID); sc.Parameters.Add("@VodomerID", ent.VodomerID); sc.Parameters.Add("@StartValue", ent.StartValue); //sc.Parameters.Add("@EndValue", ent.EndValue); /*sc.Parameters.Add("@Price", ent.Price); * sc.Parameters.Add("@PriceRub", ent.PriceRub); * sc.Parameters.Add("@SpecialPrice", ent.SpecialPrice);*/ sc.Parameters.Add("@DefectVodomer", ent.DefectVodomer); }
public override UniversalEntity createEntity() { UniversalEntity ue = new UniversalEntity(); while (!dr.Read()) { FOD2018 ent = new FOD2018(); ent = createEntityFromReader(dr); ue.Add(ent); } return(ue); }
public FOD2018 createEntityFromReader(SqlDataReader dr) { FOD2018 ent = new FOD2018(); if (!dr.IsDBNull(dr.GetOrdinal("ID"))) { ent.ID = Convert.ToInt32(dr["ID"]); } if (!dr.IsDBNull(dr.GetOrdinal("FOrderID"))) { ent.FOrderID = Convert.ToInt32(dr["FOrderID"]); } if (!dr.IsDBNull(dr.GetOrdinal("VodomerID"))) { ent.VodomerID = Convert.ToInt32(dr["VodomerID"]); } if (!dr.IsDBNull(dr.GetOrdinal("StartValue"))) { ent.StartValue = dr["StartValue"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("EndValue"))) { ent.EndValue = dr["EndValue"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("Price"))) { ent.Price = Convert.ToDouble(dr["Price"]); } if (!dr.IsDBNull(dr.GetOrdinal("PriceRub"))) { ent.PriceRub = Convert.ToDouble(dr["PriceRub"]); } if (!dr.IsDBNull(dr.GetOrdinal("SpecialPrice"))) { ent.SpecialPrice = Convert.ToDouble(dr["SpecialPrice"]); } if (!dr.IsDBNull(dr.GetOrdinal("DefectVodomer"))) { ent.DefectVodomer = dr["DefetcVodomer"].ToString(); } return(ent); }
void addParameters(FOD2018 ent) { AddParametersToSqlCommand(ent, ref sc); }
//Сохранение в базу protected void lbSaveAll_Click(object sender, EventArgs e) { if (Session["Abonent"] != null) { SessionAbonent sa = (SessionAbonent)Session["Abonent"]; if (sa.Vodomer.Count == 0) { radWM.RadAlert("Необходимо добавить минимум 1 водомер.", null, null, "Предупреждение", ""); } else { if (sa.Type == (short)Abonent.Corporate) { UAbonent ua = sa.UAbon; UAbonentDO uado = new UAbonentDO(); int uid = uado.Create(ua); if (uid > 0) { sa.UAbon.ID = uid; Session["Abonent"] = sa; UOrder uo = new UOrder(); UOrderDO uodo = new UOrderDO(); uo.ActionType = "*377;08;1;1 Опр. метр. хар."; uo.UAbonentID = uid; uo.UserID = GetCurrentUser().ID; int uoid = uodo.Create(uo); if (uoid > 0) { hfOrder.Value = uoid.ToString(); UOrderDetails uod = new UOrderDetails(); UOrderDetailsDO uoddo = new UOrderDetailsDO(); VodomerDO vdo = new VodomerDO(); foreach (Vodomer v in sa.Vodomer) { int vid = vdo.Create1(v); uod.UOrderID = uoid; uod.VodomerID = vid; uod.StartValue = v.VodomerPreview.StartValue; int uodid = uoddo.Create(uod); } Response.Redirect("UJournal.aspx?id=" + uoid.ToString()); } } } if (sa.Type == (short)Abonent.Private) { NewFAbonent fa = sa.FAbon; NewFAbonentDO fado = new NewFAbonentDO(); int fid = fado.Create(fa); if (fid > 0) { sa.FAbon.ID = fid; Session["Abonent"] = sa; NewFOrder fo = new NewFOrder(); NewFOrderDO fodo = new NewFOrderDO(); fo.ActionType = "*377;08;1;0 Проведение периодической поверки счетчика"; fo.FAbonentID = fid; fo.UserID = GetCurrentUser().ID; int foid = fodo.Create(fo); if (foid > 0) { hfOrder.Value = foid.ToString(); FOD2018 fod = new FOD2018(); FOrderDetails2018DO foddo = new FOrderDetails2018DO(); VodomerDO vdo = new VodomerDO(); foreach (Vodomer v in sa.Vodomer) { int vid = vdo.Create1(v); fod.FOrderID = foid; fod.VodomerID = vid; fod.StartValue = v.VodomerPreview.StartValue; int uodid = foddo.CreateFOrderDetails(fod); } Response.Redirect("FJournal2018.aspx?id=" + foid.ToString()); } } } if (sa.Type == (short)Abonent.Special) { AlternativeAbonent sab = sa.AlternativeAbon; AlternativeAbonentDO sabo = new AlternativeAbonentDO(); int fid = sabo.Create(sab); if (fid > 0) { sa.AlternativeAbon.ID = fid; Session["Abonent"] = sa; AlternativeOrder so = new AlternativeOrder(); AlternativeOrderDO sod = new AlternativeOrderDO(); so.WorkType = "*377;09;1;1 Снятие/установка водомеров."; so.SAbonentID = fid; so.UserID = GetCurrentUser().ID; int soid = sod.CreateSOrder(so); if (soid > 0) { hfOrder.Value = soid.ToString(); AlternativeOrderDetails sd = new AlternativeOrderDetails(); AlternativeOrderDetailsDO sodDO = new AlternativeOrderDetailsDO(); VodomerDO vdo = new VodomerDO(); foreach (Vodomer v in sa.Vodomer) { int vid = vdo.Create1(v); sd.SOrderID = soid; sd.VodomerID = vid; sd.StartValue = v.VodomerPreview.StartValue; int uodid = sodDO.Create(sd); } Response.Redirect("SJournal.aspx?id=" + soid.ToString()); } } } // LoadStep3(); } } }