public ActionResult Touroku_KeihiEntry(Touroku_KeihiModel kmodel)
{
if (string.IsNullOrWhiteSpace(kmodel.Mode))
{
kmodel.Mode = "New";
}
return(View(kmodel));
}
public ActionResult Touroku_KeihiList(Touroku_KeihiModel kmodel)
{
//New Mode Case
if (kmodel.Mode == "Edit" || kmodel.Mode == "Delete" || kmodel.status == "2")
{
kmodel.newmodelstatus = "sts";
}
return(View(kmodel));
}
//public string M_Control_FiscalCheck(BaseModel BModel) //Move to CommonBL
//{
// BaseDL bdl = new BaseDL();
// BModel.Sqlprms = new SqlParameter[1];
// BModel.Sqlprms[0] = new SqlParameter("@CastDate", SqlDbType.Date) { Value = BModel.inputdate };
// return bdl.SelectJson("M_Control_FiscalCheck", BModel.Sqlprms);
//}
public string D_Cost_TKeihiCSV(Touroku_KeihiModel Kmodel)
{
BaseDL bdl = new BaseDL();
Kmodel.Sqlprms = new SqlParameter[12];
Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.Int)
{
Value = (object)Kmodel.CostCD ?? DBNull.Value
};
Kmodel.Sqlprms[1] = new SqlParameter("@CostName", SqlDbType.VarChar)
{
Value = (object)Kmodel.CostName ?? DBNull.Value
};
Kmodel.Sqlprms[2] = new SqlParameter("@CostDateFrom", SqlDbType.Date)
{
Value = (object)Kmodel.CostDateFrom ?? DBNull.Value
};
Kmodel.Sqlprms[3] = new SqlParameter("@CostDateTo", SqlDbType.Date)
{
Value = (object)Kmodel.CostDateTo ?? DBNull.Value
};
Kmodel.Sqlprms[4] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.BrandCD ?? DBNull.Value
};
Kmodel.Sqlprms[5] = new SqlParameter("@BrandName", SqlDbType.VarChar)
{
Value = (object)Kmodel.BrandName ?? DBNull.Value
};
Kmodel.Sqlprms[6] = new SqlParameter("@Season", SqlDbType.VarChar)
{
Value = (object)Kmodel.Season ?? DBNull.Value
};
Kmodel.Sqlprms[7] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Kmodel.Year ?? DBNull.Value
};
Kmodel.Sqlprms[8] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.ProjectCD ?? DBNull.Value
};
Kmodel.Sqlprms[9] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
{
Value = (object)Kmodel.ProjectName ?? DBNull.Value
};
Kmodel.Sqlprms[10] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.HinbanCD ?? DBNull.Value
};
Kmodel.Sqlprms[11] = new SqlParameter("@HinbanName", SqlDbType.VarChar)
{
Value = (object)Kmodel.HinbanName ?? DBNull.Value
};
return(bdl.SelectJson("D_Cost_TKeihiCSV", Kmodel.Sqlprms));
}
public string M_Casting_ExistsCheck(Touroku_KeihiModel tkmodel)
{
BaseDL bdl = new BaseDL();
tkmodel.Sqlprms = new SqlParameter[1];
tkmodel.Sqlprms[0] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = tkmodel.CastingCD
};
return(bdl.SelectJson("M_Casting_ExistsCheck", tkmodel.Sqlprms));
}
public string M_HinBan_ExistsCheck(Touroku_KeihiModel Kmodel)
{
BaseDL bdl = new BaseDL();
Kmodel.Sqlprms = new SqlParameter[1];
Kmodel.Sqlprms[0] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = Kmodel.HinbanCD
};
return(bdl.SelectJson("M_HinBan_ExistsCheck", Kmodel.Sqlprms));
}
public string D_Cost_Edit_List(Touroku_KeihiModel kmodel)
{
BaseDL bdl = new BaseDL();
kmodel.Sqlprms = new SqlParameter[1];
kmodel.Sqlprms[0] = new SqlParameter("@SEQ", SqlDbType.Int)
{
Value = kmodel.SEQ
};
return(bdl.SelectJson("D_Cost_Edit_List", kmodel.Sqlprms));
}
public string M_Keihi_ExistsCheck(Touroku_KeihiModel Kmodel)
{
BaseDL bdl = new BaseDL();
Kmodel.Sqlprms = new SqlParameter[1];
Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.Int)
{
Value = (object)Kmodel.CostCD ?? DBNull.Value
};
return(bdl.SelectJson("M_Keihi_ExistsCheck", Kmodel.Sqlprms));
}
public string M_project_SelectByProjectCD(Touroku_KeihiModel Kmodel)
{
BaseDL bdl = new BaseDL();
Kmodel.Sqlprms = new SqlParameter[1];
Kmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Kmodel.ProjectCD
};
return(bdl.SelectJson("M_project_SelectByProjectCD", Kmodel.Sqlprms));
}
public string GetStockAmount_By_MaterialsCD(Touroku_KeihiModel Kmodel)
{
BaseDL bdl = new BaseDL();
Kmodel.Sqlprms = new SqlParameter[1];
Kmodel.Sqlprms[0] = new SqlParameter("@MaterialsCD", SqlDbType.Int)
{
Value = Kmodel.MaterialsCD
};
return(bdl.SelectJson("GetStockAmount_By_MaterialsCD", Kmodel.Sqlprms));
}
public string M_Keihi_Accounting5_ExistCheck(Touroku_KeihiModel Kmodel)
{
BaseDL bdl = new BaseDL();
Kmodel.Sqlprms = new SqlParameter[2];
Kmodel.Sqlprms[0] = new SqlParameter("@AccountingDate", SqlDbType.Int)
{
Value = Kmodel.CostDate
};
Kmodel.Sqlprms[1] = new SqlParameter("@FreeItem1", SqlDbType.VarChar)
{
Value = Kmodel.Item
};
return(bdl.SelectJson("M_Keihi_Accounting5_ExistCheck", Kmodel.Sqlprms));
}
public string GetTotalShipmentAmount_By_MaterialsCD(Touroku_KeihiModel Kmodel)
{
BaseDL bdl = new BaseDL();
Kmodel.Sqlprms = new SqlParameter[3];
Kmodel.Sqlprms[0] = new SqlParameter("@MaterialsCD", SqlDbType.Int)
{
Value = Kmodel.MaterialsCD
};
Kmodel.Sqlprms[1] = new SqlParameter("@CostSEQ", SqlDbType.Int)
{
Value = Kmodel.SEQ
};
Kmodel.Sqlprms[2] = new SqlParameter("@Mode", SqlDbType.VarChar)
{
Value = Kmodel.Mode
};
return(bdl.SelectJson("GetTotalShipmentAmount_By_MaterialsCD", Kmodel.Sqlprms));
}
public string Fnc_TAXCalculation(Touroku_KeihiModel tkmodel)
{
BaseDL bdl = new BaseDL();
tkmodel.Sqlprms = new SqlParameter[4];
tkmodel.Sqlprms[0] = new SqlParameter("@Mode", SqlDbType.VarChar)
{
Value = tkmodel.Mode
};
tkmodel.Sqlprms[1] = new SqlParameter("@ChangeDate", SqlDbType.VarChar)
{
Value = tkmodel.CostDate
};
tkmodel.Sqlprms[2] = new SqlParameter("@TaxRateFLG", SqlDbType.VarChar)
{
Value = tkmodel.flg
};
tkmodel.Sqlprms[3] = new SqlParameter("@Kingaku", SqlDbType.VarChar)
{
Value = tkmodel.CostAmount
};
return(bdl.SelectJson("Fnc_TAXCalculation", tkmodel.Sqlprms));
}
public string M_Keihi_Accounting2_ExistCheck(Touroku_KeihiModel Kmodel)
{
BaseDL bdl = new BaseDL();
Kmodel.Sqlprms = new SqlParameter[4];
Kmodel.Sqlprms[0] = new SqlParameter("@AccountingDate", SqlDbType.Int)
{
Value = Kmodel.CostDate
};
Kmodel.Sqlprms[1] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = Kmodel.BrandCD
};
Kmodel.Sqlprms[2] = new SqlParameter("@Season", SqlDbType.VarChar)
{
Value = Kmodel.Season
};
Kmodel.Sqlprms[3] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = Kmodel.Year
};
return(bdl.SelectJson("M_Keihi_Accounting2_ExistCheck", Kmodel.Sqlprms));
}
public string D_Cost_Select_List(Touroku_KeihiModel Kmodel)
{
BaseDL bdl = new BaseDL();
if (Kmodel.status.Equals("2"))
{
Kmodel.Sqlprms = new SqlParameter[2];
Kmodel.Sqlprms[0] = new SqlParameter("@status", SqlDbType.Int)
{
Value = (object)Kmodel.status ?? DBNull.Value
};
Kmodel.Sqlprms[1] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = (object)Kmodel.LoginID ?? DBNull.Value
};
return(bdl.SelectJson("Data_Show_List", Kmodel.Sqlprms));
}
Kmodel.Sqlprms = new SqlParameter[13];
Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.Int)
{
Value = (object)Kmodel.CostCD ?? DBNull.Value
};
Kmodel.Sqlprms[1] = new SqlParameter("@CostName", SqlDbType.VarChar)
{
Value = (object)Kmodel.CostName ?? DBNull.Value
};
Kmodel.Sqlprms[2] = new SqlParameter("@CostDateFrom", SqlDbType.Date)
{
Value = (object)Kmodel.CostDateFrom ?? DBNull.Value
};
Kmodel.Sqlprms[3] = new SqlParameter("@CostDateTo", SqlDbType.Date)
{
Value = (object)Kmodel.CostDateTo ?? DBNull.Value
};
Kmodel.Sqlprms[4] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.BrandCD ?? DBNull.Value
};
Kmodel.Sqlprms[5] = new SqlParameter("@BrandName", SqlDbType.VarChar)
{
Value = (object)Kmodel.BrandName ?? DBNull.Value
};
Kmodel.Sqlprms[6] = new SqlParameter("@Season", SqlDbType.VarChar)
{
Value = (object)Kmodel.Season ?? DBNull.Value
};
Kmodel.Sqlprms[7] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Kmodel.Year ?? DBNull.Value
};
Kmodel.Sqlprms[8] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.ProjectCD ?? DBNull.Value
};
Kmodel.Sqlprms[9] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
{
Value = (object)Kmodel.ProjectName ?? DBNull.Value
};
Kmodel.Sqlprms[10] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.HinbanCD ?? DBNull.Value
};
Kmodel.Sqlprms[11] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = (object)Kmodel.LoginID ?? DBNull.Value
};
Kmodel.Sqlprms[12] = new SqlParameter("@HinbanName", SqlDbType.VarChar)
{
Value = (object)Kmodel.HinbanName ?? DBNull.Value
};
return(bdl.SelectJson("D_Cost_History_Select", Kmodel.Sqlprms));
//if(string.IsNullOrEmpty(Kmodel.status))
//{
// Kmodel.Sqlprms = new SqlParameter[12];
// Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.Int) { Value = (object)Kmodel.CostCD ?? DBNull.Value };
// Kmodel.Sqlprms[1] = new SqlParameter("@CostName", SqlDbType.VarChar) { Value = (object)Kmodel.CostName ?? DBNull.Value };
// Kmodel.Sqlprms[2] = new SqlParameter("@CostDateFrom", SqlDbType.Date) { Value = (object)Kmodel.CostDateFrom ?? DBNull.Value };
// Kmodel.Sqlprms[3] = new SqlParameter("@CostDateTo", SqlDbType.Date) { Value = (object)Kmodel.CostDateTo ?? DBNull.Value };
// Kmodel.Sqlprms[4] = new SqlParameter("@BrandCD", SqlDbType.VarChar) { Value = (object)Kmodel.BrandCD ?? DBNull.Value };
// Kmodel.Sqlprms[5] = new SqlParameter("@BrandName", SqlDbType.VarChar) { Value = (object)Kmodel.BrandName ?? DBNull.Value };
// Kmodel.Sqlprms[6] = new SqlParameter("@Season", SqlDbType.VarChar) { Value = (object)Kmodel.Season ?? DBNull.Value };
// Kmodel.Sqlprms[7] = new SqlParameter("@Year", SqlDbType.Int) { Value = (object)Kmodel.Year ?? DBNull.Value };
// Kmodel.Sqlprms[8] = new SqlParameter("@ProjectCD", SqlDbType.VarChar) { Value = (object)Kmodel.ProjectCD ?? DBNull.Value };
// Kmodel.Sqlprms[9] = new SqlParameter("@ProjectName", SqlDbType.VarChar) { Value = (object)Kmodel.ProjectName ?? DBNull.Value };
// Kmodel.Sqlprms[10] = new SqlParameter("@HinbanCD", SqlDbType.VarChar) { Value = (object)Kmodel.HinbanCD ?? DBNull.Value };
// Kmodel.Sqlprms[11] = new SqlParameter("@HinbanName", SqlDbType.VarChar) { Value = (object)Kmodel.HinbanName ?? DBNull.Value };
// return bdl.SelectJson("D_Cost_Select_List", Kmodel.Sqlprms);
//}
}
public string M_project_SelectByProjectCD([FromBody] Touroku_KeihiModel kgmodel)
{
Touroku_Keihi_BL kgbl = new Touroku_Keihi_BL();
return(kgbl.M_project_SelectByProjectCD(kgmodel));
}
public string M_Casting_ExistsCheck([FromBody] Touroku_KeihiModel kgmodel)
{
Touroku_Keihi_BL kgbl = new Touroku_Keihi_BL();
return(kgbl.M_Casting_ExistsCheck(kgmodel));
}
public string M_Cost_Select_List([FromBody] Touroku_KeihiModel kgmodel)
{
Touroku_Keihi_BL kgbl = new Touroku_Keihi_BL();
return(kgbl.D_Cost_Select_List(kgmodel));
}
public string M_Keihi_Accounting2_ExistCheck([FromBody] Touroku_KeihiModel kgmodel)
{
Touroku_Keihi_BL kgbl = new Touroku_Keihi_BL();
return(kgbl.M_Keihi_Accounting2_ExistCheck(kgmodel));
}
public string M_Hinban_SelectByPJCDHBCD([FromBody] Touroku_KeihiModel kgmodel)
{
Touroku_Keihi_BL kgbl = new Touroku_Keihi_BL();
return(kgbl.M_Hinban_SelectByPJCDHBCD(kgmodel));
}
public string D_Cost_TKeihiCSV([FromBody] Touroku_KeihiModel kgmodel)
{
Touroku_Keihi_BL kgbl = new Touroku_Keihi_BL();
return(kgbl.D_Cost_TKeihiCSV(kgmodel));
}
public string D_Cost_CUD(Touroku_KeihiModel Kmodel)
{
BaseDL bdl = new BaseDL();
if (Kmodel.Mode.Equals("New"))
{
Kmodel.SPName = "D_Cost_Insert";
Kmodel.Sqlprms = new SqlParameter[14];
Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.Int)
{
Value = (object)Kmodel.CostCD ?? DBNull.Value
};
Kmodel.Sqlprms[1] = new SqlParameter("@CostDate", SqlDbType.Date)
{
Value = (object)Kmodel.CostDate ?? DBNull.Value
};
Kmodel.Sqlprms[2] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.BrandCD ?? DBNull.Value
};
Kmodel.Sqlprms[3] = new SqlParameter("@Season", SqlDbType.TinyInt)
{
Value = (object)Kmodel.Season ?? DBNull.Value
};
Kmodel.Sqlprms[4] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Kmodel.Year ?? DBNull.Value
};
Kmodel.Sqlprms[5] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.ProjectCD ?? DBNull.Value
};
Kmodel.Sqlprms[6] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.HinbanCD ?? DBNull.Value
};
Kmodel.Sqlprms[7] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.CastingCD ?? DBNull.Value
};
Kmodel.Sqlprms[8] = new SqlParameter("@FreeItem1", SqlDbType.VarChar)
{
Value = (object)Kmodel.Item ?? DBNull.Value
};
Kmodel.Sqlprms[9] = new SqlParameter("@ZeikomiKBN", SqlDbType.TinyInt)
{
Value = (object)Kmodel.ZeikomiKBN ?? DBNull.Value
};
Kmodel.Sqlprms[10] = new SqlParameter("@CostAmount", SqlDbType.Int)
{
Value = (object)Kmodel.CostAmount ?? DBNull.Value
};
Kmodel.Sqlprms[11] = new SqlParameter("@InputAmount", SqlDbType.Int)
{
Value = (object)Kmodel.InputAmount ?? DBNull.Value
};
Kmodel.Sqlprms[12] = new SqlParameter("@Remarks", SqlDbType.VarChar)
{
Value = (object)Kmodel.Remarks ?? DBNull.Value
};
Kmodel.Sqlprms[13] = new SqlParameter("@jsondata", SqlDbType.VarChar)
{
Value = (object)Kmodel.dt ?? DBNull.Value
};
}
else if (Kmodel.Mode.Equals("Edit"))
{
Kmodel.SPName = "D_Cost_UPDATE";
Kmodel.Sqlprms = new SqlParameter[15];
Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.Int)
{
Value = (object)Kmodel.CostCD ?? DBNull.Value
};
Kmodel.Sqlprms[1] = new SqlParameter("@CostDate", SqlDbType.Date)
{
Value = (object)Kmodel.CostDate ?? DBNull.Value
};
Kmodel.Sqlprms[2] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.BrandCD ?? DBNull.Value
};
Kmodel.Sqlprms[3] = new SqlParameter("@Season", SqlDbType.TinyInt)
{
Value = (object)Kmodel.Season ?? DBNull.Value
};
Kmodel.Sqlprms[4] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Kmodel.Year ?? DBNull.Value
};
Kmodel.Sqlprms[5] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.ProjectCD ?? DBNull.Value
};
Kmodel.Sqlprms[6] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.HinbanCD ?? DBNull.Value
};
Kmodel.Sqlprms[7] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.CastingCD ?? DBNull.Value
};
Kmodel.Sqlprms[8] = new SqlParameter("@FreeItem1", SqlDbType.VarChar)
{
Value = (object)Kmodel.Item ?? DBNull.Value
};
Kmodel.Sqlprms[9] = new SqlParameter("@ZeikomiKBN", SqlDbType.TinyInt)
{
Value = (object)Kmodel.ZeikomiKBN ?? DBNull.Value
};
Kmodel.Sqlprms[10] = new SqlParameter("@CostAmount", SqlDbType.Int)
{
Value = (object)Kmodel.CostAmount ?? DBNull.Value
};
Kmodel.Sqlprms[11] = new SqlParameter("@InputAmount", SqlDbType.Int)
{
Value = (object)Kmodel.InputAmount ?? DBNull.Value
};
Kmodel.Sqlprms[12] = new SqlParameter("@Remarks", SqlDbType.VarChar)
{
Value = (object)Kmodel.Remarks ?? DBNull.Value
};
Kmodel.Sqlprms[13] = new SqlParameter("@SEQ", SqlDbType.Int)
{
Value = (object)Kmodel.SEQ ?? DBNull.Value
};
Kmodel.Sqlprms[14] = new SqlParameter("@jsondata", SqlDbType.VarChar)
{
Value = (object)Kmodel.dt ?? DBNull.Value
};
}
else if (Kmodel.Mode.Equals("Copy"))
{
Kmodel.SPName = "D_Cost_Insert";
Kmodel.Sqlprms = new SqlParameter[14];
Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.Int)
{
Value = (object)Kmodel.CostCD ?? DBNull.Value
};
Kmodel.Sqlprms[1] = new SqlParameter("@CostDate", SqlDbType.Date)
{
Value = (object)Kmodel.CostDate ?? DBNull.Value
};
Kmodel.Sqlprms[2] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.BrandCD ?? DBNull.Value
};
Kmodel.Sqlprms[3] = new SqlParameter("@Season", SqlDbType.TinyInt)
{
Value = (object)Kmodel.Season ?? DBNull.Value
};
Kmodel.Sqlprms[4] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Kmodel.Year ?? DBNull.Value
};
Kmodel.Sqlprms[5] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.ProjectCD ?? DBNull.Value
};
Kmodel.Sqlprms[6] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.HinbanCD ?? DBNull.Value
};
Kmodel.Sqlprms[7] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = (object)Kmodel.CastingCD ?? DBNull.Value
};
Kmodel.Sqlprms[8] = new SqlParameter("@FreeItem1", SqlDbType.VarChar)
{
Value = (object)Kmodel.Item ?? DBNull.Value
};
Kmodel.Sqlprms[9] = new SqlParameter("@ZeikomiKBN", SqlDbType.TinyInt)
{
Value = (object)Kmodel.ZeikomiKBN ?? DBNull.Value
};
Kmodel.Sqlprms[10] = new SqlParameter("@CostAmount", SqlDbType.Int)
{
Value = (object)Kmodel.CostAmount ?? DBNull.Value
};
Kmodel.Sqlprms[11] = new SqlParameter("@InputAmount", SqlDbType.Int)
{
Value = (object)Kmodel.InputAmount ?? DBNull.Value
};
Kmodel.Sqlprms[12] = new SqlParameter("@Remarks", SqlDbType.VarChar)
{
Value = (object)Kmodel.Remarks ?? DBNull.Value
};
Kmodel.Sqlprms[13] = new SqlParameter("@jsondata", SqlDbType.VarChar)
{
Value = (object)Kmodel.dt ?? DBNull.Value
};
}
else if (Kmodel.Mode.Equals("Delete"))
{
Kmodel.SPName = "D_Cost_Delete";
Kmodel.Sqlprms = new SqlParameter[1];
Kmodel.Sqlprms[0] = new SqlParameter("@SEQ", SqlDbType.Int)
{
Value = (object)Kmodel.SEQ ?? DBNull.Value
};
}
return(bdl.SelectJson(Kmodel.SPName, Kmodel.Sqlprms));
}
public string GetTotalShipmentAmount_By_MaterialsCD([FromBody] Touroku_KeihiModel kgmodel)
{
Touroku_Keihi_BL kgbl = new Touroku_Keihi_BL();
return(kgbl.GetTotalShipmentAmount_By_MaterialsCD(kgmodel));
}
public string Fnc_TAXCalculation([FromBody] Touroku_KeihiModel kgmodel)
{
Touroku_Keihi_BL kgbl = new Touroku_Keihi_BL();
return(kgbl.Fnc_TAXCalculation(kgmodel));
}
