public CategoryEntryModel CategoryModel_Select(CategoryEntryModel categoryModel)
{
BaseDL bdl = new BaseDL();
categoryModel.Sqlprms = new SqlParameter[2];
categoryModel.Sqlprms[0] = new SqlParameter("@ParentCatCD", SqlDbType.VarChar)
{
Value = categoryModel.ParentCategoryCD
};
categoryModel.Sqlprms[1] = new SqlParameter("@CategoryCD", SqlDbType.VarChar)
{
Value = categoryModel.CategoryCD
};
DataTable dt = bdl.SelectDatatable("Category_Select", categoryModel.Sqlprms);
DataRow dr = dt.Rows[0];
categoryModel.CategoryName = dr["CategoryName"].ToString();
categoryModel.RakutenDirectoryID = dr["RakutenDirectoryID"].ToString();
categoryModel.YahooCategoryID = dr["YahooCategoryID"].ToString();
categoryModel.PonpareCategoryID = dr["PonpareCategoryID"].ToString();
categoryModel.WowmaCategoryID = dr["WowmaCategoryID"].ToString();
categoryModel.RakutenCategorySetNo = dr["RakutenCategorySetNo"].ToString();
categoryModel.R_RacketCategoryID = dr["R_RacketCategoryID"].ToString();
categoryModel.R_SportsPlazaCategoryID = dr["R_SportsPlazaCategoryID"].ToString();
categoryModel.R_LuckpieceCategoryID = dr["R_LuckpieceCategoryID"].ToString();
categoryModel.R_HonpoCategoryID = dr["R_HonpoCategoryID"].ToString();
return(categoryModel);
}
public UserModel UserModel_Select(UserModel Umodel)
{
BaseDL bdl = new BaseDL();
Umodel.Sqlprms = new SqlParameter[4];
Umodel.Sqlprms[0] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = Umodel.UserID
};
Umodel.Sqlprms[1] = new SqlParameter("@Password", SqlDbType.VarChar)
{
Value = Umodel.Password
};
Umodel.Sqlprms[2] = new SqlParameter("@UserName", SqlDbType.VarChar)
{
Value = Umodel.UserName
};
Umodel.Sqlprms[3] = new SqlParameter("@Status", SqlDbType.VarChar)
{
Value = Umodel.Status
};
DataTable dt = bdl.SelectDatatable("User_Select", Umodel.Sqlprms);
foreach (DataRow dr in dt.Rows)
{
Umodel.UserID = dr["UserID"].ToString();
Umodel.UserName = dr["UserName"].ToString();
Umodel.Password = dr["Password"].ToString();
Umodel.Status = dr["Status"].ToString();
}
return(Umodel);
}
public OptionModel OptionModel_Select(OptionModel optionModel)
{
BaseDL bdl = new BaseDL();
optionModel.Sqlprms = new SqlParameter[1];
optionModel.Sqlprms[0] = new SqlParameter("@AutoID", SqlDbType.VarChar)
{
Value = optionModel.AutoID
};
DataTable dt = bdl.SelectDatatable("Option_Select", optionModel.Sqlprms);
foreach (DataRow dr in dt.Rows)
{
optionModel.GroupName = dr["GroupName"].ToString();
optionModel.Option1 = dr["Option1"].ToString();
optionModel.Value1 = dr["Value1"].ToString();
optionModel.Option2 = dr["Option2"].ToString();
optionModel.Value2 = dr["Value2"].ToString();
optionModel.Option3 = dr["Option3"].ToString();
optionModel.Value3 = dr["Value3"].ToString();
optionModel.Option4 = dr["Option4"].ToString();
optionModel.Value4 = dr["Value4"].ToString();
optionModel.Option5 = dr["Option5"].ToString();
optionModel.Value5 = dr["Value5"].ToString();
}
return(optionModel);
}
public DataTable Category_Select(CategoryModel model)
{
BaseDL bdl = new BaseDL();
model.Sqlprms = new SqlParameter[2];
model.Sqlprms[0] = new SqlParameter("@ParentCatCD", model.ParentCategoryCD);
model.Sqlprms[1] = new SqlParameter("@CategoryCD", model.CategoryCD);
return(bdl.SelectDatatable("Category_Select", model.Sqlprms));
}
public ShopModel ShopModel_Select(ShopModel shopModel)
{
BaseDL bdl = new BaseDL();
shopModel.Sqlprms = new SqlParameter[4];
shopModel.Sqlprms[0] = new SqlParameter("@ShopID", SqlDbType.VarChar)
{
Value = shopModel.ShopID
};
shopModel.Sqlprms[1] = new SqlParameter("@ShopName", SqlDbType.VarChar)
{
Value = shopModel.ShopName
};
shopModel.Sqlprms[2] = new SqlParameter("@MAllID", SqlDbType.VarChar)
{
Value = shopModel.MallID
};
shopModel.Sqlprms[3] = new SqlParameter("@Status", SqlDbType.VarChar)
{
Value = shopModel.Status
};
DataTable dt = bdl.SelectDatatable("Shop_Select", shopModel.Sqlprms);
foreach (DataRow dr in dt.Rows)
{
shopModel.ShopID = dr["ShopID"].ToString();
shopModel.ShopIDPrefix = dr["ShopIDPrefix"].ToString();
shopModel.ShopSiteID = dr["ShopSiteID"].ToString();
shopModel.ShopName = dr["ShopName"].ToString();
shopModel.MallID = dr["MallID"].ToString();
shopModel.FtpHost = dr["FtpHost"].ToString();
shopModel.FtpUserName = dr["FtpUserName"].ToString();
shopModel.FtpPassword = dr["FtpPassword"].ToString();
shopModel.ItemURL = dr["ItemURL"].ToString();
shopModel.ImageURL = dr["ImageURL"].ToString();
shopModel.FreeShippingAmount = dr["FreeShippingAmount"] != null?Convert.ToInt32(dr["FreeShippingAmount"]).ToString() : dr["FreeShippingAmount"].ToString();
shopModel.Status = dr["Status"].ToString();
}
return(shopModel);
}
public Shop_ItemNamePriorityModel ShopPriorityModel_Select(Shop_ItemNamePriorityModel model)
{
BaseDL bdl = new BaseDL();
model.Sqlprms = new SqlParameter[1];
model.Sqlprms[0] = new SqlParameter("@ShopID", SqlDbType.VarChar)
{
Value = model.ShopID
};
DataTable dt = bdl.SelectDatatable("ShopPriority_Select", model.Sqlprms);
foreach (DataRow dr in dt.Rows)
{
model.ShopID = dr["ShopID"].ToString();
model.ShopName = dr["ShopName"].ToString();
model.PriorityValue = dr["PriorityValue"].ToString();
model.PriorityValueID = dr["PriorityValueID"].ToString();
model.MallID = dr["MallID"].ToString();
}
return(model);
}
public ShopTemplateModel ShopTemplateModel_Select(ShopTemplateModel shopTemplateModel)
{
BaseDL bdl = new BaseDL();
shopTemplateModel.Sqlprms = new SqlParameter[3];
shopTemplateModel.Sqlprms[0] = new SqlParameter("@TemplateID", SqlDbType.VarChar)
{
Value = shopTemplateModel.TemplateID
};
shopTemplateModel.Sqlprms[1] = new SqlParameter("@TemplateName", SqlDbType.VarChar)
{
Value = shopTemplateModel.TemplateName
};
shopTemplateModel.Sqlprms[2] = new SqlParameter("@Status", SqlDbType.VarChar)
{
Value = shopTemplateModel.Status
};
DataTable dt = bdl.SelectDatatable("ShopTemplate_Select", shopTemplateModel.Sqlprms);
foreach (DataRow dr in dt.Rows)
{
shopTemplateModel.TemplateName = dr["TemplateName"].ToString();
shopTemplateModel.R_racket = dr["R_racket_Template"].ToString();
shopTemplateModel.R_sportsplaza = dr["R_sportsplaza_Template"].ToString();
shopTemplateModel.R_luckpiece = dr["R_luckpiece_Template"].ToString();
shopTemplateModel.R_honpo = dr["R_honpo_Template"].ToString();
shopTemplateModel.Y_racket = dr["Y_racket_Template"].ToString();
shopTemplateModel.Y_sportsplaza = dr["Y_sportsplaza_Template"].ToString();
shopTemplateModel.Y_luckpiece = dr["Y_luckpiece_Template"].ToString();
shopTemplateModel.Y_honpo = dr["Y_honpo_Template"].ToString();
shopTemplateModel.Y_bb_plaza = dr["Y_bb_plaza_Template"].ToString();
shopTemplateModel.P_racket = dr["P_racket_Template"].ToString();
shopTemplateModel.A_rasta = dr["A_rasta_Template"].ToString();
shopTemplateModel.J_racket = dr["J_racket_Template"].ToString();
shopTemplateModel.W_wowma = dr["W_wowma_Template"].ToString();
shopTemplateModel.Status = dr["Status"].ToString();
}
return(shopTemplateModel);
}
public ExportFieldsModel ExportFieldModel_Select(ExportFieldsModel exportFieldsModel)
{
BaseDL bdl = new BaseDL();
exportFieldsModel.Sqlprms = new SqlParameter[5];
exportFieldsModel.Sqlprms[0] = new SqlParameter("@ExportName", exportFieldsModel.ExportName);
exportFieldsModel.Sqlprms[1] = new SqlParameter("@ExportValue", exportFieldsModel.ExportValue);
exportFieldsModel.Sqlprms[2] = new SqlParameter("@ExportType", exportFieldsModel.ExportType);
exportFieldsModel.Sqlprms[3] = new SqlParameter("@Status", exportFieldsModel.Status);
exportFieldsModel.Sqlprms[4] = new SqlParameter("@AutoID", exportFieldsModel.AutoID);
DataTable dt = bdl.SelectDatatable("Export_Select", exportFieldsModel.Sqlprms);
foreach (DataRow dr in dt.Rows)
{
exportFieldsModel.AutoID = dr["AutoID"].ToString();
exportFieldsModel.ExportName = dr["ExportName"].ToString();
exportFieldsModel.Status = dr["Status"].ToString();
exportFieldsModel.ExportType = dr["ExportType"].ToString();
exportFieldsModel.ExportValue = dr["ExportValue"].ToString();
exportFieldsModel.ExportValueID = dr["ExportValueID"].ToString();
}
return(exportFieldsModel);
}