public bool AddDict(DictEntity dictEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" @JournalID");
sqlCommandText.Append(", @DictKey");
sqlCommandText.Append(", @Note");
sqlCommandText.Append(", @InUserID");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.Dict ({0}) VALUES ({1})",sqlCommandText.ToString().Replace("@", ""),sqlCommandText.ToString()));
db.AddInParameter(cmd,"@JournalID",DbType.Int64,dictEntity.JournalID);
db.AddInParameter(cmd,"@DictKey",DbType.AnsiString,dictEntity.DictKey);
db.AddInParameter(cmd,"@Note",DbType.AnsiString,dictEntity.Note);
db.AddInParameter(cmd,"@InUserID",DbType.Int64,dictEntity.InUserID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch(SqlException sqlEx)
{
throw sqlEx;
}
return flag;
}
public ActionResult Save(DictEntity model)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
if (model.DictID == 0)
model.InUserID = CurAuthor.AuthorID;
else
model.EditUserID = CurAuthor.AuthorID;
//model.JournalID = CurAuthor.JournalID;
model.DictKey = "Notice" + Guid.NewGuid().ToString();
ExecResult result = service.SaveDict(model);
return Json(new { result = result.result, msg = result.msg });
}
public ActionResult Create(Int64 dictId = 0)
{
DictEntity model=null;
if (dictId > 0)
{
DictQuery query = new DictQuery();
query.JournalID = CurAuthor.JournalID;
query.DictID = dictId;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
model = service.GetDictModel(query);
}
if (model == null)
model = new DictEntity();
return View(model);
}
/// <summary>
/// 更新存储媒介中的实体数据
/// </summary>
/// <param name="dict">DictEntity实体对象</param>
/// <returns>true:更新成功 false：更新失败</returns>
public bool UpdateDict(DictEntity dict)
{
return DictDataAccess.Instance.UpdateDict(dict);
}
public ExecResult SaveDict(DictEntity model)
{
ExecResult execResult = new ExecResult();
IDictService service = ServiceContainer.Instance.Container.Resolve<IDictService>();
return service.Save(model);
}
public bool UpdateDict(DictEntity dictEntity)
{
bool flag = false;
StringBuilder whereCommandText = new StringBuilder();
whereCommandText.Append(" DictID=@DictID");
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" DictKey=@DictKey");
sqlCommandText.Append(", Note=@Note");
sqlCommandText.Append(", EditUserID=@EditUserID");
sqlCommandText.Append(", EditDate=getdate()");
DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.Dict SET {0} WHERE {1}",sqlCommandText.ToString(),whereCommandText.ToString()));
db.AddInParameter(cmd,"@DictID",DbType.Int64,dictEntity.DictID);
db.AddInParameter(cmd,"@DictKey",DbType.AnsiString,dictEntity.DictKey);
db.AddInParameter(cmd,"@Note",DbType.AnsiString,dictEntity.Note);
db.AddInParameter(cmd,"@EditUserID",DbType.Int64,dictEntity.EditUserID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch(SqlException sqlEx)
{
throw sqlEx;
}
return flag;
}
public List<DictEntity> MakeDictList(IDataReader dr)
{
List<DictEntity> list=new List<DictEntity>();
while(dr.Read())
{
DictEntity dictEntity=new DictEntity();
dictEntity.DictID = (Int64)dr["DictID"];
dictEntity.JournalID = (Int64)dr["JournalID"];
dictEntity.DictKey = (String)dr["DictKey"];
dictEntity.Note = (String)dr["Note"];
dictEntity.InUserID = (Int64)dr["InUserID"];
dictEntity.EditUserID = (Int64)dr["EditUserID"];
dictEntity.EditDate = (DateTime)dr["EditDate"];
dictEntity.AddDate = (DateTime)dr["AddDate"];
list.Add(dictEntity);
}
dr.Close();
return list;
}
/// <summary>
/// 保存数据字典
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult Save(DictEntity model)
{
ExecResult execResult = new ExecResult();
model.DictKey = model.DictKey.TextFilter();
if (DictkeyIsExists(model))
{
execResult.result = EnumJsonResult.error.ToString();
execResult.msg = "该数据字典名称已存在！";
return execResult;
}
bool result = false;
model.Note = model.Note.TextFilter();
if (model.DictID == 0)
{
result = AddDict(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "新增数据字典成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "新增数据字典失败！";
}
}
else
{
result = UpdateDict(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "修改数据字典成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "修改数据字典失败！";
}
}
return execResult;
}
/// <summary>
/// 数据字典是否已经存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool DictkeyIsExists(DictEntity model)
{
return DictDataAccess.Instance.DictkeyIsExists(model);
}
/// <summary>
/// 数据字典是否已经存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool DictkeyIsExists(DictEntity model)
{
string strSql = "SELECT 1 FROM dbo.Dict a with(nolock) WHERE JournalID=@JournalID and DictKey=@DictKey";
if (model.DictID > 0)
{
strSql += " and DictID<>" + model.DictID;
}
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "@JournalID", DbType.Int64, model.JournalID);
db.AddInParameter(cmd, "@DictKey", DbType.AnsiString, model.DictKey);
object obj = db.ExecuteScalar(cmd);
if (obj == null) return false;
return obj.TryParse<Int32>() == 1;
}
public bool DeleteDict(DictEntity dictEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("DELETE FROM dbo.Dict");
sqlCommandText.Append(" WHERE DictID=@DictID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd,"@DictID",DbType.Int64,dictEntity.DictID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch(SqlException sqlEx)
{
throw sqlEx;
}
return flag;
}
/// <summary>
/// 保存数据字典
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult SaveDict(DictEntity model)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post<ExecResult, DictEntity>(GetAPIUrl(APIConstant.DICT_SAVE), model);
return result;
}
/// <summary>
/// 从存储媒介删除实体数据
/// </summary>
/// <param name="dict">DictEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteDict(DictEntity dict)
{
return DictBusProvider.DeleteDict(dict);
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="dict">DictEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddDict(DictEntity dict)
{
return DictBusProvider.AddDict(dict);
}
/// <summary>
/// 更新存储媒介中的实体数据
/// </summary>
/// <param name="dict">DictEntity实体对象</param>
/// <returns>true:更新成功 false：更新失败</returns>
public bool UpdateDict(DictEntity dict)
{
return DictBusProvider.UpdateDict(dict);
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="dict">DictEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddDict(DictEntity dict)
{
return DictDataAccess.Instance.AddDict(dict);
}
/// <summary>
/// 从存储媒介删除实体数据
/// </summary>
/// <param name="dict">DictEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteDict(DictEntity dict)
{
return DictDataAccess.Instance.DeleteDict(dict);
}
public DictEntity MakeDict(IDataReader dr)
{
DictEntity dictEntity = null;
if(dr.Read())
{
dictEntity=new DictEntity();
dictEntity.DictID = (Int64)dr["DictID"];
dictEntity.JournalID = (Int64)dr["JournalID"];
dictEntity.DictKey = (String)dr["DictKey"];
dictEntity.Note = (String)dr["Note"];
dictEntity.InUserID = (Int64)dr["InUserID"];
dictEntity.EditUserID = (Int64)dr["EditUserID"];
dictEntity.EditDate = (DateTime)dr["EditDate"];
dictEntity.AddDate = (DateTime)dr["AddDate"];
}
dr.Close();
return dictEntity;
}
public DictEntity MakeDict(DataRow dr)
{
DictEntity dictEntity=null;
if(dr!=null)
{
dictEntity=new DictEntity();
dictEntity.DictID = (Int64)dr["DictID"];
dictEntity.JournalID = (Int64)dr["JournalID"];
dictEntity.DictKey = (String)dr["DictKey"];
dictEntity.Note = (String)dr["Note"];
dictEntity.InUserID = (Int64)dr["InUserID"];
dictEntity.EditUserID = (Int64)dr["EditUserID"];
dictEntity.EditDate = (DateTime)dr["EditDate"];
dictEntity.AddDate = (DateTime)dr["AddDate"];
}
return dictEntity;
}
/// <summary>
/// 数据字典是否已经存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool DictkeyIsExists(DictEntity model)
{
return DictBusProvider.DictkeyIsExists(model);
}