/// <summary>
///
/// </summary>
/// <param name="ID"> </param>
/// <returns></returns>
public static Entity.Position GetPosition(int ID)
{
Entity.Position entity = null;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [Position] where ID='" + ID + "'", null);
while (dataReader.Read())
{
entity = new Entity.Position();
entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString());
entity.Name = dataReader["Name"].ToString();
entity.OrderID = DataHelper.ParseToInt(dataReader["OrderID"].ToString());
entity.IsShow = DataHelper.ParseToInt(dataReader["IsShow"].ToString());
}
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(entity);
}
public static int AddPosition(Entity.Position entity)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con);
IDbTransaction trans = thelper.StartTransaction();
try
{
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Insert into [Position]([Name],[OrderID],[IsShow]) values ('" + entity.Name + "','" + entity.OrderID + "','" + entity.IsShow + "')", null);
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
public static int UpdatePosition(Entity.Position entity)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con);
IDbTransaction trans = thelper.StartTransaction();
try
{
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [Position] set Name='"+ entity.Name + "',OrderID='" + entity.OrderID + "',IsShow='" + entity.IsShow + "'where ID='" + entity.ID + "'", null);
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
