public StcGoods GetProdAddView(ProdListModels getModel)
{
string errorStr = "";
StcGoods model = new StcGoods();
if (getModel.act_type != null && getModel.act_type == "updt")
{
string ViewQuery = " SELECT SEQNO, " + string.Join(",", selectColoum_ProdAdd) + " FROM stc_goods WHERE SEQNO = " + getModel.act_key;
DataTable listDt = getQueryResult(ViewQuery, out errorStr);
if (listDt != null && listDt.Rows.Count != 0)
{
model.SEQNO = int.Parse(listDt.Rows[0]["SEQNO"].ToString().Trim());
model.EST_CODE = listDt.Rows[0]["EST_CODE"].ToString().Trim();
model.ESE_CODE = listDt.Rows[0]["EST_CODE"].ToString().Trim();
model.CATEGORY1 = int.Parse(listDt.Rows[0]["CATEGORY1"].ToString().Trim());
model.CATEGORY2 = int.Parse(listDt.Rows[0]["CATEGORY2"].ToString().Trim());
model.CATEGORY3 = int.Parse(listDt.Rows[0]["CATEGORY3"].ToString().Trim());
model.CATEGORY4 = int.Parse(listDt.Rows[0]["CATEGORY4"].ToString().Trim());
model.BARCODE = listDt.Rows[0]["BARCODE"].ToString().Trim();
model.SKU = listDt.Rows[0]["SKU"].ToString().Trim();
model.PRODUCT_NAME = listDt.Rows[0]["PRODUCT_NAME"].ToString().Trim();
model.PRODUCT_NAME_KR = listDt.Rows[0]["PRODUCT_NAME_KR"].ToString().Trim();
model.PRODUCT_NAME_CN = listDt.Rows[0]["PRODUCT_NAME_CN"].ToString().Trim();
model.PRODUCT_NAME_EN = listDt.Rows[0]["PRODUCT_NAME_EN"].ToString().Trim();
model.BRAND = listDt.Rows[0]["BRAND"].ToString().Trim();
model.PRICE = double.Parse(listDt.Rows[0]["PRICE"].ToString().Trim());
model.UNIT_WEIGHT = double.Parse(listDt.Rows[0]["UNIT_WEIGHT"].ToString().Trim());
model.WEIGHT_UNIT = listDt.Rows[0]["WEIGHT_UNIT"].ToString().Trim();
model.STANDARD = listDt.Rows[0]["STANDARD"].ToString().Trim();
model.EXPIRATION = int.Parse(listDt.Rows[0]["EXPIRATION"].ToString().Trim());
model.EXPIRATION_DT = listDt.Rows[0]["EXPIRATION_DT"].ToString().Trim();
model.ORIGIN = listDt.Rows[0]["ORIGIN"].ToString().Trim();
model.INGREDIENT = listDt.Rows[0]["INGREDIENT"].ToString().Trim();
model.SPEC = listDt.Rows[0]["SPEC"].ToString().Trim();
model.SALE_SITE_URL = listDt.Rows[0]["SALE_SITE_URL"].ToString().Trim();
model.PRODUCT_IMAGE = listDt.Rows[0]["PRODUCT_IMAGE"].ToString().Trim();
model.RACKNO = listDt.Rows[0]["RACKNO"].ToString().Trim();
model.COMMENT = listDt.Rows[0]["COMMENT"].ToString().Trim();
model.REG_DT = listDt.Rows[0]["REG_DT"].ToString().Trim();
model.UPDT_DT = listDt.Rows[0]["UPDT_DT"].ToString().Trim();
}
}
return(model);
}
public ActionResult StocProdView(string barcode)
{
//권한 체크===================================================
if (!chk.chkPermission("StocList", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
StcGoods model = new StcGoods();
model.BARCODE = barcode;
model.ESE_CODE = (string)Session["ESE_CODE"];
//Prod 컨트롤러 GetProdAddView 참조 대신 검색 조건이 ESE_CDOE + barcode 두게 걸어야 함
model = act.getStocProdView(model);
return(View(model));
}
public ProdListModels GetProdListList(ProdListModels model)
{
HttpContext context = HttpContext.Current;
string eseCode = context.Session["ESE_CODE"].ToString();
string estCode = context.Session["EST_CODE"].ToString();
string errorStr = "";
string listQuery = " SELECT SEQNO , " + string.Join(",", selectColoum_ProdAdd);
string cntQuery = " SELECT count(*) as cnt ";
string baseQuery = " FROM stc_goods WHERE 1=1 ";
baseQuery += " AND ESE_CODE = '" + eseCode + "' ";
baseQuery += " AND EST_CODE = '" + estCode + "' ";
if (model.cate1 != 0) //카테고리1
{
baseQuery += " AND CATEGORY1 = " + model.cate1;
}
if (model.cate2 != 0) //카테고리2
{
baseQuery += " AND CATEGORY2 = " + model.cate2;
}
if (model.cate3 != 0) //카테고리3
{
baseQuery += " AND CATEGORY3 = " + model.cate3;
}
if (model.cate4 != 0) //카테고리4
{
baseQuery += " AND CATEGORY4 = " + model.cate4;
}
if (!String.IsNullOrEmpty(model.schSdt)) //등록일자 (시작일)
{
baseQuery += " AND REG_DT >= '" + model.schSdt.Trim() + "'";
}
if (!String.IsNullOrEmpty(model.schEdt)) //등록일자 (종료일)
{
baseQuery += " AND UPDT_DT <= '" + model.schEdt.Trim() + " 23:59:59'";
}
if (!String.IsNullOrEmpty(model.schTxt) && !String.IsNullOrEmpty(model.schTxt)) //브랜드
{
baseQuery += " AND BRAND like '%" + model.schTxt.Trim() + "%' ";
}
if (!String.IsNullOrEmpty(model.schTypeTxt) && !String.IsNullOrEmpty(model.schTxt2)) //검색조건 검색어
{
baseQuery += " AND " + model.schTypeTxt.Trim() + " like '%" + model.schTxt2.Trim() + "%' ";
}
string endQuery = " ORDER BY " + model.sortKey.ToString().Trim() + " DESC limit " + ((model.Paging.page - 1) * model.Paging.pageNum) + " , " + model.Paging.pageNum; //정렬
cntQuery += baseQuery; //토탈 카운트 쿼리
listQuery += baseQuery + endQuery; //리스트 쿼리
int totCnt = getQueryCnt(cntQuery, out errorStr); //전체 리스트 갯수 구하기
model.Paging.totCnt = totCnt; //전체 갯수 세팅
model.Paging.startCnt = totCnt - (model.Paging.pageNum * (model.Paging.page - 1)); //리스트 첫번째 시작 번호
model.Paging.pageTotNum = (totCnt / model.Paging.pageNum) + 1; //총 페이징 갯수 구하기
if ((totCnt % model.Paging.pageNum) == 0)
{
model.Paging.pageTotNum -= 1; //총 페이징 갯수가 0 일경우 + 1
}
DataTable listDt = getQueryResult(listQuery, out errorStr);
int tmpCate = 0;
if (listDt != null && listDt.Rows.Count != 0)
{
for (int i = 0; i < listDt.Rows.Count; i++)
{
StcGoods temp = new StcGoods();
temp.SEQNO = int.Parse(listDt.Rows[i]["SEQNO"].ToString().Trim());
temp.EST_CODE = listDt.Rows[i]["EST_CODE"].ToString().Trim();
temp.ESE_CODE = listDt.Rows[i]["EST_CODE"].ToString().Trim();
temp.CATEGORY1 = int.Parse(listDt.Rows[i]["CATEGORY1"].ToString().Trim());
temp.CATEGORY2 = int.Parse(listDt.Rows[i]["CATEGORY2"].ToString().Trim());
temp.CATEGORY3 = int.Parse(listDt.Rows[i]["CATEGORY3"].ToString().Trim());
temp.CATEGORY4 = int.Parse(listDt.Rows[i]["CATEGORY4"].ToString().Trim());
temp.BARCODE = listDt.Rows[i]["BARCODE"].ToString().Trim();
temp.SKU = listDt.Rows[i]["SKU"].ToString().Trim();
temp.PRODUCT_NAME = listDt.Rows[i]["PRODUCT_NAME"].ToString().Trim();
temp.PRODUCT_NAME_KR = listDt.Rows[i]["PRODUCT_NAME_KR"].ToString().Trim();
temp.PRODUCT_NAME_CN = listDt.Rows[i]["PRODUCT_NAME_CN"].ToString().Trim();
temp.PRODUCT_NAME_EN = listDt.Rows[i]["PRODUCT_NAME_EN"].ToString().Trim();
temp.BRAND = listDt.Rows[i]["BRAND"].ToString().Trim();
temp.PRICE = double.Parse(listDt.Rows[i]["PRICE"].ToString().Trim());
temp.WEIGHT_UNIT = listDt.Rows[i]["WEIGHT_UNIT"].ToString().Trim();
temp.STANDARD = listDt.Rows[i]["STANDARD"].ToString().Trim();
temp.EXPIRATION = int.Parse(listDt.Rows[i]["EXPIRATION"].ToString().Trim());
temp.EXPIRATION_DT = listDt.Rows[i]["EXPIRATION_DT"].ToString().Trim();
temp.ORIGIN = listDt.Rows[i]["ORIGIN"].ToString().Trim();
temp.INGREDIENT = listDt.Rows[i]["INGREDIENT"].ToString().Trim();
temp.SPEC = listDt.Rows[i]["SPEC"].ToString().Trim();
temp.SALE_SITE_URL = listDt.Rows[i]["SALE_SITE_URL"].ToString().Trim();
temp.PRODUCT_IMAGE = listDt.Rows[i]["PRODUCT_IMAGE"].ToString().Trim();
temp.RACKNO = listDt.Rows[i]["RACKNO"].ToString().Trim();
temp.COMMENT = listDt.Rows[i]["COMMENT"].ToString().Trim();
temp.REG_DT = listDt.Rows[i]["REG_DT"].ToString().Trim();
temp.UPDT_DT = listDt.Rows[i]["UPDT_DT"].ToString().Trim();
tmpCate = 0;
if (temp.CATEGORY1 != 0)
{
tmpCate = temp.CATEGORY1;
}
if (temp.CATEGORY2 != 0)
{
tmpCate = temp.CATEGORY2;
}
if (temp.CATEGORY3 != 0)
{
tmpCate = temp.CATEGORY3;
}
if (temp.CATEGORY4 != 0)
{
tmpCate = temp.CATEGORY4;
}
if (tmpCate != 0)
{
temp.CATEGORY1_txt = GetCategoryName(tmpCate);
}
model.Items.Add(temp);
}
}
return(model);
}
