public string M_HinBan_Select_List(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[0];
return(bdl.SelectJson("M_HinBan_Select_List", Tmodel.Sqlprms));
}
//public string LessthanZero_Checking(string input)
//{
// string result = string.Empty;
// if (!String.IsNullOrWhiteSpace(input))
// {
// int data = int.Parse(input);
// if (data <= 0)
// {
// result = "[{\"resultdata\" : \"" + input + "\", \"flg\" : \"false\"}]";
// return result;
// }
// else
// {
// result = "[{\"resultdata\" : \"" + input + "\", \"flg\" : \"true\"}]";
// return result;
// }
// }
// else
// {
// return result;
// }
//}
public string M_Hinban_Price_Check(TourokuProjectModel tmodel)
{
string result = string.Empty;
if (!string.IsNullOrWhiteSpace(tmodel.StartPrice) && !string.IsNullOrWhiteSpace(tmodel.EndPrice))
{
int startprice = int.Parse(tmodel.StartPrice);
int endprice = int.Parse(tmodel.EndPrice);
if (startprice >= endprice)
{
result = "[{\"resultdata\" : \"" + endprice + "\", \"flg\" : \"false\"}]";
return(result);
}
else
{
result = "[{\"resultdata\" : \"" + endprice + "\", \"flg\" : \"true\"}]";
return(result);
}
}
else
{
return(result);
}
}
public string M_Hinban_Previous_Next(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[6];
Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.ProjectCD ?? DBNull.Value
};
Tmodel.Sqlprms[1] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.HinbanCD ?? DBNull.Value
};
Tmodel.Sqlprms[2] = new SqlParameter("@status", SqlDbType.VarChar)
{
Value = (object)Tmodel.status ?? DBNull.Value
};
Tmodel.Sqlprms[3] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = (object)Tmodel.LoginID ?? DBNull.Value
};
Tmodel.Sqlprms[4] = new SqlParameter("@Number", SqlDbType.Int)
{
Value = (object)Tmodel.Number ?? DBNull.Value
};
Tmodel.Sqlprms[5] = new SqlParameter("@Previous_Next", SqlDbType.VarChar)
{
Value = (object)Tmodel.Previous_Next ?? DBNull.Value
};
return(bdl.SelectJson("M_Hinban_Previous_Next", Tmodel.Sqlprms));
}
public ActionResult TourokuHinban_Entry(TourokuProjectModel Tmodel)
{
if (string.IsNullOrWhiteSpace(Tmodel.Mode))
{
Tmodel.Mode = "New";
}
return(View(Tmodel));
}
// GET: Touroku
public ActionResult TourokuProject_List(TourokuProjectModel Tmodel)
{
//New Mode Case
if (Tmodel.Mode == "Edit" || Tmodel.Mode == "Delete" || Tmodel.status == "3")
{
Tmodel.newmodelstatus = "sts";
}
return(View(Tmodel));
}
public string M_Project_Select_Entry([FromBody] TourokuProjectModel Tmodel)
{
if (Tmodel == null)
{
Tmodel = new TourokuProjectModel();
}
TourokuProject_BL Tpbl = new TourokuProject_BL();
return(Tpbl.M_Project_Select_Entry(Tmodel));
}
public string M_HinBan_ExistsCheck(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[1];
Tmodel.Sqlprms[0] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.HinbanCD ?? DBNull.Value
};
return(bdl.SelectJson("M_HinBan_ExistsCheck", Tmodel.Sqlprms));
}
public string M_Hinban_Check_List(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[1];
Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
return(bdl.SelectJson("M_Hinban_Check_List", Tmodel.Sqlprms));
}
public string M_Project_Select_Entry(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[1];
Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.ProjectCD ?? DBNull.Value
};
return(bdl.SelectJson("M_Project_Select_Entry", Tmodel.Sqlprms));
}
public ActionResult TourokuHinban_List(TourokuProjectModel Tmodel)
{
if (!string.IsNullOrEmpty(Tmodel.ProjectCD1) && string.IsNullOrWhiteSpace(Tmodel.ProjectCD1))
{
Tmodel.ProjectCD1 = null;
}
//New Mode Case
if (Tmodel.Mode == "Edit" || Tmodel.Mode == "Delete" || Tmodel.status == "4")
{
Tmodel.newmodelstatus = "sts";
}
return(View(Tmodel));
}
public string Project_CUD([FromBody] TourokuProjectModel Tmodel)
{
if (!string.IsNullOrWhiteSpace(Tmodel.PeriodStart))
{
Tmodel.PeriodStart = Tmodel.PeriodStart.Replace("/", "");
}
if (!string.IsNullOrWhiteSpace(Tmodel.PeriodEnd))
{
Tmodel.PeriodEnd = Tmodel.PeriodEnd.Replace("/", "");
}
TourokuProject_BL Tpbl = new TourokuProject_BL();
return(Tpbl.Project_CUD(Tmodel));
}
public string M_HinBan_Search_Search([FromBody] TourokuProjectModel Tmodel)
{
if (!string.IsNullOrWhiteSpace(Tmodel.StartPrice))
{
Tmodel.StartPrice = Tmodel.StartPrice.Replace(",", "");
}
if (!string.IsNullOrWhiteSpace(Tmodel.EndPrice))
{
Tmodel.EndPrice = Tmodel.EndPrice.Replace(",", "");
}
TourokuProject_BL Tpbl = new TourokuProject_BL();
return(Tpbl.M_HinBan_Search_Search(Tmodel));
}
public string M_Hinban_Price_Check([FromBody] TourokuProjectModel Tmodel)
{
if (!string.IsNullOrWhiteSpace(Tmodel.StartPrice))
{
Tmodel.StartPrice = Tmodel.StartPrice.Replace(",", "");
}
if (!string.IsNullOrWhiteSpace(Tmodel.EndPrice))
{
Tmodel.EndPrice = Tmodel.EndPrice.Replace(",", "");
}
TourokuProject_BL tbl = new TourokuProject_BL();
return(tbl.M_Hinban_Price_Check(Tmodel));
}
public string D_Devliery_ExistsDeleteCheck(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[2];
Tmodel.Sqlprms[0] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.HinbanCD ?? DBNull.Value
};
Tmodel.Sqlprms[1] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.ProjectCD ?? DBNull.Value
};
return(bdl.SelectJson("D_Devliery_ExistsDeleteCheck", Tmodel.Sqlprms));
}
public string M_Casting_BrandCDCheck(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[2];
Tmodel.Sqlprms[0] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = Tmodel.CastingCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = Tmodel.BrandCD
};
return(bdl.SelectJson("M_Casting_BrandCDCheck", Tmodel.Sqlprms));
}
public string M_HinBan_Select_Edit(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[2];
Tmodel.Sqlprms[0] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = Tmodel.HinbanCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
return(bdl.SelectJson("M_Hinban_Select_Entry", Tmodel.Sqlprms));
}
public string M_Hinban_CSV(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[2];
Tmodel.Sqlprms[0] = new SqlParameter("@filename", SqlDbType.VarChar)
{
Value = Tmodel.filename
};
Tmodel.Sqlprms[1] = new SqlParameter("@jsondata", SqlDbType.VarChar)
{
Value = Tmodel.dt
};
return(bdl.SelectJson("M_Hinban_CSV_Import", Tmodel.Sqlprms));
}
public string M_Project_CSV(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[10];
Tmodel.Sqlprms[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = Tmodel.BrandCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@BrandName", SqlDbType.VarChar)
{
Value = Tmodel.BrandName
};
Tmodel.Sqlprms[2] = new SqlParameter("@Season", SqlDbType.VarChar)
{
Value = Tmodel.Season
};
Tmodel.Sqlprms[3] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Tmodel.Year ?? DBNull.Value
};
Tmodel.Sqlprms[4] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.ProjectCD ?? DBNull.Value
};
Tmodel.Sqlprms[5] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
{
Value = Tmodel.ProjectName
};
Tmodel.Sqlprms[6] = new SqlParameter("@PeriodStart", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodStart ?? DBNull.Value
};
Tmodel.Sqlprms[7] = new SqlParameter("@PeriodEnd", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodEnd ?? DBNull.Value
};
Tmodel.Sqlprms[8] = new SqlParameter("@ProjectManager", SqlDbType.VarChar)
{
Value = Tmodel.ProjectManager
};
Tmodel.Sqlprms[9] = new SqlParameter("@UserName", SqlDbType.VarChar)
{
Value = Tmodel.ProjectManagerName
};
return(bdl.SelectJson("M_Project_CSV", Tmodel.Sqlprms));
}
public string Hinban_CUD([FromBody] TourokuProjectModel Tmodel)
{
if (!string.IsNullOrWhiteSpace(Tmodel.SalePrice))
{
Tmodel.SalePrice = Tmodel.SalePrice.Replace(",", "");
}
if (!string.IsNullOrWhiteSpace(Tmodel.Production))
{
Tmodel.Production = Tmodel.Production.Replace(",", "");
}
if (!string.IsNullOrWhiteSpace(Tmodel.EstimatedPrice))
{
Tmodel.EstimatedPrice = Tmodel.EstimatedPrice.Replace(",", "");
}
TourokuProject_BL Tpbl = new TourokuProject_BL();
return(Tpbl.Hinban_CUD(Tmodel));
}
public string M_Hinban_CSV([FromBody] TourokuProjectModel Tmodel)
{
TourokuProject_BL tpbl = new TourokuProject_BL();
return(tpbl.M_Hinban_CSV(Tmodel));
}
public string M_Hinban_Previous_Next([FromBody] TourokuProjectModel Tmodel)
{
TourokuProject_BL tpbl = new TourokuProject_BL();
return(tpbl.M_Hinban_Previous_Next(Tmodel));
}
public string Hinban_CUD(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
if (Tmodel.Mode.Equals("New"))
{
Tmodel.SPName = "M_Hinban_Insert";
Tmodel.Sqlprms = new SqlParameter[12];
Tmodel.Sqlprms[0] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = Tmodel.CastingCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
Tmodel.Sqlprms[2] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = Tmodel.HinbanCD
};
Tmodel.Sqlprms[3] = new SqlParameter("@HinbanName", SqlDbType.VarChar)
{
Value = Tmodel.HinbanName
};
Tmodel.Sqlprms[4] = new SqlParameter("@Color", SqlDbType.TinyInt)
{
Value = (object)Tmodel.Color ?? DBNull.Value
};
Tmodel.Sqlprms[5] = new SqlParameter("@Production", SqlDbType.Int)
{
Value = (object)Tmodel.Production ?? DBNull.Value
};
Tmodel.Sqlprms[6] = new SqlParameter("@freeitem1", SqlDbType.VarChar)
{
Value = Tmodel.FreeItem1
};
Tmodel.Sqlprms[7] = new SqlParameter("@freeitem2", SqlDbType.Int)
{
Value = (object)Tmodel.FreeItem2 ?? DBNull.Value
};
Tmodel.Sqlprms[8] = new SqlParameter("@saleprice", SqlDbType.Int)
{
Value = (object)Tmodel.SalePrice ?? DBNull.Value
};
//add by ssa 20220917
Tmodel.Sqlprms[9] = new SqlParameter("@CategoryCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.CategoryCD ?? DBNull.Value
};
Tmodel.Sqlprms[10] = new SqlParameter("@Rate", SqlDbType.VarChar)
{
Value = (object)Tmodel.Rate ?? DBNull.Value
};
Tmodel.Sqlprms[11] = new SqlParameter("@EstimatedPrice", SqlDbType.Int)
{
Value = (object)Tmodel.EstimatedPrice ?? DBNull.Value
};
}
else if (Tmodel.Mode.Equals("Edit"))
{
Tmodel.SPName = "M_Hinban_Update";
Tmodel.Sqlprms = new SqlParameter[12];
Tmodel.Sqlprms[0] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = Tmodel.CastingCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
Tmodel.Sqlprms[2] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = Tmodel.HinbanCD
};
Tmodel.Sqlprms[3] = new SqlParameter("@HinbanName", SqlDbType.VarChar)
{
Value = Tmodel.HinbanName
};
Tmodel.Sqlprms[4] = new SqlParameter("@Color", SqlDbType.TinyInt)
{
Value = (object)Tmodel.Color ?? DBNull.Value
};
Tmodel.Sqlprms[5] = new SqlParameter("@Production", SqlDbType.Int)
{
Value = (object)Tmodel.Production ?? DBNull.Value
};
Tmodel.Sqlprms[6] = new SqlParameter("@freeitem1", SqlDbType.VarChar)
{
Value = Tmodel.FreeItem1
};
Tmodel.Sqlprms[7] = new SqlParameter("@freeitem2", SqlDbType.Int)
{
Value = (object)Tmodel.FreeItem2 ?? DBNull.Value
};
Tmodel.Sqlprms[8] = new SqlParameter("@saleprice", SqlDbType.Int)
{
Value = (object)Tmodel.SalePrice ?? DBNull.Value
};
//add by ssa 20220917
Tmodel.Sqlprms[9] = new SqlParameter("@CategoryCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.CategoryCD ?? DBNull.Value
};
Tmodel.Sqlprms[10] = new SqlParameter("@Rate", SqlDbType.VarChar)
{
Value = (object)Tmodel.Rate ?? DBNull.Value
};
Tmodel.Sqlprms[11] = new SqlParameter("@EstimatedPrice", SqlDbType.Int)
{
Value = (object)Tmodel.EstimatedPrice ?? DBNull.Value
};
}
else if (Tmodel.Mode.Equals("Copy"))
{
Tmodel.SPName = "M_Hinban_Insert";
Tmodel.Sqlprms = new SqlParameter[12];
Tmodel.Sqlprms[0] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = Tmodel.CastingCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
Tmodel.Sqlprms[2] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = Tmodel.HinbanCD
};
Tmodel.Sqlprms[3] = new SqlParameter("@HinbanName", SqlDbType.VarChar)
{
Value = Tmodel.HinbanName
};
Tmodel.Sqlprms[4] = new SqlParameter("@Color", SqlDbType.TinyInt)
{
Value = (object)Tmodel.Color ?? DBNull.Value
};
Tmodel.Sqlprms[5] = new SqlParameter("@Production", SqlDbType.Int)
{
Value = (object)Tmodel.Production ?? DBNull.Value
};
Tmodel.Sqlprms[6] = new SqlParameter("@freeitem1", SqlDbType.VarChar)
{
Value = Tmodel.FreeItem1
};
Tmodel.Sqlprms[7] = new SqlParameter("@freeitem2", SqlDbType.Int)
{
Value = (object)Tmodel.FreeItem2 ?? DBNull.Value
};
Tmodel.Sqlprms[8] = new SqlParameter("@saleprice", SqlDbType.Int)
{
Value = (object)Tmodel.SalePrice ?? DBNull.Value
};
//add by ssa 20220917
Tmodel.Sqlprms[9] = new SqlParameter("@CategoryCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.CategoryCD ?? DBNull.Value
};
Tmodel.Sqlprms[10] = new SqlParameter("@Rate", SqlDbType.VarChar)
{
Value = (object)Tmodel.Rate ?? DBNull.Value
};
Tmodel.Sqlprms[11] = new SqlParameter("@EstimatedPrice", SqlDbType.Int)
{
Value = (object)Tmodel.EstimatedPrice ?? DBNull.Value
};
}
else if (Tmodel.Mode.Equals("Delete"))
{
Tmodel.SPName = "M_Hinban_Delete";
Tmodel.Sqlprms = new SqlParameter[2];
Tmodel.Sqlprms[0] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = Tmodel.HinbanCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
}
return(bdl.SelectJson(Tmodel.SPName, Tmodel.Sqlprms));
}
public string M_HinBan_Search_Search(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[15];
Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
{
Value = Tmodel.ProjectName
};
Tmodel.Sqlprms[2] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Tmodel.Year ?? DBNull.Value
};
Tmodel.Sqlprms[3] = new SqlParameter("@Season", SqlDbType.VarChar)
{
Value = Tmodel.Season
};
Tmodel.Sqlprms[4] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = Tmodel.BrandCD
};
Tmodel.Sqlprms[5] = new SqlParameter("@BrandName", SqlDbType.VarChar)
{
Value = Tmodel.BrandName
};
Tmodel.Sqlprms[6] = new SqlParameter("@PeriodStart", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodStart ?? DBNull.Value
};
Tmodel.Sqlprms[7] = new SqlParameter("@PeriodEnd", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodEnd ?? DBNull.Value
};
Tmodel.Sqlprms[8] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = Tmodel.HinbanCD
};
Tmodel.Sqlprms[9] = new SqlParameter("@HinbanName", SqlDbType.VarChar)
{
Value = Tmodel.HinbanName
};
Tmodel.Sqlprms[10] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = Tmodel.CastingCD
};
Tmodel.Sqlprms[11] = new SqlParameter("@CastingName", SqlDbType.VarChar)
{
Value = Tmodel.CastingName
};
Tmodel.Sqlprms[12] = new SqlParameter("@StartPrice", SqlDbType.Int)
{
Value = (object)Tmodel.StartPrice ?? DBNull.Value
};
Tmodel.Sqlprms[13] = new SqlParameter("@EndPrice", SqlDbType.Int)
{
Value = (object)Tmodel.EndPrice ?? DBNull.Value
};
Tmodel.Sqlprms[14] = new SqlParameter("@CompleteYM", SqlDbType.VarChar)
{
Value = Tmodel.CompleteYM
};
return(bdl.SelectJson("M_HinBan_Search_Search", Tmodel.Sqlprms));
}
public string M_Casting_ExistsCheck([FromBody] TourokuProjectModel Tmodel)
{
TourokuProject_BL Tpbl = new TourokuProject_BL();
return(Tpbl.M_Casting_ExistsCheck(Tmodel));
}
public string M_Project_CSV([FromBody] TourokuProjectModel Tmodel)
{
TourokuProject_BL Tpbl = new TourokuProject_BL();
return(Tpbl.M_Project_CSV(Tmodel));
}
public string Project_CUD(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
if (Tmodel.Mode.Equals("New"))
{
Tmodel.SPName = "M_Project_Insert";
Tmodel.Sqlprms = new SqlParameter[9];
Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
{
Value = Tmodel.ProjectName
};
Tmodel.Sqlprms[2] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Tmodel.Year ?? DBNull.Value
};
Tmodel.Sqlprms[3] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = Tmodel.BrandCD
};
Tmodel.Sqlprms[4] = new SqlParameter("@Season", SqlDbType.TinyInt)
{
Value = Tmodel.Season
};
Tmodel.Sqlprms[5] = new SqlParameter("@PeriodStart", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodStart ?? DBNull.Value
};
Tmodel.Sqlprms[6] = new SqlParameter("@PeriodEnd", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodEnd ?? DBNull.Value
};
Tmodel.Sqlprms[7] = new SqlParameter("@ProjectManager", SqlDbType.VarChar)
{
Value = Tmodel.ProjectManager
};
Tmodel.Sqlprms[8] = new SqlParameter("@AllocationCount", SqlDbType.Int)
{
Value = (object)Tmodel.AllocationCount ?? DBNull.Value
};
}
else if (Tmodel.Mode.Equals("Edit"))
{
Tmodel.SPName = "M_Project_Update";
Tmodel.Sqlprms = new SqlParameter[9];
Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
{
Value = Tmodel.ProjectName
};
Tmodel.Sqlprms[2] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Tmodel.Year ?? DBNull.Value
};
Tmodel.Sqlprms[3] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = Tmodel.BrandCD
};
Tmodel.Sqlprms[4] = new SqlParameter("@Season", SqlDbType.TinyInt)
{
Value = Tmodel.Season
};
Tmodel.Sqlprms[5] = new SqlParameter("@PeriodStart", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodStart ?? DBNull.Value
};
Tmodel.Sqlprms[6] = new SqlParameter("@PeriodEnd", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodEnd ?? DBNull.Value
};
Tmodel.Sqlprms[7] = new SqlParameter("@ProjectManager", SqlDbType.VarChar)
{
Value = Tmodel.ProjectManager
};
Tmodel.Sqlprms[8] = new SqlParameter("@AllocationCount", SqlDbType.Int)
{
Value = (object)Tmodel.AllocationCount ?? DBNull.Value
};
}
else if (Tmodel.Mode.Equals("Copy"))
{
Tmodel.SPName = "M_Project_Insert";
Tmodel.Sqlprms = new SqlParameter[9];
Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
{
Value = Tmodel.ProjectName
};
Tmodel.Sqlprms[2] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Tmodel.Year ?? DBNull.Value
};
Tmodel.Sqlprms[3] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = Tmodel.BrandCD
};
Tmodel.Sqlprms[4] = new SqlParameter("@Season", SqlDbType.TinyInt)
{
Value = Tmodel.Season
};
Tmodel.Sqlprms[5] = new SqlParameter("@PeriodStart", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodStart ?? DBNull.Value
};
Tmodel.Sqlprms[6] = new SqlParameter("@PeriodEnd", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodEnd ?? DBNull.Value
};
Tmodel.Sqlprms[7] = new SqlParameter("@ProjectManager", SqlDbType.VarChar)
{
Value = Tmodel.ProjectManager
};
Tmodel.Sqlprms[8] = new SqlParameter("@AllocationCount", SqlDbType.Int)
{
Value = (object)Tmodel.AllocationCount ?? DBNull.Value
};
}
else if (Tmodel.Mode.Equals("Delete"))
{
Tmodel.SPName = "M_Project_Delete";
Tmodel.Sqlprms = new SqlParameter[1];
Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
}
return(bdl.SelectJson(Tmodel.SPName, Tmodel.Sqlprms));
}
public string M_Project_Select_List(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
if (string.IsNullOrEmpty(Tmodel.status))
{
Tmodel.Sqlprms = new SqlParameter[10];
Tmodel.Sqlprms[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = Tmodel.BrandCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@BrandName", SqlDbType.VarChar)
{
Value = Tmodel.BrandName
};
Tmodel.Sqlprms[2] = new SqlParameter("@Season", SqlDbType.VarChar)
{
Value = Tmodel.Season
};
Tmodel.Sqlprms[3] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Tmodel.Year ?? DBNull.Value
};
Tmodel.Sqlprms[4] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.ProjectCD ?? DBNull.Value
};
Tmodel.Sqlprms[5] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
{
Value = Tmodel.ProjectName
};
Tmodel.Sqlprms[6] = new SqlParameter("@PeriodStart", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodStart ?? DBNull.Value
};
Tmodel.Sqlprms[7] = new SqlParameter("@PeriodEnd", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodEnd ?? DBNull.Value
};
Tmodel.Sqlprms[8] = new SqlParameter("@ProjectManager", SqlDbType.VarChar)
{
Value = Tmodel.ProjectManager
};
Tmodel.Sqlprms[9] = new SqlParameter("@ProjectManagerName", SqlDbType.VarChar)
{
Value = Tmodel.ProjectManagerName
};
return(bdl.SelectJson("M_Project_Select_List", Tmodel.Sqlprms));
}
else
{
if (Tmodel.status.Equals("3"))
{
Tmodel.Sqlprms = new SqlParameter[2];
Tmodel.Sqlprms[0] = new SqlParameter("@status", SqlDbType.Int)
{
Value = (object)Tmodel.status ?? DBNull.Value
};
Tmodel.Sqlprms[1] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = (object)Tmodel.LoginID ?? DBNull.Value
};
return(bdl.SelectJson("Data_Show_List", Tmodel.Sqlprms));
}
Tmodel.Sqlprms = new SqlParameter[11];
Tmodel.Sqlprms[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = Tmodel.BrandCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@BrandName", SqlDbType.VarChar)
{
Value = Tmodel.BrandName
};
Tmodel.Sqlprms[2] = new SqlParameter("@Season", SqlDbType.VarChar)
{
Value = Tmodel.Season
};
Tmodel.Sqlprms[3] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Tmodel.Year ?? DBNull.Value
};
Tmodel.Sqlprms[4] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.ProjectCD ?? DBNull.Value
};
Tmodel.Sqlprms[5] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
{
Value = Tmodel.ProjectName
};
Tmodel.Sqlprms[6] = new SqlParameter("@PeriodStart", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodStart ?? DBNull.Value
};
Tmodel.Sqlprms[7] = new SqlParameter("@PeriodEnd", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodEnd ?? DBNull.Value
};
Tmodel.Sqlprms[8] = new SqlParameter("@ProjectManager", SqlDbType.VarChar)
{
Value = Tmodel.ProjectManager
};
Tmodel.Sqlprms[9] = new SqlParameter("@ProjectManagerName", SqlDbType.VarChar)
{
Value = Tmodel.ProjectManagerName
};
Tmodel.Sqlprms[10] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = (object)Tmodel.LoginID ?? DBNull.Value
};
}
return(bdl.SelectJson("M_Project_History_Select", Tmodel.Sqlprms));
}
public string M_HinBan_Search_List(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
if (string.IsNullOrEmpty(Tmodel.status))
{
Tmodel.Sqlprms = new SqlParameter[19];
Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
{
Value = Tmodel.ProjectName
};
Tmodel.Sqlprms[2] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Tmodel.Year ?? DBNull.Value
};
Tmodel.Sqlprms[3] = new SqlParameter("@Season", SqlDbType.VarChar)
{
Value = (object)Tmodel.Season ?? DBNull.Value
};
Tmodel.Sqlprms[4] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = Tmodel.BrandCD
};
Tmodel.Sqlprms[5] = new SqlParameter("@BrandName", SqlDbType.VarChar)
{
Value = Tmodel.BrandName
};
Tmodel.Sqlprms[6] = new SqlParameter("@PeriodStart", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodStart ?? DBNull.Value
};
Tmodel.Sqlprms[7] = new SqlParameter("@PeriodEnd", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodEnd ?? DBNull.Value
};
Tmodel.Sqlprms[8] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = Tmodel.HinbanCD
};
Tmodel.Sqlprms[9] = new SqlParameter("@HinbanName", SqlDbType.VarChar)
{
Value = Tmodel.HinbanName
};
Tmodel.Sqlprms[10] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = Tmodel.CastingCD
};
Tmodel.Sqlprms[11] = new SqlParameter("@CastingName", SqlDbType.VarChar)
{
Value = Tmodel.CastingName
};
Tmodel.Sqlprms[12] = new SqlParameter("@StartPrice", SqlDbType.Int)
{
Value = (object)Tmodel.StartPrice ?? DBNull.Value
};
Tmodel.Sqlprms[13] = new SqlParameter("@EndPrice", SqlDbType.Int)
{
Value = (object)Tmodel.EndPrice ?? DBNull.Value
};
Tmodel.Sqlprms[14] = new SqlParameter("@CompleteYM", SqlDbType.VarChar)
{
Value = Tmodel.CompleteYM
};
Tmodel.Sqlprms[15] = new SqlParameter("@productionstart", SqlDbType.Int)
{
Value = (object)Tmodel.TotalProductionS ?? DBNull.Value
};
Tmodel.Sqlprms[16] = new SqlParameter("@productionend", SqlDbType.Int)
{
Value = (object)Tmodel.TotalProductionE ?? DBNull.Value
};
Tmodel.Sqlprms[17] = new SqlParameter("@productsalestart", SqlDbType.Int)
{
Value = (object)Tmodel.TotalAmountS ?? DBNull.Value
};
Tmodel.Sqlprms[18] = new SqlParameter("@productsaleend", SqlDbType.Int)
{
Value = (object)Tmodel.TotalAmountE ?? DBNull.Value
};
return(bdl.SelectJson("M_HinBan_Search_List", Tmodel.Sqlprms));
}
else
{
if (Tmodel.status.Equals("4"))
{
Tmodel.Sqlprms = new SqlParameter[2];
Tmodel.Sqlprms[0] = new SqlParameter("@status", SqlDbType.Int)
{
Value = (object)Tmodel.status ?? DBNull.Value
};
Tmodel.Sqlprms[1] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = (object)Tmodel.LoginID ?? DBNull.Value
};
return(bdl.SelectJson("Data_Show_List", Tmodel.Sqlprms));
}
Tmodel.Sqlprms = new SqlParameter[20];
Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Tmodel.ProjectCD
};
Tmodel.Sqlprms[1] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
{
Value = Tmodel.ProjectName
};
Tmodel.Sqlprms[2] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Tmodel.Year ?? DBNull.Value
};
Tmodel.Sqlprms[3] = new SqlParameter("@Season", SqlDbType.VarChar)
{
Value = (object)Tmodel.Season ?? DBNull.Value
};
Tmodel.Sqlprms[4] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = Tmodel.BrandCD
};
Tmodel.Sqlprms[5] = new SqlParameter("@BrandName", SqlDbType.VarChar)
{
Value = Tmodel.BrandName
};
Tmodel.Sqlprms[6] = new SqlParameter("@PeriodStart", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodStart ?? DBNull.Value
};
Tmodel.Sqlprms[7] = new SqlParameter("@PeriodEnd", SqlDbType.Int)
{
Value = (object)Tmodel.PeriodEnd ?? DBNull.Value
};
Tmodel.Sqlprms[8] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = Tmodel.HinbanCD
};
Tmodel.Sqlprms[9] = new SqlParameter("@HinbanName", SqlDbType.VarChar)
{
Value = Tmodel.HinbanName
};
Tmodel.Sqlprms[10] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
{
Value = Tmodel.CastingCD
};
Tmodel.Sqlprms[11] = new SqlParameter("@CastingName", SqlDbType.VarChar)
{
Value = Tmodel.CastingName
};
Tmodel.Sqlprms[12] = new SqlParameter("@StartPrice", SqlDbType.Int)
{
Value = (object)Tmodel.StartPrice ?? DBNull.Value
};
Tmodel.Sqlprms[13] = new SqlParameter("@EndPrice", SqlDbType.Int)
{
Value = (object)Tmodel.EndPrice ?? DBNull.Value
};
Tmodel.Sqlprms[14] = new SqlParameter("@CompleteYM", SqlDbType.VarChar)
{
Value = Tmodel.CompleteYM
};
Tmodel.Sqlprms[15] = new SqlParameter("@productionstart", SqlDbType.Int)
{
Value = (object)Tmodel.TotalProductionS ?? DBNull.Value
};
Tmodel.Sqlprms[16] = new SqlParameter("@productionend", SqlDbType.Int)
{
Value = (object)Tmodel.TotalProductionE ?? DBNull.Value
};
Tmodel.Sqlprms[17] = new SqlParameter("@productsalestart", SqlDbType.Int)
{
Value = (object)Tmodel.TotalAmountS ?? DBNull.Value
};
Tmodel.Sqlprms[18] = new SqlParameter("@productsaleend", SqlDbType.Int)
{
Value = (object)Tmodel.TotalAmountE ?? DBNull.Value
};
Tmodel.Sqlprms[19] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = (object)Tmodel.LoginID ?? DBNull.Value
};
}
return(bdl.SelectJson("M_HinBan_History_Select", Tmodel.Sqlprms));
}
public string D_Cost_ExistsDeleteCheck([FromBody] TourokuProjectModel Tmodel)
{
TourokuProject_BL Tpbl = new TourokuProject_BL();
return(Tpbl.D_Cost_ExistsDeleteCheck(Tmodel));
}
public string M_Hinban_ProjectExistCheck([FromBody] TourokuProjectModel Tmodel)
{
TourokuProject_BL Tpbl = new TourokuProject_BL();
return(Tpbl.M_Hinban_ProjectExistCheck(Tmodel));
}
