public ActionResult Query(PageInfoModel pgingModel, ACHDViewModel model)
{
string result = string.Empty;
IndexViewModel outputModel = new IndexViewModel();
try
{
List <ACHD> queryResult = new JavaScriptSerializer().Deserialize <List <ACHD> >(this.QueryACHD(pgingModel, model));
//outputModel
if (queryResult != null && queryResult.Count() > 0)
{
//this.QueryACBD
}
}
catch (Exception ex)
{
throw;
}
return(Json(new { data = result }, JsonRequestBehavior.AllowGet));
//return View("Index", outputModel);
}
//[ValidateAntiForgeryToken]
//public ActionResult Edit(EditViewModel model)
//{
// EditViewModel outputModel = new VoucherViewModel();
// //this.db = new GWEB_TESTEntities();
// //ACHD achd = new ACHD();
// //achd.ACID = model.ACID;
// //achd.CKAM = Convert.ToDecimal(model.CKAM);
// //achd.CKID = model.CKID;
// //achd.CKYM = model.CKYM;
// //achd.DATE = model.DATE;
// //achd.JSKD = model.JSKD;
// //achd.NIKD = model.NIKD;
// //achd.NOTE = model.NOTE;
// //achd.PSID = model.PSID;
// //achd.REM1 = model.REM1;
// //achd.REM2 = model.REM2;
// //achd.SBID = model.SBID;
// //achd.SQID = model.SQID;
// //achd.TPID = model.TPID;
// //achd.TPNM = model.TPNM;
// //achd.YYMM = model.YYMM;
// //db.ACHD.Add(achd);
// //db.SaveChanges();
// return View(outputModel);
//}
//Query ACHD >> using ACHD MODEL//
//[ValidateAntiForgeryToken]
//[NonAction]
public string QueryACHD(PageInfoModel pgingModel, ACHDViewModel model)
{
string result = string.Empty;
this.db = new GWEB_TESTEntities();
try
{
//PAGING//
//var queryResult = (from p in db.ACHD select p).OrderBy(x=>x.ACID).Skip(pgingModel.PageNum * pgingModel.PageSize).Take(pgingModel.PageSize);
//NO PAGING//
var queryResult = (from p in db.ACHD select p);
if (model.ACID != "" & model.ACID != null)
{
queryResult = queryResult.Where(x => x.ACID == model.ACID);
}
if (model.CKAM != "" & model.CKAM != null)
{
//decimal ckam = 0m;
//if (Decimal.TryParse(model.CKAM, out ckam))
//{
// queryResult = queryResult.Where(x => x.CKAM == ckam);
queryResult = queryResult.Where(x => x.CKAM == Convert.ToDecimal(model.CKAM));
//}
//else
//{
// //TODO:
// //NOTHING//
//}
}
if (model.CKID != "" & model.CKID != null)
{
queryResult = queryResult.Where(x => x.CKID == model.CKID);
}
if (model.CKYM != "" & model.CKYM != null)
{
queryResult = queryResult.Where(x => x.CKYM == model.CKYM);
}
if (model.DATE != "" & model.DATE != null)
{
DateTime date = CcDevConst.DATEINIVALUE;
if (DateTime.TryParse(model.DATE, out date))
{
queryResult = queryResult.Where(x => x.DATE == date);
}
else
{
//TODO:
//NOTHING//
}
}
if (model.JSKD != "" & model.JSKD != null)
{
queryResult = queryResult.Where(x => x.JSKD == model.JSKD);
}
if (model.NIKD != "" & model.NIKD != null)
{
queryResult = queryResult.Where(x => x.NIKD == model.NIKD);
}
if (model.NOTE != "" & model.NOTE != null)
{
queryResult = queryResult.Where(x => x.NOTE == model.NOTE);
}
if (model.PSID != "" & model.PSID != null)
{
queryResult = queryResult.Where(x => x.PSID == model.PSID);
}
if (model.REM1 != "" & model.REM1 != null)
{
queryResult = queryResult.Where(x => x.REM1 == model.REM1);
}
if (model.REM2 != "" & model.REM2 != null)
{
queryResult = queryResult.Where(x => x.REM2 == model.REM2);
}
if (model.SBID != "" & model.SBID != null)
{
queryResult = queryResult.Where(x => x.SBID == model.SBID);
}
if (model.SQID != "" & model.SQID != null)
{
queryResult = queryResult.Where(x => x.SQID == model.SQID);
}
if (model.TPID != "" & model.TPID != null)
{
queryResult = queryResult.Where(x => x.TPID == model.TPID);
}
if (model.TPNM != "" & model.TPNM != null)
{
queryResult = queryResult.Where(x => x.TPNM == model.TPNM);
}
if (model.YYMM != "" & model.YYMM != null)
{
queryResult = queryResult.Where(x => x.YYMM == model.YYMM);
}
result = new JavaScriptSerializer().Serialize(queryResult.OrderBy(x => x.TPID).OrderBy(x => x.SQID).ToList());
}
catch (Exception)
{
//TODO:
throw;
}
finally { db.Dispose(); }
return(result);
}
