/// <summary>
/// 사용자 정보를 가져옵니다.
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public static DataTable GetProductList(SaleType saleType, SearchType searchType, string keyword, string searchCount)
{
DataTable dt = new DataTable();
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
string procedureName = "SP_GET_PRODUCT_LIST";
ParameterEngine param = ParameterEngine.New(da);
param.Add("@SEARCH_TYPE", searchType.ToString().ToUpper());
param.Add("@SALE_TYPE", saleType.ToString().ToUpper());
param.Add("@KEY_WORD", keyword);
param.Add("@SEARCH_COUNT", searchCount);
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
dt = da.GetData(command);
}
catch (Exception ex)
{
WriteTextLog("GetUserList", ex.Message.ToString());
}
finally
{
DisConnect(ref da);
}
return(dt);
}
/// <summary>
///
/// </summary>
/// <param name="createKeyCodeCount">생성할 건수</param>
/// <param name="saleType">판매타입</param>
public static int CreateProductINfo(int createKeyCodeCount, SaleType saleType)
{
int result = createKeyCodeCount;
DataAccess da = new SQLServerDB();
if (!da.IsConnected)
{
Connect(ref da);
}
try
{
ParameterEngine param = ParameterEngine.New(da);
param.Add("@SALE_TYPE", saleType.ToString().ToUpper());
param.Add("@KEYCODE_COUNT", createKeyCodeCount);
string procedureName = "SP_KEY_CODE_CREATE";
DbCommand command = da.GenerateCommand(procedureName, CommandType.StoredProcedure, param);
da.ExecuteNonQuery(command);
}
catch (Exception ex)
{
WriteTextLog("CreateProductINfo", ex.Message.ToString());
result = 0;
}
finally
{
DisConnect(ref da);
}
return(result);
}
public ActionResult Update(int id, SaleType type)
{
var sale = _saleService.GetByID(id);
sale.Status = type;
_activityService.Create("status was updated " + type.ToString().AddSpacesToSentence(), AreaType.Sale, User.Identity.Name, sale.ID);
_saleService.Save(sale);
TempData.Add("StatusMessage", "Sales converted");
return(RedirectToAction("Index"));
}
public ActionResult Update(int id, SaleType type)
{
var sale = _saleService.GetByID(id);
sale.Status = type;
_activityService.Create("status was updated " + type.ToString().AddSpacesToSentence(), AreaType.Sale, User.Identity.Name, sale.ID);
_saleService.Save(sale);
TempData.Add("StatusMessage", "Sales converted");
return RedirectToAction("Index");
}