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)); }