/// <summary> /// 增加一条数据 /// </summary> /// <param name="sql"></param> public bool Add(CarRepairRecord model) { try { var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("CarID", model.CarID)); parameters.Add(new QfParameter("RepairID", model.RepairID)); parameters.Add(new QfParameter("RepairPlace", string.Format(@"'{0}'", model.RepairPlace))); parameters.Add(new QfParameter("RepairDate", string.Format(@"'{0}'", model.RepairDate))); parameters.Add(new QfParameter("ItemStr", string.Format(@"'{0}'", model.ItemStr))); parameters.Add(new QfParameter("RepairKil", model.RepairKil)); parameters.Add(new QfParameter("Result", string.Format(@"'{0}'", model.Result))); parameters.Add(new QfParameter("PartsCost", model.PartsCost)); parameters.Add(new QfParameter("CreatID", model.CreatID)); parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note))); parameters.Add(new QfParameter("OperateID", model.OperateID)); parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime))); string colStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.ParameterName)); string atColStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.Value)); string sql = string.Format("insert into t_car_repair_record({0}) values ({1})", colStr, atColStr); int row = MysqlHelper.ExecuteNonQuery(sql); return(row == 1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
/// <summary> /// 删除一条数据 /// </summary> /// <param name="sql"></param> public bool Delete(CarRepairRecord model) { try { string sql = string.Format("delete from t_car_repair_record where RepairID = {0}", model.RepairID); int row = MysqlHelper.ExecuteNonQuery(sql); return(row == 1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> /// <param name="sql"></param> public CarRepairRecord GetModel(int RepairID) { try { string sql = string.Format("select * from t_car_repair_record where RepairID = {0} limit 1", RepairID); DataTable dt = MysqlHelper.ExecuteDataTable(sql); CarRepairRecord model = ModelConvert.ToModel <CarRepairRecord>(dt); return(model); } catch (Exception ex) { MessageBox.Show(ex.Message); return(null); } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="sql"></param> public bool Update(CarRepairRecord model) { try { var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("CarID", model.CarID)); parameters.Add(new QfParameter("RepairID", model.RepairID)); parameters.Add(new QfParameter("RepairPlace", string.Format(@"'{0}'", model.RepairPlace))); parameters.Add(new QfParameter("RepairDate", string.Format(@"'{0}'", model.RepairDate))); parameters.Add(new QfParameter("ItemStr", string.Format(@"'{0}'", model.ItemStr))); parameters.Add(new QfParameter("RepairKil", model.RepairKil)); parameters.Add(new QfParameter("Result", string.Format(@"'{0}'", model.Result))); parameters.Add(new QfParameter("PartsCost", model.PartsCost)); parameters.Add(new QfParameter("CreatID", model.CreatID)); parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note))); parameters.Add(new QfParameter("OperateID", model.OperateID)); parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime))); string setStr = ""; foreach (var item in parameters) { if (item.Value != null && ValueConvert.ToString(item.Value) != "''") { setStr += string.Format(" {0} = {1},", item.ParameterName, item.Value); } } setStr = setStr.Substring(0, setStr.LastIndexOf(",")); string sql = string.Format("update t_car_repair_record set {0} where RepairID = {1}", setStr, model.RepairID); int row = MysqlHelper.ExecuteNonQuery(sql); return(row == 1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }