public static string getUnitsData(branches branch)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <branches> branches = new List <branches>();
List <Units> Units = new List <Units>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (SqlCommand cmd = new SqlCommand("select * from Units where Branch_id = @Branch_id", con))
{
cmd.Parameters.Add("@Branch_id", SqlDbType.Int).Value = branch.id;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
Units = populateUnitsLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(Units));
}
public static string getUnitsDashData(branches branch)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <UnitsDash> UnitsDash = new List <UnitsDash>();
List <branches> branches = new List <branches>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT * from Endorsement_UnitsDashboard where Shift_date >= DATEADD(day,-2, GETDATE()) and Unit_id in (select U_id from Units where Branch_id = @Branch_id) ORDER BY Shift_date DESC", con))
{
cmd.Parameters.Add("@Branch_id", SqlDbType.Int).Value = branch.id;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
UnitsDash = populateUnitsDashLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(UnitsDash));
}
public static string getUnitsData(branches branch)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <branches> branches = new List <branches>();
List <Units> Units = new List <Units>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT u.U_id,u.U_name, Units_Rooms.U_id, COUNT(Units_Rooms.R_id) AS RoomsNum from Units_Rooms RIGHT JOIN Units as u On u.Branch_id = @Branch_id and Units_Rooms.U_id = u.U_id GROUP BY Units_Rooms.U_id, u.U_id,u.U_name", con))
{
cmd.Parameters.Add("@Branch_id", SqlDbType.Int).Value = branch.id;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
Units = populateUnitsLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(Units));
}
public static string getRoomsData(branches branch)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Rooms> Rooms = new List <Rooms>();
List <branches> branches = new List <branches>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd = new SqlCommand("select * from Endorsement_Rooms where Branch_id = @branch and id in (select Room_id from Endorsement_RoomsDashboard where Status_id = 1)", con)
)
{
cmd.Parameters.Add("@branch", SqlDbType.Int).Value = branch.id;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
Rooms = populateRoomsLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(Rooms));
}
public ActionResult DeleteConfirmed(int id)
{
branches branches = db.branches.Find(id);
db.branches.Remove(branches);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "name,description,merge_executed,parent_branch,type,product,id")] branches branches)
{
if (ModelState.IsValid)
{
db.Entry(branches).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(branches));
}
public ActionResult Create([Bind(Include = "name,description,merge_executed,parent_branch,type,product,id")] branches branches)
{
if (ModelState.IsValid)
{
db.branches.Add(branches);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(branches));
}
// GET: Branches/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
branches branches = db.branches.Find(id);
if (branches == null)
{
return(HttpNotFound());
}
return(View(branches));
}
/// <summary>
/// 전달받은 DataSet으로 토적표 DATA를 구성한다.
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public DataTable SetData(DataTable dt)
{
foreach (DataRow item in dt.Rows)
{
long nKey;
int index, pre_index;
DataRow Dr = m_dt.NewRow();
nKey = Convert.ToInt64(item[CUtil.GetName(CPLH.enumPLH.key)].ToString());
index = (int)nKey - 1;
pre_index = index - 1;
Dr[CUtil.GetName(enumReport1Dat.key)] = nKey;
Dr[CUtil.GetName(enumReport1Dat.LINENAME)] = item[CUtil.GetName(CPLH.enumPLH.LINENAME)];
//측점 값 변경 NO. +
if (item[CUtil.GetName(CPLH.enumPLH.plus)].ToString().Trim() == "")
{
Dr[CUtil.GetName(enumReport1Dat.NO)] = item[CUtil.GetName(CPLH.enumPLH.NO)].ToString() + " +0.00";
}
else
{
Dr[CUtil.GetName(enumReport1Dat.NO)] = item[CUtil.GetName(CPLH.enumPLH.NO)].ToString() + " " + item[CUtil.GetName(CPLH.enumPLH.plus)].ToString();
}
Dr[CUtil.GetName(enumReport1Dat.dist2)] = item[CUtil.GetName(CPLH.enumPLH.dist2)];
Dr[CUtil.GetName(enumReport1Dat.dist)] = item[CUtil.GetName(CPLH.enumPLH.dist)];
Dr[CUtil.GetName(enumReport1Dat.area1)] = item[CUtil.GetName(CPLH.enumPLH.area1)]; //터파기 (토사)
Dr[CUtil.GetName(enumReport1Dat.area2)] = item[CUtil.GetName(CPLH.enumPLH.area2)]; //관주위
Dr[CUtil.GetName(enumReport1Dat.area3)] = item[CUtil.GetName(CPLH.enumPLH.area3)]; //관상단
Dr[CUtil.GetName(enumReport1Dat.area5)] = item[CUtil.GetName(CPLH.enumPLH.area5)]; //모래부설
Dr[CUtil.GetName(enumReport1Dat.area7)] = item[CUtil.GetName(CPLH.enumPLH.area7)]; //복구
Dr[CUtil.GetName(enumReport1Dat.asphalt1)] = item[CUtil.GetName(CPLH.enumPLH.asphalt1)]; //표층
Dr[CUtil.GetName(enumReport1Dat.asphalt2)] = item[CUtil.GetName(CPLH.enumPLH.asphalt2)]; //기층
//터파기 토사 (area1_2)
if (nKey == 1)
{
Dr[CUtil.GetName(enumReport1Dat.area1_2)] = "0.00";
}
else
{
double dprev_a2 = Convert.ToDouble(dt.Rows[pre_index][CUtil.GetName(CPLH.enumPLH.area1)].ToString());
double d_a2 = Convert.ToDouble(Dr[CUtil.GetName(enumReport1Dat.area1)] = item[CUtil.GetName(CPLH.enumPLH.area1)].ToString());
Dr[CUtil.GetName(enumReport1Dat.area1_2)] = Math.Round((dprev_a2 + d_a2) / 2 * Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.dist)].ToString()), 2).ToString();
}
//터파기 토사 (area2_2)
if (nKey == 1)
{
Dr[CUtil.GetName(enumReport1Dat.area2_2)] = "0.00";
}
else
{
double dprev_a2 = Convert.ToDouble(dt.Rows[pre_index][CUtil.GetName(CPLH.enumPLH.area2)].ToString());
double d_a2 = Convert.ToDouble(Dr[CUtil.GetName(enumReport1Dat.area2)] = item[CUtil.GetName(CPLH.enumPLH.area2)].ToString());
Dr[CUtil.GetName(enumReport1Dat.area2_2)] = Math.Round((dprev_a2 + d_a2) / 2 * Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.dist)].ToString()), 2).ToString();
}
//관상단 (area3_2)
if (nKey == 1)
{
Dr[CUtil.GetName(enumReport1Dat.area3_2)] = "0.00";
}
else
{
double dprev_a2 = Convert.ToDouble(dt.Rows[pre_index][CUtil.GetName(CPLH.enumPLH.area3)].ToString());
double d_a2 = Convert.ToDouble(Dr[CUtil.GetName(enumReport1Dat.area3)] = item[CUtil.GetName(CPLH.enumPLH.area3)].ToString());
Dr[CUtil.GetName(enumReport1Dat.area3_2)] = Math.Round((dprev_a2 + d_a2) / 2 * Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.dist)].ToString()), 2).ToString();
}
//관기초 (area5_2)
if (nKey == 1)
{
Dr[CUtil.GetName(enumReport1Dat.area5_2)] = "0.00";
}
else
{
double dprev_a2 = Convert.ToDouble(dt.Rows[pre_index][CUtil.GetName(CPLH.enumPLH.area5)].ToString());
double d_a2 = Convert.ToDouble(Dr[CUtil.GetName(enumReport1Dat.area5)] = item[CUtil.GetName(CPLH.enumPLH.area5)].ToString());
Dr[CUtil.GetName(enumReport1Dat.area5_2)] = Math.Round((dprev_a2 + d_a2) / 2 * Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.dist)].ToString()), 2).ToString();
}
if (Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.concrete)].ToString()) > 0) //concrete > 0
{
if (Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.concrete)].ToString()) == 0.07)
{
if (Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.complay)].ToString()) == 0.15)
{
if (Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.sand)].ToString()) == 0.05)
{
m_branches = branches.투수콘;
}
}
}
else // concrete 가 != 0.07
{
if (Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.asphalt1)].ToString()) > 0) //asphalt1 > 0
{
m_branches = branches.ASP_CON; //A+C
}
else //asphalt1 == 0
{
m_branches = branches.CONCRETE; //CONCRETE
}
}
}
else //concrete <= 0
{
if (Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.asphalt1)].ToString()) > 0 &&
Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.asphalt1)].ToString()) == 0.11 &&
Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.asphalt2)].ToString()) == 0.1
)
{
m_branches = branches.ASP국도; //ASP 국도
}
else if (Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.concrete)].ToString()) == 0)
{
// ASP 지방도
m_branches = branches.ASP;
}
}
if (nKey == 1)
{
calc_area7 = 0;
calc_area8 = 0;
calc_cut = 0;
}
else
{
double dprev_area7 = Convert.ToDouble(dt.Rows[pre_index][CUtil.GetName(CPLH.enumPLH.area7)].ToString());
double d_area7 = Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.area7)].ToString());
Dr[CUtil.GetName(enumReport1Dat.area7)] = item[CUtil.GetName(CPLH.enumPLH.area7)].ToString();
double dprev_area8 = Convert.ToDouble(dt.Rows[pre_index][CUtil.GetName(CPLH.enumPLH.area8)].ToString());
double d_area8 = Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.area8)].ToString());
Dr[CUtil.GetName(enumReport1Dat.area8)] = item[CUtil.GetName(CPLH.enumPLH.area8)].ToString();
double d_prev_dist2 = Convert.ToDouble(dt.Rows[pre_index][CUtil.GetName(CPLH.enumPLH.dist2)].ToString());
double d_dist2 = Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.dist2)].ToString());
calc_area7 = Math.Round((dprev_area7 + d_area7) / 2 * Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.dist)].ToString()), 2);
calc_area8 = Math.Round((dprev_area8 + d_area8) / 2 * Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.dist)].ToString()), 2);
calc_cut = Math.Round((d_dist2 - d_prev_dist2) * 2, 2);
}
//ASP 포장 (국도)
if (m_branches == branches.ASP국도)
{
Dr[CUtil.GetName(enumReport1Dat.ASP포장_국도_절단)] = calc_cut;
Dr[CUtil.GetName(enumReport1Dat.ASP포장_국도_복구_m)] = item[CUtil.GetName(enumReport1Dat.area7)].ToString();
Dr[CUtil.GetName(enumReport1Dat.ASP포장_국도_복구_m2)] = calc_area7.ToString();
Dr[CUtil.GetName(enumReport1Dat.ASP포장_국도_보조기층_m2)] = item[CUtil.GetName(enumReport1Dat.area8)].ToString();
Dr[CUtil.GetName(enumReport1Dat.ASP포장_국도_보조기층_m3)] = calc_area8.ToString();
}
//ASP 포장 (지방도)
if (m_branches == branches.ASP)
{
Dr[CUtil.GetName(enumReport1Dat.ASP포장_지방도_절단)] = calc_cut;
Dr[CUtil.GetName(enumReport1Dat.ASP포장_지방도_복구_m)] = item[CUtil.GetName(enumReport1Dat.area7)].ToString();
Dr[CUtil.GetName(enumReport1Dat.ASP포장_지방도_복구_m2)] = calc_area7.ToString();
Dr[CUtil.GetName(enumReport1Dat.ASP포장_지방도_보조기층_m2)] = item[CUtil.GetName(enumReport1Dat.area8)].ToString();
Dr[CUtil.GetName(enumReport1Dat.ASP포장_지방도_보조기층_m3)] = calc_area8.ToString();
}
//Con'c 포장
if (m_branches == branches.CONCRETE)
{
Dr[CUtil.GetName(enumReport1Dat.CON포장_절단)] = calc_cut;
Dr[CUtil.GetName(enumReport1Dat.CON포장_복구_m)] = item[CUtil.GetName(enumReport1Dat.area7)].ToString();
Dr[CUtil.GetName(enumReport1Dat.CON포장_복구_m2)] = calc_area7.ToString();
Dr[CUtil.GetName(enumReport1Dat.CON포장_보조기층_m2)] = item[CUtil.GetName(enumReport1Dat.area8)].ToString();
Dr[CUtil.GetName(enumReport1Dat.CON포장_보조기층_m3)] = calc_area8.ToString();
}
//asp + con'c 포장
if (m_branches == branches.ASP_CON)
{
Dr[CUtil.GetName(enumReport1Dat.ASP_CON포장_절단)] = calc_cut;
Dr[CUtil.GetName(enumReport1Dat.ASP_CON포장_복구_m)] = item[CUtil.GetName(enumReport1Dat.area7)].ToString();
Dr[CUtil.GetName(enumReport1Dat.ASP_CON포장_복구_m2)] = calc_area7.ToString();
Dr[CUtil.GetName(enumReport1Dat.ASP_CON포장_보조기층_m2)] = item[CUtil.GetName(enumReport1Dat.area8)].ToString();
Dr[CUtil.GetName(enumReport1Dat.ASP_CON포장_보조기층_m3)] = calc_area8.ToString();
}
//투수콘
if (m_branches == branches.투수콘)
{
Dr[CUtil.GetName(enumReport1Dat.투수콘_절단)] = calc_cut;
Dr[CUtil.GetName(enumReport1Dat.투수콘_복구_m)] = item[CUtil.GetName(enumReport1Dat.area7)].ToString();
Dr[CUtil.GetName(enumReport1Dat.투수콘_복구_m2)] = calc_area7.ToString();
Dr[CUtil.GetName(enumReport1Dat.투수콘_보조기층_m2)] = item[CUtil.GetName(enumReport1Dat.area8)].ToString();
Dr[CUtil.GetName(enumReport1Dat.투수콘_보조기층_m3)] = calc_area8.ToString();
}
//보도블럭
//humanity > 0
if (Convert.ToDouble(item[CUtil.GetName(CPLH.enumPLH.humanity)].ToString()) > 0)
{
Dr[CUtil.GetName(enumReport1Dat.보도블럭_복구_m)] = item[CUtil.GetName(enumReport1Dat.area7)].ToString();
Dr[CUtil.GetName(enumReport1Dat.보도블럭_복구_m2)] = calc_area7.ToString();
}
m_dt.Rows.Add(Dr);
}//end if for each
return(m_dt);
}
