public ActionResult KeihiSetteiEntry(KeihiSetteiModel Kmodel)
{
if (string.IsNullOrWhiteSpace(Kmodel.Mode))
{
Kmodel.Mode = "New";
}
return(View(Kmodel));
}
public string M_Keihi_ExistsCheck([FromBody] KeihiSetteiModel Kmodel)
{
if (Kmodel == null)
{
Kmodel = new KeihiSetteiModel();
}
KeihiSettei_BL Ubl = new KeihiSettei_BL();
return(Ubl.M_Keihi_ExistsCheck(Kmodel));
}
public string M_Keihi_Select_Entry([FromBody] KeihiSetteiModel Kmodel)
{
if (Kmodel == null)
{
Kmodel = new KeihiSetteiModel();
}
KeihiSettei_BL Ubl = new KeihiSettei_BL();
return(Ubl.M_Keihi_Select_Entry(Kmodel));
}
public string M_Keihi_ExistsCheck(KeihiSetteiModel Kmodel)
{
BaseDL bdl = new BaseDL();
Kmodel.Sqlprms = new SqlParameter[1];
Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.CostCD ?? DBNull.Value
};
return(bdl.SelectJson("M_Keihi_ExistsCheck", Kmodel.Sqlprms));
}
public string M_Keihi_Select_Entry(KeihiSetteiModel Kmodel)
{
BaseDL bdl = new BaseDL();
Kmodel.Sqlprms = new SqlParameter[1];
Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.VarChar)
{
Value = Kmodel.CostCD
};
return(bdl.SelectJson("M_Keihi_Select_Entry", Kmodel.Sqlprms));
}
public string Keihi_CUD([FromBody] KeihiSetteiModel Kmodel)
{
KeihiSettei_BL Ubl = new KeihiSettei_BL();
return(Ubl.Keihi_CUD(Kmodel));
}
public string Keihi_CUD(KeihiSetteiModel Kmodel)
{
BaseDL bdl = new BaseDL();
if (Kmodel.Mode.Equals("New"))
{
Kmodel.SPName = "M_Keihi_Insert";
Kmodel.Sqlprms = new SqlParameter[6];
Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.VarChar)
{
Value = Kmodel.CostCD
};
Kmodel.Sqlprms[1] = new SqlParameter("@CostName", SqlDbType.VarChar)
{
Value = Kmodel.CostName
};
Kmodel.Sqlprms[2] = new SqlParameter("@KanjoCD", SqlDbType.VarChar)
{
Value = Kmodel.KanjoCD
};
Kmodel.Sqlprms[3] = new SqlParameter("@HojoCD", SqlDbType.VarChar)
{
Value = Kmodel.HojoCD
};
Kmodel.Sqlprms[4] = new SqlParameter("@Accounting", SqlDbType.TinyInt)
{
Value = Kmodel.Accounting
};
Kmodel.Sqlprms[5] = new SqlParameter("@Allocation", SqlDbType.TinyInt)
{
Value = Kmodel.Allocation
};
}
else if (Kmodel.Mode.Equals("Edit"))
{
Kmodel.SPName = "M_Keihi_Update";
Kmodel.Sqlprms = new SqlParameter[6];
Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.VarChar)
{
Value = Kmodel.CostCD
};
Kmodel.Sqlprms[1] = new SqlParameter("@CostName", SqlDbType.VarChar)
{
Value = Kmodel.CostName
};
Kmodel.Sqlprms[2] = new SqlParameter("@KanjoCD", SqlDbType.VarChar)
{
Value = Kmodel.KanjoCD
};
Kmodel.Sqlprms[3] = new SqlParameter("@HojoCD", SqlDbType.VarChar)
{
Value = Kmodel.HojoCD
};
Kmodel.Sqlprms[4] = new SqlParameter("@Accounting", SqlDbType.TinyInt)
{
Value = Kmodel.Accounting
};
Kmodel.Sqlprms[5] = new SqlParameter("@Allocation", SqlDbType.TinyInt)
{
Value = Kmodel.Allocation
};
}
else if (Kmodel.Mode.Equals("Delete"))
{
Kmodel.SPName = "M_Keihi_Delete";
Kmodel.Sqlprms = new SqlParameter[1];
Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.VarChar)
{
Value = Kmodel.CostCD
};
}
return(bdl.SelectJson(Kmodel.SPName, Kmodel.Sqlprms));
}
