public JsonResult Create(CountryType obj)
{
try
{
if(IsCreateOk(obj.ECountry))
return Json(new { errorMsg = "编号已经存在" });
NSession.SaveOrUpdate(obj);
NSession.Flush();
}
catch (Exception ee)
{
return Json(new { IsSuccess = false, ErrorMsg = "出错了" });
}
return Json(new { IsSuccess = true });
}
public JsonResult GetUnCountryByAreaCode(string sort, string order, int id, string s)
{
string orderby = " order by Id desc ";
if (!string.IsNullOrEmpty(sort) && !string.IsNullOrEmpty(order))
{
orderby = "order by " + sort + " " + order;
}
IList<object[]> list = NSession.CreateSQLQuery("select Id,CCountry,ECountry,CountryCode,(select AreaName from LogisticsArea where ID=(select top 1 AreaCode from LogisticsAreaCountry la where c.Id= la.CountryCode and la.AreaCode in (select ID from LogisticsArea where LId =(select LId from LogisticsArea where LogisticsArea.Id=:cid)))) as AreaNane from Country c where c.Id not in (select CountryCode from LogisticsAreaCountry where AreaCode=:cid ) and (CCountry like'%" + s + "%' or ECountry like '%" + s + "%')" + orderby)
.SetInt32("cid", id)
.List<object[]>();
List<CountryType> l = new List<CountryType>();
foreach (object[] foo in list)
{
CountryType c = new CountryType();
c.Id = Utilities.ToInt(foo[0]);
c.CCountry = foo[1].ToStr();
c.ECountry = foo[2].ToStr();
c.CountryCode = foo[3].ToStr();
c.AreaName = foo[4].ToStr();
l.Add(c);
}
return Json(new { total = l.Count, rows = l });
}
public ActionResult Edit(CountryType obj)
{
try
{
if (IsOk(obj.Id,obj.ECountry))
return Json(new { errorMsg = "编号已经存在" });
NSession.Update(obj);
NSession.Flush();
}
catch (Exception ee)
{
return Json(new { IsSuccess = false, ErrorMsg = "出错了" });
}
return Json(new { IsSuccess = true });
}