private int RunCommandWithTransatcion(VSM.Entities.BuGastankRepair ent, string vSql, IDbTransaction TRANS)
{
if (null == TRANS)
{
MySqlParameter[] paras = new MySqlParameter[ent.Column.Count];
for (int i = 0; i < ent.Column.Count; i++)
{
paras[i] = new MySqlParameter();
paras[i].ParameterName = ent.Column[i].FieldName;
paras[i].DbType = ent.Column[i].FieldType;
paras[i].Value = ent.Column[i].FieldValue;
}
return(DataBaseManage.ExecuteSql(vSql, paras));
}
else
{
System.Data.IDbCommand CM = TRANS.Connection.CreateCommand();
CM.CommandText = vSql;
CM.CommandType = CommandType.Text;
CM.Transaction = TRANS;
GetEntityDeleteParameter(CM, ent);
try
{
return(CM.ExecuteNonQuery());
}
catch (System.Exception e)
{
if (isDebug)
{
throw new Exception(e.Message);
}
return(0);
}
}
}
/// <summary>
/// 得到列表
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public List<BuGastankRepair> GetBuGastankRepairList(string Where)
{
List<BuGastankRepair> list = new List<BuGastankRepair>();
using(DbDataReader reader = DataBaseManage.ExecuteReader(DalSql+Where))
{
while (reader.Read())
{
BuGastankRepair ent = new BuGastankRepair();
SetEnt(ent, reader);
list.Add(ent);
}
}
return list;
}
/// <summary>
/// 根据GasRepairId得到 BuGastankRepair 实体
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public BuGastankRepair GetBuGastankRepair(int GasRepairId)
{
BuGastankRepair ent = null;
string sql = DalSql;
sql = sql + " And GasRepairId";
MySqlParameter[] paras = new MySqlParameter[]
{
new MySqlParameter("GasRepairId",GasRepairId)
};
using(DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
{
if (reader.Read())
{
ent = new BuGastankRepair();
SetEnt(ent, reader);
}
}
return ent;
}
public void SetEnt(BuGastankRepair ent, IDataReader dr)
{
ent.GasRepairId = MyConvert.ToInt(dr["GasRepairId"]);
ent.GasRepairDate = MyConvert.ToDateTime(dr["GasRepairDate"]);
ent.TankNumber = MyConvert.ToString(dr["TankNumber"]);
ent.DutyOfficer = MyConvert.ToString(dr["DutyOfficer"]);
ent.Remark = MyConvert.ToString(dr["Remark"]);
}