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"]); }