public SYS_Position SelectSYS_Position(int ID)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
SYS_Position sys_position = new SYS_Position();
DbDataReader reader = null;
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false));
reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Position_GetByID]", para.ToArray());
if (reader.HasRows && reader.Read())
{
SYS_PositionDataAccess.SetSYS_PositionInfo(reader, ref sys_position);
}
return(sys_position);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_PositionDataAccess.SelectById: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
private static void SetListSYS_PositionInfo(ref DbDataReader reader, ref List <SYS_Position> sys_positions)
{
SYS_Position sys_position = null;
while (reader.Read())
{
sys_position = new SYS_Position();
SYS_PositionDataAccess.SetSYS_PositionInfo(reader, ref sys_position);
sys_positions.Add(sys_position);
}
}
public void UpdateSYS_Position(DbTransaction transaction, SYS_Position sys_position)
{
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_position.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_position.Name, false));
_DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_Position_Update]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_PositionDataAccess.Update: {0}", ex.Message));
}
}
public void DeleteSYS_Position(SYS_Position sys_position)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_position.ID, false));
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Position_Delete]", para.ToArray());
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
public int InsertSYS_Position(DbTransaction transaction, SYS_Position sys_position)
{
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_position.Name, false));
para.Add(ouput);
_DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_Position_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_PositionDataAccess.Insert: {0}", ex.Message));
}
}
/// <summary>
/// 得到一个对象实体，从缓存中
/// </summary>
public TDTK.PlatForm.MVC4.Model.SYS_Position GetModelByCache(string PositionCode)
{
SYS_Position sp = new SYS_Position();
sp.PositionCode = PositionCode;
string CacheKey = "SYS_PositionModel-" + PositionCode;
object objModel = Maticsoft.Common.DataCache.GetCache(CacheKey);
if (objModel == null)
{
try
{
objModel = dal.GetModel(sp);
if (objModel != null)
{
int ModelCache = Maticsoft.Common.ConfigHelper.GetConfigInt("ModelCache");
Maticsoft.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero);
}
}
catch { }
}
return (TDTK.PlatForm.MVC4.Model.SYS_Position)objModel;
}
public int InsertSYS_Position(SYS_Position sys_position)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_position.Name, false));
para.Add(ouput);
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Position_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_PositionDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public void UpdateSYS_Position(SYS_Position sys_position)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_position.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_position.Name, false));
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Position_Update]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_PositionDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public int InsertSYS_Position(SYS_Position sys_position)
{
return(_sys_positionDataAccess.InsertSYS_Position(sys_position));
}
public SYS_Position GetModel(SYS_Position t)
{
return dal.GetModel(t);
}
public bool Delete(SYS_Position t)
{
return dal.Delete(t);
}
public bool Update(SYS_Position t)
{
return dal.Update(t);
}
public int Add(SYS_Position t)
{
return dal.Add(t);
}
public bool Exists(SYS_Position t)
{
return dal.Exists(t);
}
public void DeleteSYS_Position(SYS_Position sys_positions)
{
_sys_positionDataAccess.DeleteSYS_Position(sys_positions);
}
public void UpdateSYS_Position(SYS_Position sys_position)
{
_sys_positionDataAccess.UpdateSYS_Position(sys_position);
}
private static void SetSYS_PositionInfo(DbDataReader reader, ref SYS_Position sys_position)
{
sys_position.ID = int.Parse("0" + reader[FIELD_ID]);
sys_position.Name = "" + reader[FIELD_NAME];
}
