public bool Create(KeyValuesViewModel data, out string errMsg)
{
KeyValuesDAO keyValuesDAO = new KeyValuesDAO();
errMsg = "";
try
{
KeyValues modelData = new KeyValues();
modelData.KeyValueName = data.KeyValueName;
modelData.Text = data.Text;
modelData.Value = data.Value;
modelData.Sort = data.Sort;
modelData.EnterPriseId = data.EnterPriseId;
keyValuesDAO.Insert(modelData);
keyValuesDAO.SaveChange();
}
catch (Exception ex)
{
errMsg = ex.Message;
return(false);
}
return(true);
}
public bool Update(KeyValuesViewModel data, out string errMsg)
{
KeyValuesDAO keyValuesDAO = new KeyValuesDAO();
errMsg = "";
try
{
var dbModel = keyValuesDAO.FindById(data.Id);
dbModel.KeyValueName = data.KeyValueName;
dbModel.Text = data.Text;
dbModel.Value = data.Value;
dbModel.Sort = data.Sort;
dbModel.EnterPriseId = data.EnterPriseId;
keyValuesDAO.Update(dbModel);
keyValuesDAO.SaveChange();
}
catch (Exception ex)
{
errMsg = ex.Message;
return(false);
}
return(true);
}
public List <KeyValuesViewModel> ReadData(KeyValuesViewModel query)
{
KeyValuesDAO keyValuesDAO = new KeyValuesDAO();
List <KeyValuesViewModel> result = new List <KeyValuesViewModel>();
try
{
var dbResult = keyValuesDAO.QueryAll(query);
if (dbResult.Any())
{
result = dbResult.Select(n => new KeyValuesViewModel
{
Id = n.Id,
KeyValueName = n.KeyValueName,
Text = n.Text,
Value = n.Value,
Sort = n.Sort,
EnterPriseId = n.EnterPriseId
}).ToList();
}
}
catch (Exception ex)
{
string errMsg = ex.Message;
}
return(result);
}
public ActionResult Edit(string keyValueName, string text)
{
HomeService service = new HomeService();
List <KeyValuesViewModel> data = new List <KeyValuesViewModel>();
KeyValuesViewModel query = new KeyValuesViewModel();
query.KeyValueName = keyValueName;
query.Text = text;
data = service.ReadData(query);
return(Json(new ApplicationMessage {
IsOk = true, Data = data.FirstOrDefault()
}));
}
public ActionResult ReadData(KeyValuesViewModel query)
{
HomeService service = new HomeService();
List <KeyValuesViewModel> data = new List <KeyValuesViewModel>();
data = service.ReadData(query);
var obj = new
{
data = data,
total = data.Count
};
var result = JsonConvert.SerializeObject(obj, new JsonSerializerSettings()
{
DateTimeZoneHandling = DateTimeZoneHandling.Utc
});
return(Content(result, "application/json"));
}
public bool Delete(KeyValuesViewModel data, out string errMsg)
{
KeyValuesDAO keyValuesDAO = new KeyValuesDAO();
errMsg = "";
try
{
var dbModel = keyValuesDAO.FindById(data.Id);
keyValuesDAO.Delete(dbModel);
keyValuesDAO.SaveChange();
}
catch (Exception ex)
{
errMsg = ex.Message;
return(false);
}
return(true);
}
public ActionResult Create(KeyValuesViewModel data)
{
HomeService service = new HomeService();
bool res = service.Create(data, out string errMsg);
if (res)
{
var result = JsonConvert.SerializeObject(new { IsOk = true, Message = "儲存成功" }, new JsonSerializerSettings()
{
DateTimeZoneHandling = DateTimeZoneHandling.Utc
});
return(Content(result, "application/json"));
}
else
{
var result = JsonConvert.SerializeObject(new { IsOk = false, Message = "儲存失敗" + errMsg }, new JsonSerializerSettings()
{
DateTimeZoneHandling = DateTimeZoneHandling.Utc
});
return(Content(result, "application/json"));
}
}
public List <KeyValues> QueryAll(KeyValuesViewModel query)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select ");
stringBuilder.Append(" K.Id, ");
stringBuilder.Append(" K.KeyValueName, ");
stringBuilder.Append(" K.Text, ");
stringBuilder.Append(" K.Value, ");
stringBuilder.Append(" K.Sort, ");
stringBuilder.Append(" K.EnterPriseId ");
stringBuilder.Append("from ");
stringBuilder.Append(" KeyValues K ");
stringBuilder.Append("where ");
stringBuilder.Append(" 1 = 1 ");
Dapper.DynamicParameters parameterList = new DynamicParameters();
if (!string.IsNullOrWhiteSpace(query.KeyValueName))
{
stringBuilder.AppendLine(@" and K.KeyValueName LIKE @keyVlaueName ");
parameterList.Add("@keyVlaueName", $"%{query.KeyValueName}%");
}
if (!string.IsNullOrWhiteSpace(query.Text))
{
stringBuilder.AppendLine(@" and K.Text LIKE @text ");
parameterList.Add("@text", $"%{query.Text}%");
}
stringBuilder.AppendLine(" order by K.Id, K.Sort desc ");
var res = _db.Database.Connection.Query <KeyValues>(stringBuilder.ToString(), parameterList).ToList();
return(res);
}
