/// <summary> /// 添加 /// </summary> /// <param name="meterial"></param> /// <returns>添加是否成功</returns> public bool Insert(Meterial meterial) { string SQL = SQLBuilder.BuildInsertSQL(meterial, TableName); int result = Connection.ExecuteSql(SQL, meterial); return(result == 1 ? true : false); }
///// <summary> ///// 删除 ///// </summary> ///// <param name="condition">删除条件</param> ///// <returns>删除是否成功</returns> //public bool Delete(dynamic condition) //{ // //string SQL = SQLBuilder.BuildDeleteSQL(condition, TableName); // //将是否删除设置为1 // string SQL = SQLBuilder.BuildUpdateSQL(new { is_deleted = true }, condition, TableName); // int result = Connection.ExecuteSql(SQL, new { is_deleted = true, bill_id = condition.bill_id }); // return result == 1 ? true : false; //} /// <summary> /// 添加 /// </summary> /// <param name="bill"></param> /// <returns>添加是否成功</returns> public bool Insert(Bill bill) { string SQL = SQLBuilder.BuildInsertSQL(bill, TableName); int result = Connection.ExecuteSql(SQL, bill); return(result == 1 ? true : false); }
/// <summary> /// 添加 /// </summary> /// <param name="dishes"></param> /// <returns>添加是否成功</returns> public bool Insert(Dishes dishes) { string SQL = SQLBuilder.BuildInsertSQL(dishes, TableName); int result = Connection.ExecuteSql(SQL, dishes); return(result == 1 ? true : false); }
/// <summary> /// 添加 /// </summary> /// <returns>添加是否成功</returns> public bool Insert(Consume consume) { string SQL = SQLBuilder.BuildInsertSQL(consume, TableName); int result = Connection.ExecuteSql(SQL, consume); return(result == 1 ? true : false); }
/// <summary> /// 添加 /// </summary> /// <param name="order"></param> /// <returns>添加是否成功</returns> public bool Insert(Order order) { string SQL = SQLBuilder.BuildInsertSQL(order, TableName); int result = Connection.ExecuteSql(SQL, order); return(result == 1 ? true : false); }
/// <summary> /// 添加 /// </summary> /// <param name="desk"></param> /// <returns>添加是否成功</returns> public bool Insert(Desk desk) { //其余取默认值 var deskI = new { desk_id = desk.desk_id, desk_name = desk.desk_name }; string SQL = SQLBuilder.BuildInsertSQL(deskI, TableName); int result = Connection.ExecuteSql(SQL, deskI); return(result == 1 ? true : false); }
/// <summary> /// 添加 /// </summary> /// <param name="visitRecord"></param> /// <returns>添加是否成功</returns> public bool Insert(VisitRecord visitRecord) { //不插入访问时间,数据库自动填充默认值 var visit = new { visit_record_id = visitRecord.visit_record_id, desk_id = visitRecord.desk_id, consumer_num = visitRecord.consumer_num }; string SQL = SQLBuilder.BuildInsertSQL(visit, TableName); int result = Connection.ExecuteSql(SQL, (Object)visit); return(result == 1 ? true : false); }
/// <summary> /// 添加 /// </summary> /// <param name="employee"></param> /// <returns>添加是否成功</returns> public bool Insert(Employee employee) { var em = new { employee_id = employee.employee_id, employee_name = employee.employee_name, gender = employee.gender, titel_name = employee.titel_name, wage = employee.wage, password = employee.password }; string SQL = SQLBuilder.BuildInsertSQL(em, TableName); int result = Connection.ExecuteSql(SQL, em); return(result == 1 ? true : false); }