/// <summary>
/// 功能：修改数据字典类信息
/// </summary>
/// <param name="dictionary"></param>
/// <returns></returns>
public string InsertDictionaryInfo(DATA_DICTIONARY dictionary)
{
long intRow = 0;
if (dictionary != null)
{
dictionary.DICTIONARY_CREATED = DateTime.Now.ToString();
dictionary.DICTIONARY_UPDATED = DateTime.Now.ToString();
intRow = _dictionaryDao.Insert(dictionary);
}
JSONObject <DATA_DICTIONARY> objs = new JSONObject <DATA_DICTIONARY>();
if (intRow > 0)
{
objs.rspCode = "000";
objs.rspDesc = "新增数据成功";
}
else
{
objs.rspCode = "101";
objs.rspDesc = "新增数据失败";
}
string result = JSONHelper.ObjectToJSON(objs);
return(result);
}
/// <summary>Finds a <see cref="DATA_DICTIONARY"/> instance by the primary key value.</summary>
public DATA_DICTIONARY Find(string dICTIONARY_ID)
{
String stmtId = "DATA_DICTIONARY.Find";
DATA_DICTIONARY result = base.ExecuteQueryForObject <DATA_DICTIONARY>(stmtId, dICTIONARY_ID);
return(result);
}
public static string Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, DATA_DICTIONARY objSave)
{
string objReturn = string.Empty;
DATA_DICTIONARYDB objDB = new DATA_DICTIONARYDB();
objReturn = objDB.Save(CURRENT_USER, CURRENT_REGISTRY_ID, objSave);
return(objReturn);
}
public static DATA_DICTIONARY GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, string ObjectName)
{
DATA_DICTIONARY objReturn = null;
DATA_DICTIONARYDB objDB = new DATA_DICTIONARYDB();
objReturn = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, ObjectName);
return(objReturn);
}
/// <summary>Delete the underlying database record of a DATA_DICTIONARY instance.</summary>
public Int64 Delete(DATA_DICTIONARY obj)
{
if (obj == null)
{
throw new ArgumentNullException("obj");
}
String stmtId = "DATA_DICTIONARY.Delete";
return(base.Delete(stmtId, obj));
}
/// <summary>
/// 功能：修改数据字典类信息
/// </summary>
/// <param name="dictionary"></param>
/// <returns></returns>
public string UpdateDictionaryInfo(DATA_DICTIONARY test)
{
JSONObject <DATA_DICTIONARY> objs = new JSONObject <DATA_DICTIONARY>();
objs.rspCode = "000";
objs.rspDesc = "成功";
string result = JSONHelper.ObjectToJSON(objs);
return(result);
}
/// <summary>
/// 功能：根据id查询数据字典主类信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string GetDictionaryInfoById(string id)
{
DATA_DICTIONARY obj = _dictionaryDao.Find(id);
JSONObject <DATA_DICTIONARY> objs = new JSONObject <DATA_DICTIONARY>();
objs.Result = obj;
objs.rspCode = "000";
objs.rspDesc = "成功";
string result = JSONHelper.ObjectToJSON(objs);
return(result);
}
public DATA_DICTIONARY ParseReaderCustom(DataRow row)
{
DATA_DICTIONARY objReturn = new DATA_DICTIONARY
{
AllowsNull = (double?)GetNullableObject(row.Field <object>("DATA_DICTIONARY_AllowsNull")),
ColumnName = (string)GetNullableObject(row.Field <object>("DATA_DICTIONARY_ColumnName")),
DataType = (string)GetNullableObject(row.Field <object>("DATA_DICTIONARY_DataType")),
Description = (string)GetNullableObject(row.Field <object>("DATA_DICTIONARY_Description")),
ObjectName = (string)GetNullableObject(row.Field <object>("DATA_DICTIONARY_ObjectName"))
};
return(objReturn);
}
public DATA_DICTIONARY GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, string ObjectName)
{
DATA_DICTIONARY objReturn = null;
SqlConnection sConn = null;
SqlCommand sCmd = null;
SqlDataAdapter sAdapter = null;
DataSet objTemp = null;
try
{
sConn = new SqlConnection(SqlConnectionString);
sConn.Open();
sCmd = new SqlCommand("CRS.usp_DATA_DICTIONARY_getitem", sConn);
sCmd.CommandTimeout = SqlCommandTimeout;
sCmd.CommandType = CommandType.StoredProcedure;
sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);
sCmd.Parameters.AddWithValue("@ObjectName", ObjectName);
objTemp = new DataSet();
sAdapter = new SqlDataAdapter(sCmd);
LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
sAdapter.Fill(objTemp);
LogManager.LogTiming(logDetails);
CheckDataSet(objTemp);
if (objTemp != null && objTemp.Tables.Count > 0 && objTemp.Tables[0].Rows.Count > 0)
{
objReturn = ParseReader(objTemp.Tables[0].Rows[0]);
}
sConn.Close();
}
catch (Exception ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
finally
{
if (sAdapter != null)
{
sAdapter.Dispose();
sAdapter = null;
}
if (sCmd != null)
{
sCmd.Dispose();
sCmd = null;
}
if (sConn != null)
{
if (sConn.State != ConnectionState.Closed)
{
sConn.Close();
}
sConn.Dispose();
sConn = null;
}
}
return(objReturn);
}
public string Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, DATA_DICTIONARY objSave)
{
string objReturn = string.Empty;
SqlConnection sConn = null;
SqlCommand sCmd = null;
SqlParameter p = null;
try
{
sConn = new SqlConnection(SqlConnectionString);
sConn.Open();
sCmd = new SqlCommand("CRS.usp_DATA_DICTIONARY_save", sConn);
sCmd.CommandTimeout = SqlCommandTimeout;
sCmd.CommandType = CommandType.StoredProcedure;
sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);
p = new SqlParameter("@AllowsNull", SqlDbType.Float, 8);
p.Precision = 53;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.AllowsNull);
p = new SqlParameter("@ColumnName", SqlDbType.NVarChar, 510);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ColumnName);
p = new SqlParameter("@DataType", SqlDbType.NVarChar, 510);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.DataType);
p = new SqlParameter("@Description", SqlDbType.NVarChar, 510);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.Description);
p = new SqlParameter("@ObjectName", SqlDbType.NVarChar, 510);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ObjectName);
LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
int cnt = sCmd.ExecuteNonQuery();
LogManager.LogTiming(logDetails);
objReturn = (string)sCmd.Parameters["@ObjectName"].Value;
sConn.Close();
}
catch (Exception ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
finally
{
if (sCmd != null)
{
sCmd.Dispose();
sCmd = null;
}
if (sConn != null)
{
if (sConn.State != ConnectionState.Closed)
{
sConn.Close();
}
sConn.Dispose();
sConn = null;
}
}
return(objReturn);
}
/// <summary>
/// 功能：新增数据字典类信息
/// </summary>
/// <param name="dictionary"></param>
/// <returns></returns>
public string InsertDictionaryInfo(DATA_DICTIONARY dictionary)
{
BIZ_DATA_DICTIONARY biz_DATA_DICTIONARY = new BIZ_DATA_DICTIONARY();
return(biz_DATA_DICTIONARY.InsertDictionaryInfo(dictionary));
}
/// <summary>
/// 功能：修改数据字典类信息
/// </summary>
/// <param name="dictionary"></param>
/// <returns></returns>
public string UpdateDictionaryInfo(DATA_DICTIONARY dictionary)
{
BIZ_DATA_DICTIONARY biz_DATA_DICTIONARY = new BIZ_DATA_DICTIONARY();
return(biz_DATA_DICTIONARY.UpdateDictionaryInfo(dictionary));
}
public static Boolean Delete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, DATA_DICTIONARY objDelete)
{
return(Delete(CURRENT_USER, CURRENT_REGISTRY_ID, objDelete.ObjectName));
}
