/// <summary>
/// 新增字典信息
/// </summary>
/// <param name="varEmpRegisterModel">字典信息信息实体</param>
/// <returns>true成功 false失败</returns>
/// <Remark>郝毅志，2017/06/24</ Remark >
public bool InsertDictionary(SYS_DICTIONARY varDictionaryModel, SQLiteCommand varCommand)
{
StringBuilder tmpStrSql = new StringBuilder();
tmpStrSql.Append("INSERT INTO SYS_DICTIONARY(");
tmpStrSql.Append("DICTIONARY_ID,KEY_CD,KEY_NAME,ITEM_CD,ITEM_NAME,ITEM_VAL,STAT,ORDER_NUM,VERSION_NO)");
tmpStrSql.Append(" values (");
tmpStrSql.Append("@DICTIONARY_ID,@KEY_CD,@KEY_NAME,@ITEM_CD,@ITEM_NAME,@ITEM_VAL,@STAT,@ORDER_NUM,@VERSION_NO)");
SQLiteParameter[] tmpParameters =
{
new SQLiteParameter("@DICTIONARY_ID", DbType.String, 60),
new SQLiteParameter("@KEY_CD", DbType.String, 100),
new SQLiteParameter("@KEY_NAME", DbType.String, 100),
new SQLiteParameter("@ITEM_CD", DbType.String, 100),
new SQLiteParameter("@ITEM_NAME", DbType.String, 100),
new SQLiteParameter("@ITEM_VAL", DbType.String, 500),
new SQLiteParameter("@STAT", DbType.String, 1),
new SQLiteParameter("@ORDER_NUM", DbType.Int32),
new SQLiteParameter("@VERSION_NO", DbType.DateTime)
};
tmpParameters[0].Value = varDictionaryModel.DictionaryId;
tmpParameters[1].Value = varDictionaryModel.KeyCd;
tmpParameters[2].Value = varDictionaryModel.KeyName;
tmpParameters[3].Value = varDictionaryModel.ItemCd;
tmpParameters[4].Value = varDictionaryModel.ItemName;
tmpParameters[5].Value = varDictionaryModel.ItemVal;
tmpParameters[6].Value = varDictionaryModel.Stat;
tmpParameters[7].Value = varDictionaryModel.OrderNum;
tmpParameters[8].Value = T_Date.ConvertLongToDateTime(varDictionaryModel.VersionNo);
//执行命令配置
varCommand.CommandText = tmpStrSql.ToString();
varCommand.CommandType = CommandType.Text;
foreach (SQLiteParameter parm in tmpParameters)
{
varCommand.Parameters.Add(parm);
}
int tmpRows = 0;
try
{
tmpRows = varCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
_log.Error(typeof(D_Dictionary), ex);
return(false);
}
if (tmpRows > 0)
{
return(true);
}
else
{
return(false);
}
}
public OperationResult Insert(SYS_DICTIONARYModel model)
{
var entity = new SYS_DICTIONARY
{
DictionaryName = model.DictionaryName,
DictionaryValue = model.DictionaryValue,
Remark = model.Remark,
};
SYS_DICTIONARYRepository.Insert(entity);
return(new OperationResult(OperationResultType.Success, "Added successfully"));
}
